Careful!!!! You must still include the delimiter wrapping or you will get...

Adam Haines (2/20/2008)

---

The first thing we are doing is adding tags to all the values in the delimited string. E.g.

declare @filter varchar(25)

set @filter = 'test|test2'

DECLARE @x XML

SET @x =...

Ok... I'm a bit new to 2k5... just installed it a couple of months ago and still coming up to speed on how some of the new features work.

Can someone...

You pictures didn't show up because you didn't attach them.

If you have a "friendly" DBA, (s)he will be able to setup a proxy user on a job that anyone could run at any time.

Good lesson here, though... most DBA's...

If it's not too far from work, go into work once in a while. Otherwise, you're fine. Just continue to make sure that they know you exist. ...

Yes you can... like this...

DECLARE @S1 VARCHAR(100)

DECLARE @S2 VARCHAR(100)

SET @S1 = '5'

SET @S2 = '1,2,3,4,55,6'

SELECT PATINDEX('%'+@S1+'%',@S2)

But, you notice that in...

What was the error... partial file transmission or just a bad row or maybe a rowcount at the end of the file? What was the error?

Awesome. And very simple, to boot! Thanks Chris! Neat redirection trick.

Very cool, Chris... how the heck did you do it?

... just a reminder... no privacy info, please. Also, if it's a big file, please zip it. Thanks.

You didn't answer the question that came up right...

Hmmm... I see what you want to do... this is just a small example... if you really want commas in your final output, see where I marked the code "Modify...

Christopher Ford (2/19/2008)

---

BTW, on a production test.

I had to run Jeff's running total update because I had 80 million rows to group by 1,928,672 different accounts over a 7 year...

Actually, Kevin, what you said is spot on... but they haven't figured out the rest of what you said, yet... when they do, Michigan will be a hot spot for...