Grant Fritchey (1/17/2011)

---

While in the meeting, the consultant turned to me and said, "Hey Grant, didn't you just give a presentation on this to 600 people?" Our dev team sat...

How's this?

-- See how you start off by actually creating a table and then

-- inserting the data into it? Your doing this makes it a lot easier

-- for all...

How's this?

DECLARE @Holiday TABLE (HolidayId int identity(1,1) primary key, HolidayDate DateTime)

INSERT INTO @Holiday(HolidayDate) VALUES('7/4/2011')

INSERT INTO @Holiday(HolidayDate) VALUES('12/24/2011')

INSERT INTO @Holiday(HolidayDate) VALUES('12/25/2011')

INSERT INTO @Holiday(HolidayDate) VALUES('12/31/2011')

INSERT INTO @Holiday(HolidayDate) VALUES('8/11/2011') --* Yea,...

However, the core (shared) components would be at the highest SP level.

Paul,

Hmm, I don't recall seeing that before. It definitely is good stuff.

I'll have to run some tests to see if there is a length restriction - could turn out to...

Change:

(select row_number() over (order by name) as id, name + ',' + salesnumbers from thetable;

to

(select row_number() over (order by name) as id,

...

Thanks Lutz!

@dandenson - in the first post, you had your expected results encased in single quotes; in your subsequent post you took them out. That whole replace...

dandenson (1/13/2011)

---

Thanks Wayne, your code works wonderfully. I do have a few questions though.

First, I'm trying to learn/understand this. I get that ItemNumber comes from the DelimitedSplit8K function...

Did you build it properly? You might want to check out the article The "Numbers" or "Tally" Table: What it is and how it replaces a loop. [/url]

At this point, I'm not sure. How about posting everything in the SSIS_Errors table for the last run only? There might be other messages in there that will give us...

How's this?

declare @test-2 varchar(100);

set @test-2 = '''jack'',''25,A67,91J''';

WITH CTE AS

(

SELECT *

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

)

SELECT UserName = CTE1.Item, SaleNumber = Replace(CHAR(39) + CTE2.Item + CHAR(39), CHAR(39)+CHAR(39), CHAR(39))

FROM CTE CTE1

...

Are you specifying the instance name in the servername fields?

If you're using an alias - is it set up with the instance name?

That error sounds like something we saw dealing...

If you're doing differential backups, be careful. VSS will invalidate the last full backup, and the differentials will fail. (Found out the hard way when differentials starting failing... investigation found...

I just wonder how many of you kids know what tiddlywink sets are! :w00t:

You're in the LA area? I thought you were in Germany!