Text only
|
Text with Images
COGNOiSe.com - The IBM Cognos Community
IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: rr.bi1212 on 29 Jan 2012 07:45:46 PM
Title:
How to Replicate this in Report Studio???
Post by:
rr.bi1212
on
29 Jan 2012 07:45:46 PM
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
Text only
|
Text with Images