No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Computer professional for over 15 years primarily in Microsoft technologies. Last several years have been immersed in SQL Server and .NET Programming with C#. Deep experience with ColdFusion and JavaScript. Also good with all Microsoft OS' and Exchange.
- Interests
- Software Architecture & Programming, Cycling (Roadie)
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.