October 18, 2011 at 12:55 am
Hi,
Can any one help me to solve this query...?
ROW_NUMBER() over (partition by discom_dispatch_fk order by discom_Comment_Dt) + 50....
when i use this in oledb source through SQL Command mode , it says OVER is not supported...How can i resolve this? Please help me..
Thanks,
Charmer
October 24, 2011 at 5:16 am
Try using a script-component to add the row-num field. If your data is unsorted, you'll need to use a sort transform first.
Data Enthusiast | @SQLbyoBI | www.opifexsolutions.com
October 24, 2011 at 5:28 am
i'm just incrementing a column value one by one through script component ...like 1,2,3,...10000...for example if the last value is 100000..i need to get that last column value and insert into another table....how can i do that..?..
Thanks,
Charmer
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply