Discussion on:
View:
Show:
Yeah,a great leap forward!:).You must know your pivot columns ahead of time!Where as in Access they are created dynamically if desired.For a true replacement of the Access crosstab dynamic pivot functionality on sql server check out the RAC utility at www.rac4sql.net.Like Access but much more powerful with many features/options.And RAC can simplify many other common problems besides crosstabs.
re:You must know your pivot columns ahead of time
----- ----- ----- ----- -----
Not necessarily. This is because Yukon's TSQL integrates with CLR (Common Language Runtime).
In this article (http://builder.com.com/5100-6388_14-5168118-1-1.html) you can see how to embed .NET code right into the SQL statements. You can use it to programatically determine the necessary columns. In some cases (and with somewhat less demand on system resources), you could even use TSQL's procedural code to get the columns or column names.
----- ----- ----- ----- -----
Not necessarily. This is because Yukon's TSQL integrates with CLR (Common Language Runtime).
In this article (http://builder.com.com/5100-6388_14-5168118-1-1.html) you can see how to embed .NET code right into the SQL statements. You can use it to programatically determine the necessary columns. In some cases (and with somewhat less demand on system resources), you could even use TSQL's procedural code to get the columns or column names.
- Keyboard Shortcuts:
- Prev
- Next
- Toggle
