I am sorry I re-Read my original post and i was unclear.

I want individual LineitemNumbers per each InvoiceId.

so I cna have Invoice#97865 with LineItemNumbers 1,2,3.

right now I am...

That is what I will do then. I need to study up on Merge and how this will work best for me. This was my first time trying this transformation...

Thanks I will try this today and get back to you. I will then mark this as solution.

This did work SO I marked it.

I do something similar but I insert the row counts into a Table first then I run this code in an Execute SQL Task. FYI I am using SSIS 2012...

Yes I did understand once I saw it work Thanks again I marked this as Solved.

As far as performance this will be part of an SSIS ETL job once a...

Thanks again. this is what I changed it too and it seems to work.

with NumberedResults as

(

select ROW_NUMBER() over (Partition By actindx order by Calendar_Month) as RowNum

, *

from TrialBalance...

I know this is a rookie question, but how do I find out which column makes my Row number? I assume there is an internal SP or something that can...

Fixed my CODE and attaching Excel sheet to show desired output. see column N, O, P for results.

Thanks I will mark this as solution completed.

As I said this worked. My next question is how do Insert this New_TB into Trial_Balance_Debit?

Again Following my logic in the Excel sheet this would insert into K3 and then...

I'm sorry Your right I ran it on my full real DB and it didn't look right, but when I used fake data it works. THANKS!

No Not quite. the best way to explain is as if it is an Excel sheet say ActivityDebit is Column H and it's Value in H3 is 742031.30 (which is...

Version of SQL is SQL Server2008r2.

for Second Question I need both a running total and individual totals. 1st one is for posting type of Balance Sheet next one is for...

Thanks for this, but i was unable to make it work with my query and DB. I finally asked my boss and he gave me this which worked. I am...

Thanks. There was something wrong with the SQL task so I deleted it and created another and it works.

When I say it works i mean I am able to execute...