I though multiple backup systems would break the backup chain?

Thanks capn. I am going to look at Mr Celko's approach with the Months table since it may greatly simplify matters.

I'm fascinated.....I am working with Lynn's code.

Say I wanted certain clients those whose ClientID was < than 3.

Clearly I can add any conditions to the final SELECT statement but performance...

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.