I need to be able to select into a temporary table (which is really a copy of the base table, not really 'temporary'). The problem I'm running into is that the base table uses GUIDs for the Primary Key, and upon attempting to run a:
I keep getting a
The only thing I can come up with is because the table has a GUID for the Primary Key.
Has anybody ran into this before, or have any tips on circumventing the issue?
The problem has been found and will be fixed in 10.0.1.4088. Later versions (11.*, etc.) already contained the fix. The problem did not affect SELECT ... INTO when creating temporary tables, and happened when the source query's SELECT list contained UNIQUEIDENTIFIER columns.
Can't you use
answered 23 Jun '10, 10:23