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 |
conyenwe
Starting Member
1 Post |
Posted - 2010-04-17 : 11:49:53
|
I HAVE A PROBLEM AND NOW NEED A SOLUTION. I HAVE A COLUMN CALLED "INCREMENT" AND I HAVE ANOTHER COLUMN CALLED "DEFAULT1" AND I WANT TO JOIN OR CONCATENATE THE TWO COLUMNS AUTOMATICALLY WITHIN ANOTHER COLUMN CALLED "STRINCREMENT". "STRINCREMENT" IS SUPPOSE TO BE AUTOMATICALLY THE PRODUCT OF THE OTHER TWO COLUMNS. I GOT THIS DONE SUCCESSFULLY BUT THE PROBLEM IS THAT THE RESULTING DATA FROM THE JOIN SPACES OUT AND I WANT THEM TOGETHER. FOR EXAMPLEINCREMENT = 1001DEFAULT1 = DWTSTRINCREMENT = DWT 1001BUT I WANT STRINCREMENT = DWT1001TOGETHER NOT SEPARATED. ANY CLUE AND HELP WILL BE VERY MUCH APPRECIATED. THANK YOU!coo |
|
malpashaa
Constraint Violating Yak Guru
264 Posts |
Posted - 2010-04-17 : 13:02:39
|
You need to post more information like the datatypes of your columns and how you concat them. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-04-18 : 13:08:57
|
In you concatenating code use rtim(DEFAULT1) instead of DEFAULT1.If that is not working then you have some special charaters in your data.In this case come back and post your code and your result. No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|