Agreed that this is not normal or not normally good. But if you HAVE to, you also could use a Global temp table. Create table ##testing

Paul

Good article Roy.

Jack, ad hoc queries are compiled. I believe this started in 2000, if not, then definitely 2005.

Also, that brings up another point, I guess this...

Thanks for the article. Jolly good show man. (c;

We have many intersecting datetime queries and we are usually looking for ANY event that intersects a given...

Brock, a good friend of mine wrote a plug-in for Auto Complete and a lot more for Visual Studio 2003 and 2005 - called SqlAssist. He is busy working...

THANK YOU MICROSOFT!

I can't wait to dig into the other views and functions to see what they can provide, but just seeing the queryplan that is in action is a...

I don't know if you're talking about PromptSQL or SQL Assist, but I noticed that I didn't post the site to SQL Assist. And for some reason, when I...

It is available in SQL Assist.

P Barbin

I've looked at a number of SQL Intellisense programs and chose "SQL Assist" based on two features - templates and sql formatting. Their Templates are extremely powerful and configurable....