Ok using SQL Server 2000, I think then you have limited options. You cannot use PIVOT because it was introduced in 2005 version. I think you have to create a report using report builder which can dynamically create columns as per the date. I will try to get you an example as soon as I can.
Good Luck :) .. Visit www.sqlsaga.com for more t-sql code snippets and BI related How to articles.
No comments:
Post a Comment