Increment in sql server.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » T-SQL » Increment in sql server.

Increment in sql server.

Rate Topic

Display Mode

Topic Options

Author

Message

venki.msg

Posted Monday, September 03, 2012 11:19 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, January 31, 2013 12:02 PM
Points: 5, Visits: 16

Hi all i need to do increment a number like aa001 to aa999 then again ab001 to ab999

aa001a0 to aa999a0 then aa001b0 to aa999b0.

Can any one help me out to find logic for this.

Post #1353708

Sean Lange

Posted Tuesday, September 04, 2012 8:29 AM

SSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 8:46 AM
Points: 8,547, Visits: 8,204

Duplicate post. direct all replies here. http://www.sqlservercentral.com/Forums/Topic1353709-8-1.aspx

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Post #1353934

« Prev Topic | Next Topic »

Permissions