Yes exactly like that. Thanks (again) ColdCoffee.

My comment about leap years was clearly non-sensical given my requirements.

Also I might try experimenting with putting your join criteria in a proper join statement between the two tables.

See how long a SELECT takes when joining: Air code to follow.

SELECT...

I faced a similar issue recently when trying to insert records into a linked server. I ended up creating a stored procedure on the linked server to do the insert....

Thanks for your response.

I have a domain account setup as the execution account (not the service account).

If I create the subscription I can enter this execution account and password. If...

Is using BETWEEN to be avoided? I don't expect my criteria to ever have a time component.

If I use the the DATE datatype in my historical table and then convert...

If you are using identity fields as keys in your new schema you may want to explore the

SET IDENTITY_INSERT statement so you can insert explicit values.

http://msdn.microsoft.com/en-us/library/ms188059.aspx

Thanks to you both. Lynn's code looks like a solution to the problem I posted. I am going to use the data structure suggested by Celko, using start and end...

Interesting. Thanks for the link.

You need to configure your DesinationConnectionFlatFile to use the variable.

View the properties of the destination file connection manager. (F4 key, don't double-click)

Set the 'connection string' property using the expressions property....

>>Then you can use Bitmap.SetResolution to set your images to at least 300 DPI.

Does anyone know how this is done? Is this a server side setting or is it report...

Thank you, appreciate the help.

My expected results are:

1

2

A

B

NULL

I want to return any data that is not a question mark.

Thanks Paul I will definitely explore that option. I have a monitoring system for failed jobs so it sounds like I would at least be notied that something is amiss....

Will a job with the following fail if corruption exists? Or will the job succeed?

DBCC CHECKDB(N'master') WITH NO_INFOMSGS

I'm suddenly feeling a bit exposed since I am not sure if...

Yes, something always does go wrong.

This particular business process is an intermediate step. If the primary business group doesn't generate the record the next business group in line can't...