I have a stored procedure that needs to select some data into a table variable, but I am having trouble because I need a dynamic where clause and SQL Server 2000 does not seem to like using an EXEC() ...
OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...