Jeff Moden (10/10/2008)

---

ggraber (10/10/2008)

---

Nope, I'm not 100% sure I know what you mean by a "Tally CTE." Sounds like you're gonna create a tally table on the fly. Which...

This would get the CSV

DECLARE @Cities TABLE

(

State VARCHAR(20)

,City VARCHAR(20)

)

INSERT INTO @Cities

SELECT 'Connecticut','Hartford'

UNION ALL SELECT 'Connecticut','Stamford'

UNION ALL SELECT 'Connecticut','New...

Jeff Moden (10/8/2008)

---

ggraber (10/8/2008)

---

An article on this topic would be really cool, Jeff.

I just presented this concept at work using your split csv example.

I was just trying to think what...

Sorry, I didn't notice that. :blush:

Have you tried the UNPIVOT solution?

I guess the question is that a while loop has a dynamic number of iterations based on the length of the parameter.

You don't have that kind of flexibility with a...

An article on this topic would be really cool, Jeff.

I just presented this concept at work using your split csv example.

I was just trying to think what other examples I...

Here's how to do it with UNPIVOT.

Please note that I only used part of the table definition for this example.

CREATE TABLE #mgr_calc

(

sID ...

Does this work for you?

SELECT TM.SrcId AS Source

,TD.SrcId AS Destination

,TD.Category

...

Here's how to get the destination CabinetID. But I'm not sure about the source.

Why doesn't TransferMaster have a Category?

Can you please post a sample result set?

SELECT TM.SrcId AS Source

,TD.SrcId AS...

If there really is no relationship between the tables then does that mean that the data in each field of each row of the final table is not related to...

clint_pow (10/3/2008)

---

Hi SSC,

If I will do the MAX(Price), the data will get the MAX(Value) of the field, example

1 4

1 5

2 ...

I was thinking something like this.

But it is not tested because you have not provided any sample data. 🙂

Also, keep in mind that you can later join on the...

clint_pow (10/2/2008)

---

Hi SSC,

Sorry I mean row if you take you example it will take like this :

DocNum Price

1 ...

You really do not have to (and should not) go with that assumption....