I have a select like this:
SELECT a.part_id, a.descript, b.location from PART_MASTER a, anotherdatabase.INVENTORY b
where a.part_id = b.part_id
Is it possible to use a @variable to identify the other database, rather than hard coding it? (I've tried @db2.INVENTORY b) but SQL SERVER 2000 doesn't like that.
October 9, 2008 4:22 PM
October 10, 2008 6:00 AM