You're definitely right...

Should have limited "fastest" to the solutions provided in the post.

I'll go and edit it... 😉

Or you could set up Database Mail and send the data directly as a xls file using a stored proc called by a job.

I actually doubt you've tried the solution Wayne proposed....

He suggested to add a string to a string.

What you describe is to add two numbers.

But when you try to use Waynes...

I would try the two methods below and check which one runs faster.

If the length of your data will always be the same then you might not need to use...

'criteria' is actually the WHERE condition you'd like to use.

It would help a lot more if you could set up some ready to use sample data so we can show...

something along those lines?

select *

from calendar c

left outer join YourTable y on c.date = y.date

where y.column=criteria or y.column is null

You should think about using a calendar table as a left join together with your query.

The calendar table can also be helpful when dealing with business days, holidays and so...

I'd expect you'll see an error message of the following type:

But, as stated several...

Would you be allowed to copy the data into an additionally created table having correct table structure?

Please provide table definition and sample data as described in the first link in my signature.

Reason: there are some people around here (like me) that prefer to provide tested code.

By...

If there are addtl. fields required I would use a form where clients could request it and let the DBA deal with it.

The solution you have in mind could lead...

The biggest problem is to have date values stored as integer.

You have to convert it via character into datetime format (e.g. the way you did). And that's slowing down performance.

The...

It looks like you're using dynamic query.

The second part seems to work (I'm getting WKRed:2010/01/10-2010/01/16, WKRedOrd: 2010/01/16).

It looks like there are some data missing when you apply your dynamic table...

I would use an index on ID, idx on table [test] for it...

Running over a minute for 100k rows seems strange...

What test scenario do you use?

CirquedeSQLeil (1/11/2010)

I have tested both scripts and compared results.

I would go with the script provided by Wayne. When the result sets are small, then both are similar. When...