csallen_01 (11/26/2013)

---

Sorry about that. Here ya go;

GoalStatus; 1= Success, 0=UnSuccessfully

Create Table #Goals (

PersonId INT

, GoalDate Datetime

, GoalStatus INT

)

INSERT INTO #Goals (PersonId, GoalDate, GoalStatus) VALUES ('125600','1/10/2013','1')

INSERT INTO #Goals (PersonId,...

autoexcrement (11/25/2013)

---

Perhaps "wizardry" would have been more appropriate, but I had a little alliteration thing going there with the "t's", so... 🙂 I'm certainly in awe of you cats and...

"Cartesian tally table trickery" makes it sounds like a bad thing. ...

What happens when you get to 4 letter combinations?

Could get nasty! 😛

And then there's this:

SELECT DISTINCT * ,ROW_NUMBER() OVER ( ORDER BY InventorySys )

The DISTINCT has no meaning here (just drags down the performance) because the ROW_NUMBER()...

Sounds to me like you need something similar to this:

WITH SampleData (ID, FID, HC, VC, SN, updateddate) AS

(

SELECT 104,1,100562,5000151,2974814,'2012-03-13'

UNION ALL SELECT...

Before you use...

L' Eomot Inversé (11/23/2013)

---

The idea of building tuples and then using a splitter to pull them apart looks promising. I am going to have a look and see if...

Are you sure about those expected results?

A couple of minor modifications to what I...

Order status appears on each order detail line, hence when a status...

Expand your...

Your test data is flawed because it is missing some commas in the INSERT/SELECT and you get truncation errors putting it into the data types you supplied in the CREATE...

You may think that you want to do this now, but IMHO you'd be better off coding the column names and selecting all of them at once. Otherwise the...

If Order status is an attribute of an Order, why does it appear on each order detail line?

dwain.c (11/20/2013)

---

I hope that the OP realizes that it is no longer necessary to pass multiple values within a comma-delimited list to a SP.

Use a Table-valued Parameter instead.

The only question...