Answer / gopi muluka

Check this

DECLARE @Character TABLE
(
Ch VARCHAR(50)
)

INSERT INTO @Character
SELECT 'a' UNION
SELECT 'b' UNION
SELECT 'c' UNION
SELECT 'd' UNION
SELECT 'e' UNION
SELECT 'f' UNION
SELECT 'g' UNION
SELECT 'h' UNION
SELECT 'i' UNION
SELECT 'j' UNION
SELECT 'k' UNION
SELECT NULL

SELECT A.Ch,B.Ch,MAX(C.Ch)
FROM @Character A
CROSS JOIN @Character B
CROSS JOIN @Character C
WHERE ASCII(A.Ch)+1=ASCII(B.Ch) AND ASCII(A.Ch)% 3=1
AND ASCII(B.Ch)+1=ISNULL(ASCII(C.Ch),ASCII(B.Ch)+1) AND
ASCII(B.Ch)% 3=2
GROUP BY A.Ch,B.Ch

Explain what is the difference between union and union all?

0 Answers  

---

What is the architecture of ms sql reporting service?

0 Answers  

---

What are the difficulties faced in cube development? : sql server analysis services, ssas

0 Answers  

---

what is normalization? Explain different levels of normalization? : Sql server database administration

0 Answers  

---

What is logshipping and its purpose?

0 Answers  

---

Explain raiserror in sql server?

0 Answers  

---

Explain filtered indexes?

0 Answers  

---

What is de-normalization and when do you do it?

3 Answers  

---

How do you implement session management in SQL Server mode?

0 Answers   Cap Gemini,

---

Questions regarding Raiseerror?

1 Answers  

---

explain different types of jions with examples briefly?

2 Answers   Accenture, Excellence, Zensar,

---

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

0 Answers   IntraLogic, Oracle,

---