And w/o the CTE:

DECLARE @Table1 TABLE (col1 char(2), col2 int)

INSERT INTO @Table1

SELECT 'aa', 12 UNION ALL

SELECT 'bb', 22 UNION ALL

SELECT 'cc', 33

DECLARE @Table2 TABLE (col1 char(2), col2 int)

INSERT INTO @Table2

SELECT...

OK, how 'bout this one:

;WITH DirectReports (UniqueID, CurrentProcessStepID, NextProcessStepID, [Name])

AS

(

SELECTROW_NUMBER() OVER(ORDER BY tp.TransactionID) as UniqueID,

tp.CurrentProcessStepID,

tp.NextProcessStepID,

Name

FROM itTransactionProcess AS tp

LEFT OUTER JOIN dbo.itProcessSteps ON tp.CurrentProcessStepID = dbo.itProcessSteps.ProcessStepID

WHERE LotNumber =...

So from what it sounds like, the UniqueID and Level values are arbitrary numbers that need to be incremental and as long as they appear in the right order, all...

What about that Processing Step ID 8 question?

I guess what I'm getting at is, based off of the result sets in your spreadsheets, why is Step 8 our of numeric...

And what about Level?

So in your correct results, why would you want to see CurrentProcessingStepID 8 our of numeric order?

What is the purpose of the UniqueID value?

edit....

And the Level values?

Mat (8/27/2009)

---

I guess the question now is can I take a single step (or a single pathway) to upload this data into a SQL Server Destination. Or do I need...

You can't import both rows if they have the same Primary Key. Even if the rows were imported in different transactions, it will fail because of the Primary Key...

I appologize in advance for posting an incomplete post, but I have to get out of the office for the day and I didn't want to leave you hanging.

Your problem...

DECLARE @Table TABLE (Data1 char(1), Data2 int, Data3 int)

INSERT INTO @Table

SELECT 'A', 100, 20 UNION ALL

SELECT 'A', 102, 30 UNION ALL

SELECT 'A', 103, 40 UNION ALL

SELECT 'B', 104, 10...

Agreed. And while you're on site, ask to visit the users too.

What SQL have you tried that has you stuck?

David is correct. Good Teradata administrators are very hard to find. On top of that, you need to consider what kind of environment you want to create. ...

The XML source adapter, as you've seen, breaks the XML up into it's relational components. So you'll need a destination for each output.

You may be able to...

Well, are you going to post your table DDL and sample data?