What you are referring to is called a cross tab or pivot. See the articles in my signature about those topics.

atikpatil2005 (3/4/2013)

---

I am T.E. I.T. student & these sem we have dbms subject but i am so confussed how to write date & time querry in sql server...

vinodkel (3/1/2013)

---

thanks for your kind reply:-)

agreed, constraint can be used instead of trigger.

but the requirement is something different, if i use constraint it will check the defined uniqueness within the...

Lowell, you would have to add a where clause to only return those rows that match. Notice below this will return a cartesian product.

select *

from @test1 t

OUTER apply dbo.delimitedsplit8k('d;c;b;a;e',';')...

To do this you will first need to parse your delimited string. The easiest way to parse a delimited string like is to use DelimitedSplit8K. You can find out about...

ScottPletcher (3/1/2013)

---

Sean Lange (3/1/2013)

---

I don't think will quite work Scott. The OP said they are using month(MyDate) which will return an int. Casting a single...

RZ52 (3/1/2013)

---

Dear Sean,

Thanks for help.

I know how much headache I will get to find a stable solution but your suggestion is a really helpful starting point.

I will work on...

I don't think will quite work Scott. The OP said they are using month(MyDate) which will return an int. Casting a single digit int to...

What a nightmare!!! Nothing like creating queries against a moving target. I know it isn't your design but the nightmare you are dealing with is because of the lack of...

RZ52 (3/1/2013)

---

Hi,

I have three tables and the structures are :

Table1 : [PATIENT_ID],[Name],[Age],[City],[TEST1],[TEST2]...... (the AB? are test names dynamically added to table)

Table2 : [PATIENT_ID],[Name],[Age],[DR1],[DR2],...... (the DR? are drug names dynamically added...

Jeff Moden (3/1/2013)

---

Sean Lange (3/1/2013)

---

You should...

You should read the article about...

sql1411 (2/28/2013)

---

Hi Lowell,

Thanks for your response. This is what I needed. However, is it possible to embed this logic to create a scalar valued function so that I can use...

Try this one!!! http://www.sqlservercentral.com/articles/T-SQL/62867/%5B/url%5D

Glad that my...

kk2286 (2/28/2013)

---

Thanks for you quick reply.

I have inserted few records and chnged the date time column.

Time_Stamp Row_Count

2013-02-28 09:44:08.760 22

2013-02-28 10:44:20.017...