We have seen example of Changing Rows to Columns Using PIVOT. Hope you liked that post and you enjoyed a lot also. As we know that we need to hard-code the values for pivoting which we have did for color values. for the values updates in table or whenever values changed in the table for the column which we use in pivot then we have to update the script as per that otherwise it wont work or do not give correct information. Also I got same comment from user for the post which you can reach from above link. Continue Reading...
Tags: sql, ms sql, scripts, query, ms sql server, #SQL Server, #sql, database, sql server general, Pivot, Dynamic
This is very helpful: simple and easy
What would be server overheads on this. I plan using this for 10,000+ rows. SQL 2008. I do not want to overkill the server.