I found this a really useful article since I hadn't played much with CTEs or ROW_NUMBER() before. Both of those concepts have suddenly 'clicked' and I really see the...

Just make sure you install SQL 2000 first, and SQL 2005 last.

After doing the enable ident insert - ship data - disable ident insert bit, check that you can still insert records.  I was using a third party tool the other...

I'd be tempted to try re-installing the .Net 2 framework.  Something in the .Net 1.1 install may have caused an issue - generally installs are backwards compatible, not forwards.

Something else which occurred to me... if you know all the tables and fields in advance so you do not have to build the query dynamically, putting it into a stored...

You'd probably need to look at the execution plans of the two different types of query to be sure.  I believe using 'OR' can prevent SQL Server using indexes in...

Excellent tip Jeremy, thanks for that.  Unfortunately the CSS fix on Jon's site only fixed the height problem for me, but the other stuff suggested on there kindof gets around the...

Thanks Aaron, I've already got that and it does work very nicely.  Unfortunately I can't mandate it for my customers

You can also use something similar to host variables instead of string concatenation, but the way to do it depends on the language you're using (VB 6 or VB.Net).  This...

Excellent, thanks for that link!

Ah!  I won't hold my breath then, if that's any guide!

And remember to remove the Print statement once it's all working

Suck it and see.

When the stored procedure is called with different parameters from the previous call, it has to re-generate it's execution plan for the different statements it's going to have to call...

If you really need dynamic SQL you can use sp_executesql to run it, but I agree with Vladan - you've got some VERY strange requirements there!