CrossTab Sql Server 2000
-
Hey guys... I have a very simple question with probably a very difficult answer (for me :)) I have a view, containing three fields I want to create a crosstab with. A Date (should be the 'row' header) A Name (should be the 'column' header) and a Total (number) field. Can anyone 'introduce' me into SQL, cause i'm very very very new into these kind of queries (probably SP's) I love it when a plan comes together
-
Hey guys... I have a very simple question with probably a very difficult answer (for me :)) I have a view, containing three fields I want to create a crosstab with. A Date (should be the 'row' header) A Name (should be the 'column' header) and a Total (number) field. Can anyone 'introduce' me into SQL, cause i'm very very very new into these kind of queries (probably SP's) I love it when a plan comes together
Either install Reporting Service to SQL Server or endure the agony I had to by using the following techniques. Take a look at the following article which will do the cross tab queries. I implemented them with success. http://www.sqlteam.com/item.asp?ItemID=2955[^] Good Luck Michael I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious. Vince Lombardi (1913-1970)