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

What is the use of sql profiler in sql server 2012?

0 Answers  

---

Explain the concept of recursive stored procedure.

0 Answers  

---

Why do you want to join software field as you have done your BE in Electronics?

0 Answers   Cap Gemini, HCL,

---

Explain the cursor lock types?

0 Answers  

---

What is difference between after and before?

0 Answers  

---

What is dirty read?

0 Answers  

---

wat is tuff file in log shipping, wt is d use of tht file?

1 Answers   TCS,

---

What is the boxing and unboxing concept in .net?

0 Answers  

---

Is it safe to delete log files?

0 Answers  

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

0 Answers  

---

When is update_statistics command used?

0 Answers  

---