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 |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2006-09-22 : 10:21:11
|
RITESH writes "sir ,i am in a problem ,plz help me ,my question is i want to make a query in which there is two table containing column vrdt, power_remarkformat is like this---table1vrdt remak09/09/06 a09/09/06 banswer format will betable 2vrdt remark09/09/06 ab" |
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-09-22 : 10:43:14
|
Take a look herehttp://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=18363 |
|
|
X002548
Not Just a Number
15586 Posts |
|
varunm
Starting Member
25 Posts |
Posted - 2006-09-22 : 13:14:32
|
Ritesh,You got the answer.Please show me up........ |
|
|
varunm
Starting Member
25 Posts |
Posted - 2006-09-22 : 21:12:06
|
simple,Try this: select col1+,',+col2u will get that. |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-09-22 : 21:23:47
|
That should beselect col1+','+col2but Ritesh you're asking for more than that, you need to read the articles at the links we gave you. |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-09-23 : 02:56:50
|
You may need to use COALESCE too - i.e. if one of the values could be NULL, and CONVERT if the date is in a DATETIME datatype columnKristen |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-09-23 : 03:56:41
|
http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspxChirag |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-09-23 : 08:36:03
|
Note that you need to use more than one variable if the concatenated values exceed more than 8000 charactersMadhivananFailing to plan is Planning to fail |
|
|
|
|
|