Facebook Twitter Gplus LinkedIn YouTube Google Maps RSS
Home Technical Adding Row Number to SQL Output
formats

Adding Row Number to SQL Output

Published on October 15, 2010 by in Technical

Select
CONVERT(nvarchar(4), ROW_NUMBER() OVER (ORDER BY [Auditing].[AuditQuestion].[Text])) + ‘. ‘ + [Auditing].[AuditQuestion].[Text] AS AuditQuestionText
…..

 
Tags:
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 

Leave a Reply

Your email address will not be published. Required fields are marked *

*

* Copy this password:

* Type or paste password here:

12,870 Spam Comments Blocked so far by Spam Free Wordpress

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

© All rights reserved to Cyberbrutus. 2012
credit

Switch to our mobile site