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.
| 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 query2. INSERT INTO statement(s) to populate the test tables in step 13. Your query so far against the tables created in step 1 an step 24. The required results from the finished query. |
 |
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
character increment