Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 character increment

Author  Topic 

darshika
Starting Member

1 Post

Posted - 2014-07-17 : 02:32:54
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
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-07-17 : 08:14:15
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

38200 Posts

Posted - 2014-07-17 : 12:44:17
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
   

- Advertisement -