Thank you for the replies - I'll check out the suggestions. For your information, let me only clarify that the task in question (for me this time) is to 'send'...

Hello again, I see you have a challenging task. Just a quick re-reply on UNION in general. You may in principle UNION 'whatever you like' as long as you know...

Hello, I take it that the selects represent similar information extracted by the various select statements. If so, you might bypass your 'problem' by merging the selects using UNION.

Regards,

Hi, just a quick comment, since it seems that the purpose is dealing with historical data or analysis at least. You may want to approach the task from 'data warehouse'...

Hi, you have received good advice already, but just let me give you a little info about our solution so far:

1. A central SQL Server is on the network, accessible...

Hello Steve,

here is a quick take at your interesting problem using the 'dayofyear'. I have put all variables explicit, but have not had much chance to check thoroughly. The example...

hello,

you might even try this 'easy' way in the where-statement:

where

(@firstname is null or au_fname like @firstname+'%')

and

(@lastname is null or au_lname like @lastname+'%')

Hi, an easy way out will usually be to remove the double quotes before running bulk insert. That is, if the file is not tooo big, use an editor and...