I have data in a temp table and need to use dynamic sql to delete/insert data into the main table...

I may be doing something wrong with the dynamic sql if...

thanks but I have a insert from a select statement.... what can I do in this case?

ta

also you should be pitching this question in the T-SQL forum area

a left outer join would select all records from tblResv.... but there really is not enough info from the table description provided to give you the SQL.... I am lazy...

thought I had to return the parameter through the return... doh change return @data to return 0

thanks but all solved now... dynamic sql is needed because new databases are created as part of an admin function in the application...

include it with the rest of the dynamic SQL

thanks, spot on!

i presume your pre-check would be contained within a SPROC that is updating TBL_X

CompName\Server Instance Name

thanks working, there were no instructions what to do once installed but because of the above post I type in \ under name and clicked on refresh services, and the...

yes

O/S = Windows 2000 Professional Service Pack4

I am pulling my hair out on this one.

I was very careful with the installation making sure none of the services were running which...