Ah yes, there are different types of cursors - it's looking like the default type is forward only, which means that the FIRST qualifier cannot be used.

Try this

FETCH NEXT FROM...

OK.  Try using FETCH FIRST as your initial FETCH statement - and you need the local variable there too:

FETCH FIRST FROM Localisation into @strSQL

When you use the FETCH command, you need to put the results of the FETCH into a local variable and then build your SQL string from that:

FETCH NEXT FROM Localisation...

Please post the error message.

Where in this code does @sql get set?

Or the simple version:

declare @strSQL nvarchar(4000)

DECLARE @EmpName varchar(100)

Set @EmpName = '"Frank Smith", "John Doe"'

set @strSQL = 'SELECT * FROM Employees WHERE EmpName IN (' + @EmpName + ')'

exec sp_executesql @strSQL

Note:...

Remi - is this your favourite function?  It seems to keep popping up.  Must read it one day and work out what's going on

There are third-party tools that will do this for you.  Here's a link to just one of them:

http://www.apexsql.com/sql_tools_diff.asp

And no, I do not work for this company!

Phil

No enough info.  Please post the code for your trigger.  There are some clever people on this site and the cursor may not be necessary after all.

To disable a trigger,...

OK - getting there.  I think you want something like this:

SELECT t1.dest_bol_no,   

       t1.rev_no,   

       t1.comm_code,

       t1.quantity,  

       t1.bol_no,

       t1.trailer_id,        

       t1.pup_trailer_id, t2.order_no

FROM BL_TRUCK_BOL_DEST_COMM t1 join BL_TRUCK_BOL_DEST_COMM_ORDER t2 on t1.dest_bol_no = t2.dest_bol_no and

t1.rev_no =...

Yes, this doesn't really sound to me like a UNION query after all.

Can you provide some sample data - just the relevant fields - and show also your desired output? ...

OK - but there must be some circumstances under which you want the rows from TABLE_b, otherwise why bother with the UNION in the first place?

I can't see any catastrophes on the horizon, but you should of course write the appropriate script and run it on a backup copy of the db just to make...