SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Development Tools
 ASP.NET
 character increment
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

darshika
Starting Member

India
1 Posts

Posted - 07/17/2014 :  02:32:54  Show Profile  Reply with Quote
hi,
i have a column which are having values r00,r11 like that and another column having a range a00-a09 so i want third column in which i can show that in front of roo or r11,third column shows the range like a00-a01 of r00 or r11

gbritton
Flowing Fount of Yak Knowledge

1130 Posts

Posted - 07/17/2014 :  08:14:15  Show Profile  Reply with Quote
please post in consumable format:

1. CREATE TABLE statement(s) to create test tables for your query
2. INSERT INTO statement(s) to populate the test tables in step 1
3. Your query so far against the tables created in step 1 an step 2
4. The required results from the finished query.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37143 Posts

Posted - 07/17/2014 :  12:44:17  Show Profile  Visit tkizer's Homepage  Reply with Quote
Here's an article that goes into detail regarding gbritton's reply: http://www.sqlservercentral.com/articles/Best+Practices/61537/

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000