Hi...!

To a similar table I need to add a row number...

Please don't tell me that use Temp Tables, if it's possible only T-SQL... I use DB2 over ISeries...

With ROW_NUMBER() OVER() is like a sequence but doesn't work for each group...

Thanks in advance and regards...!

Hi hail...!

Here the solution (DB2):

SELECT C.CTA, ROW#
FROM TABLENAME C,
TABLE <b>(SELECT COUNT(*) AS ROW#
FROM TABLENAME C2
WHERE C2.CTA = C.CTA AND C2.CTA1 <= C.CTA1)</b> AS TABLENAME_ORDER
ORDER BY C.CTA, ROW#; In this T-SQL CTA1 is another field different that CTA.

Follow next link for 2 ways in SQLServer:
tek-tips forums

Best regards...!