AndrewSQLDBA (10/11/2010)

It looks like the only difference between the first three sections is in the where clause - specifically in the # of days being selected. Is this correct?

The dateadd(hh,0,) part...

george sibbald (10/11/2010)

WayneS (10/10/2010)

Any suggestions on good, inexpensive, close places...

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...

Jeff Moden (10/10/2010)

WayneS (10/10/2010)

Any suggestions on good, inexpensive, close places...

Well, SSIS does use the Jet driver, via OpenRowSet, to work with Excel files. So, this link will probably help you out. You would just need to add it to...

Here is the latest version of the Delimited Split Function.

You would use it like:

declare @test varchar(20);

set @test = '2,7,12';

SELECT ID = convert(int, Item)

FROM dbo.DelimitedSplit8K(@test, ',') ds;

Jeff Moden (10/10/2010)

Heh... the lion sleeps. That wasn't...

Hey gang... not definite yet, but my wife is talking about letting me spend the $ to go to PASS. 😀

Any suggestions on good, inexpensive, close places to stay? Guys...

Well, you quoted my article. And that is how I fixed exactly those same issues... except I had thousands instead of hundreds.

There's only two ways to fix the problem. Follow...

Thanks for your responses guys. It's right in line with what I was thinking, but it's always good to get the double-check.

Now, I just gotta get used to using the...

Jeff Moden (10/10/2010)

WayneS (10/10/2010)

DECLARE @String1 varchar(8000),

@String2 varchar(8000);

SET @String1 = 'a,b,c,d';

SET @String2 = 'apple,boy,college,dog';

SELECT a.Item,...

Mordred (10/9/2010)

I am a student who is relatively new to SQL. While I am not looking for someone to do my work for me,...

Ninja's_RGR'us (10/10/2010)

GilaMonster (10/7/2010)

If you do the maths, it works out that...

Using the DelimitedSplit8K function, you would end up with:

DECLARE @String1 varchar(8000),

@String2 varchar(8000);

SET @String1 = 'a,b,c,d';

SET @String2 = 'apple,boy,college,dog';

SELECT a.Item, b.Item

FROM...