How about creating a synonym in one of the databases for the objects in the other database? That should allow what you need.

I discovered the feature (the go-to-page thing) by accident. Was a couple of months ago, I think.

For something like that, I probably would use a cursor to step through the codes.

To avoid blowing up the tran log, I'd probably add a log backup step after every...

Next thing to try is changing this:

WHERE @pFromDt = CAST(FLOOR(CAST( HRS.ACT_END_DT AS float)) AS datetime)

to:

WHERE HRS.ACT_START_DT >= @pFromDt

AND HRS.ACT_END_DT <= @pToDt + 1

It might also help if you have an...

The first thing to do is try this:

SELECT

CONVERT(nvarchar(30), EIN) AS EIN,

ORG_NM,

CAST('' AS VARCHAR(50)) AS ORG_ADDR,

...

Might not be a bad idea. I haven't tested something like that, but it would seem that it would allow for easier scale-out.

First, the execution plan would be key to helping you solve this. Please save it, zip it, and upload the zipped file.

Second, which one of the three objects in...

So if I understand you correctly, I have two tables:

Table 1 - the holding table for the full file.

Table 2 - the final table that the production data is in.

1)...

You could probably accomplish that with SSIS pretty easily. Output the data and calculations to a file, and then copy the file to the printer port.

Florian Reischl (5/1/2009)

I would say it was a little...

Take a look at Red Gate's MultiScript tool. Might be what you're looking for.

The easiest way to do this would be get a product that does it for you. Red Gate's SQL Doc will probably do what you want, and then a...

Then you just need to change the letters in that part of the select to whatever state abbreviation is appropriate.

Sorry, assuming a bit here, aren't I?

What I'm suggesting is import the CSV into a holding table, then using that to batch-update the real table.

You'd start out by downloading the...

You're welcome.