Hopefully this will help
I am select, updating and sometimes inserting into tables, where I use alias as
well as fully qualified database names.
Such as these examples I have attached.
I am also performing all manner of updates across linked servers.
(I have sent the attached files in a separate email)))
Here is a small example
set f1.DoNotCall = 1
, f1.DoNotCallEffectiveDate =
cast ( substring (f2.EffectiveDate, 5 , 2 ) + ‘/’ +
substring (f2.EffectiveDate, 7 , 2 ) + ‘/’ +
substring (f2.EffectiveDate, 1 , 4 ) as datetime)
RE_Admin.dbo.Prospectlist f1 (UPDLOCK)
, RE_Admin.dbo.RE_DoNotCall_2 f2 (NOLOCK)
f1.DoNotCall != 1
Senior Systems, Database/Data Warehouse Architect
678-414-0090 my cell Primary