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() ...

Statement level is the lowest level of granularity to fail or succeed upon. If you have in your example 100 records in table A to update based upon some logic (e.g. from another table, from a custom ...

BANGALORE, INDIA: In SQL Server 2008, you can perform insert, update, or delete operations in a single statement using the MERGE statement. MERGE statement allows you to join a data source with a ...