Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.65K
~1K People Reached
This member's community profile is only visible to logged in members until they have earned 15 reputation points.
Favorite Forums
Databases x 1
Favorite Tags
1 Posted Topic
-- declare variables DECLARE @vchColumnOutput varchar(200) DECLARE @vchWorkCode varchar(100) DECLARE @vchWorkNature varchar(100) -- select data from tblWhatever into @variables SELECT @vchWorkCode = work_code, @vchWorkNature = work_nature FROM tblWhatever -- insert a carriage return between work_code and work_nature SET @vchColumnOutput = @vchWorkCode +char(13)+ @vchWorkNature -- display work code and work nature …
The End.