If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to Replicate this in Report Studio???

Started by rr.bi1212, 29 Jan 2012 07:45:46 PM

Previous topic - Next topic

rr.bi1212

ROW_NUMBER() over (partition by field name
ORDER BY CONVERT( CHAR(10), field name,
121 ) + CAST( fieldname AS CHAR( 2 ) )) rowid

I need to replicate it in a Query