Home Forums SQL Server 2008 T-SQL (SS2K8) Importing only rows with column data in specific columns. RE: Importing only rows with column data in specific columns.
Lynn Pettis
SSC Guru
Points: 442467
More actions
September 10, 2012 at 9:55 am
#1535788
ScottPletcher (9/10/2012)The UNPIVOT (one table scan) looks much better to me than fully scanning the table once for every grade column.
ScottPletcher (9/10/2012)
Probably, but I am still new at writing pivot/unpivot queries so I will leave that one to others.