Tuesday, October 02, 2007

Use SQL subselects to consolidate queries

Normalized data giving you problems? Learn how to use the SQL subselect statement and handle your database like a pro!

read more | digg story

No comments:

INSERT EXEC failed because the stored procedure altered the schema of the target table.

This morning I was trying to call a stored procedure and insert the results in a temp table using the following code  -- create table #...