hi friends,
I have a table whose one field is 'monthname' containing month names. I want to get these month names as field values with an SQLQry. no Stored procedures or functions can be used.
Normal Result: (Select monthname Month,Count(ID) Count From TestData Group By Monthname)
My Required Format:
(this month name is just an example, it can be anything. like year or Flight Name. I mean i cant hard code like 'Select * From TestData where monthName = 'Jan'')
Got me...?
Thanking,
:)
Search these forums for pivot. Or advanced search where I say something about pivot in this forum.
No comments:
Post a Comment