Re-design your database first. Add primary keys to your tables: I've never seen a good reason not to add a primary key to a table.

It looks like some queries work for some people and other queries work for some other people: the only thing I know is I would never put any of these...

Ctrl + L if you just want the estimated execution plan

The concepts involved are really basic, so basic that I wouldn't even understand why sitting at your desk typing queries without perfect knowledge of these concepts.

Really funny! I've been a member since 2002 and I've never answered qod before: I answered two questions in the last ten days and both were wrong!

There's something wrong with...

I see that others found out there's no way to get the number of rows in a cursor with sp_describe_cursor_columns, but I'll be glad to admit I was wrong if...

I found temp tables very handy to work around long running queries ad I learned how to use them to cut down complex problems, but there are some things you...

Nice way to get it to work!

I don't see why it shouldn't be used in production environment, it just needs to be a bit refined... I wouldn't include connection strings...