Determine when to use stored procedure to complete sql server tasks?

0 Answers  

---

How to create a view with data from multiple tables?

0 Answers  

---

List some case manipulation functions in sql?

0 Answers  

---

Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 Answers   TCS,

---

What is self contained multi valued query?

0 Answers  

---

Are semicolons required at the end of sql statements in sql server 2005?

0 Answers  

---

How to insert multiple rows with a subquery?

0 Answers  

---

Explain how does the report manager work in ssrs?

0 Answers  

---

How to provide column names in insert statements in ms sql server?

0 Answers  

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

What is difference between getdate and sysdatetime in sql server 2008?

0 Answers  

---

Which virtual table does a trigger use?

3 Answers  

---