Home Forums Article Discussions Article Discussions by Author Discuss content posted by Stan Kulp Simplify Large Queries with Temporary Tables, Table Variables and CTEs RE: Simplify Large Queries with Temporary Tables, Table Variables and CTEs
Patibandla
Old Hand
Points: 332
More actions
August 10, 2011 at 7:53 am
#1366561
@sqlist
But with select into you cannot have an identity column , you have to use row_number otherwise , which may affect the performance when you are dealing with large number of rows.