We also use a...

You may want to search this site a bit. You...

We haven't moved to a production environment yet, but what I am curious about is your comment about modifying meta-data in your packages. What meta-data did you have to...

GilaMonster (7/6/2009)

---

It's violating BCNF if I'm not mistaken. There's no inter-data dependency (so passed 3NF) but there is...

WayneS (7/5/2009)

---

Lowell (7/5/2009)

---

I slapped together a stored proc sp_GetDDL that returns the table DDL, complete with indexes ,defaults, everything...there's a function version as well; that would probably work just fine...

A little humor helps a bit...

With that, though, Jeff really wasn't kidding when he asked you to...

Hey, I could have said something at the beginning but...

Now, one last little ribbing. You spelled BRAIN incorrectly in you post header. 😛

Digs (7/5/2009)

---

Thanks the out put was

1A10

2B20

3C30

Where did the column 'ItemID' come from, have you made changes to the 'DelimitedSplit' function, by allowing and 'Identitiy field ' (increment at 1) ....

You have much to learn padawan.

Here:

declare @Str1 varchar(8000),

@Str2 varchar(8000),

@Str3 varchar(8000);

set @Str1 = '1,2,3';

set @Str2...

You are looking at the code in the wrong way. How did I provide you with everything you needed to test the code I provided?? Now, go back...

And if you'd like a hint, it is all done using the dbo.DelimitedSplit function I provided. 😉

Oh, by the way, I already have a solution ready once you post the setup code.

Do you really want our help? If so, please review the code I provided in the SQLTeaserCode.txt file. Once you provide us with what we need in that...

WayneS (7/5/2009)

---

No... we're not here to do your work for you. We will, however, guide you to find the solution.

As...