Once it's linked, you can just add the server name on the front.

UPDATE [serverName].dbname.author.table

SET ....etc.

Not sure how you do that if you have to look up the names...

Peso (11/13/2008)

---

Chirag, even if there is a clustered index on the table, it doen't mean that records are stored physically in same order.

I know Itzik Ben-Gan has demonstrated this lately.

The...

gregarobinson (11/12/2008)

---

"since it appears the databases exist on the same server, you could do this:"

They do not, they exist on 3 different servers.

Each row in the temp table...

Look up datetime in BOL for an explanation of why, it's actually returning a value that is compared to 1/1/1900 00:00:00.

You should either pick a different default date...

Jeff Moden (11/10/2008)

---

Heh... if you really want to throw a ball of wax at them before you decide to find a place with reasonable requirements, tell them the column should...

do you really need to name the variables differently depending on the parameters? can't you just call it @param1, @param2, @param3, and let the data figure out what's in what?

We should post that as a...

I think you're trying to create too many levels between what you're attempting and dynamic generation of queries and variables.

You also have double quotes around ''@dr_'' just before adding...

toward the end of your code you have this:

'set @DRname = ''@dr_'' + @target_variable2' + char(10) +

'PRINT @DRname '

which is setting @DRname to the string...

technically you would only need len(ltrim(someString)), len ignores trailing whitespace.

rbarryyoung (11/4/2008)

---

I am not in aposition to test it, but this should be cloes:

Select V.[Vendor ID], CY.TotalBags as [Bags Last Year], LY.TotalBags as [Bags This Year]

From Vendors V

Left Join...

http://www.sqlservercentral.com/articles/Editorial/61757/

thanks, I couldn't find it either.

Any chance you feel like translating for 2000? I have the same issue, although I'm playing with diagnoses instead of specialty, but I can convert that part.

Like the OP, I...

dang, there goes my whole philosophy of programming . . .