you have to use either ";" or "GO"

but not both of them.

both are batch separator

Hi David

I would like to add something in Your "simple example"...

IF EXISTS(SELECT 1 FROM ... WHERE...)

Instead of this Use following...

IF EXISTS(SELECT TOP(1) 1 FROM...

1>.

Make a computed column (with persisted) named "ShipTranNo"on

the third table "ILSS"

Alter Table ILSS

Add

ShipTranNo as LEFT(SHIPMENT_ID,) PERSISTED

2>.

Now create an index on this column "ShipTranNo"

Create Index Idx_ILSS_ShiptranNo ON ILSS(ShipTranNo)

3>....

Hi Buddy

use the built in undocumented procedure

sp_MSforeachdb 'use ?; select ''?'' --rest of your query goes here ',

and this will show you the result from each db

--the ? is...