|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
July 3rd, 2008, 06:15 AM
|
|||
|
|||
|
Sql Split
Is it possible to do a split in a sql simular to an asp split, e.g.
i have two values in a collum in a database CollumnA id1:test1 id2:test2 id1:test2 and then in another table i have 2 collumns Collum1 id1 id2 id1 Collumn2 test1 test2 test2 i need to be able to do a select statement where collumn 1 and collumn 2 are equeal to CollumnA.
|
|
#2
July 3rd, 2008, 06:19 AM
|
||||
|
||||
|
-->Thread moved to SQL Development Forum
you can do a join on those ... something like this Code:
SELECT t1.column, t2.column1, t2.column2 FROM tbl_Table1 t1 LEFT JOIN tbl_Table2 t2 ON t1.column = t2.column1 + ':' + t2.column2
__________________
Come JOIN the party!!! Quote of the Month: Pretension: The downside of being better than everyone else is that people tend to assume you're pretentious. Questions to Ponder: You can be overwhelmed and underwhelmed, but why can't you be simply whelmed? iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm") copyright© 2008 sbenj69
|
|
| Viewing: ASP Free Forums > Database > SQL Development > Sql Split |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
