A few questions...

1. what's your date format? is that MM-DD-YYYY or DD-MM-YYYY?

2. please explain in English how to get your expected answer. (what does your data mean?)

Another thing... if you...

post what you tried. Part of learning SQL is trying something, and failing, learning from your mistake, and trying again.

What happens when you run the stored procedure inside SMS, not SSRS? Is there a chance that you're connecting to a different server that has a different copy of...

Brandie,

Just wondering... how did you build your machine that you tore apart all the time? A Virtual Machine? I might have to start doing that...

The 2004 ALCS must have been one for the record books in your house... You gotta admit, it was a pretty good series - the WS after that was positively...

Maybe try RedGate SQL Compare

DelimitedSplit8K will do that for you... the code for it is here[/url]:

SELECT *

FROM dbo.DelimitedSplit8K('777777777777777777 0 0 0 0 0 0 0 16090 0 0 0 0 0 0',' ');

The...

Interesting... Good to know! So check your indexes, then try each one...

Thanks, Scott!

The code attempts to subtract weekends, holidays...

I would do that part with a Calendar table... then you need pretty much ZERO logic for it.

WHERE Calendar.IsWeekend = False AND Calendar.IsHoliday=False...

You could... but I'd read this first:

http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/

I would have sworn that EXISTS stops as soon as a True/False changes, while an IN reads the whole table. So I would think...

If you're dealing with a star schema, you'd filter the Calendar/Date table and then the join would filter the Fact table.

SELECT ...

FROM FactTable f

INNER JOIN DimDate d

...

What if you shred the XML to a table, and index it? Then the join can use the index for the subsequent query.

The first thing that jumps out at me is the

INNER JOIN table3 c ON CHARINDEX(c.Column,a.Column)>0

Joining on a calculated value is just terrible for performance, because you can't index the...

Instead of showing us the code, please post some sample data showing the original structure of your table and then the desired one.

Most helpful would be if you would post...

That VALUES trick is really handy! Absolutely going to steal that!