Dear All,
I have a requirement, in which i have to add columns dynamically depending the records of a master table in sql server 2000.
Pl, do help me
If you mean a query, than there is no way to do that beside dynamic SQL. if you want to use dynamic SQL, make sure you first read the article of Erland to fully understand what you are doing:http://www.sommarskog.se/dynamic_sql.html
HTH, Jens SUessmeyer.
http://www.sqlserver2005.de
|||
A.K.A Cross Tab query
Research SELECT CASE WHEN THEN END AS []
Adamus
No comments:
Post a Comment