April 20, 2010 at 8:27 am
Hi,
I have following set of tables and data in it
table1
col1
col2
col1 has a,b,c values
col2 has x,y,z values
i need the value as
col1 x y z total
a count(a) which has x count(a) which has y count(a) which has z
b do
c do
total total total total
Can you help with a query for this
April 20, 2010 at 8:56 am
You might want to check out this link for help in pivoting a query.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply