Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Transposing a table result

Author  Topic 

katende
Starting Member

1 Post

Posted - 2014-10-01 : 07:14:13
Hi there,
i am new to sql and would like to get support on how i can transpose a table. In particular i would like to know the script or query that transposes a table result. For example a client x who has done several lab tests on different dates gets different test results. I would like to see the different test results on different dates in a single table.
Thanks,
Timothy

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2014-10-01 : 07:20:21
Please post some sample data and expected output.
Also see this thread to get an idea on transpose: [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=196487[/url]

Harsh Athalye
http://in.linkedin.com/in/harshathalye/
Go to Top of Page
   

- Advertisement -