December 19, 2001 at 9:47 pm
SELECT @Table=OldTable , @DataType=OldDataType from Dict Where OldVariable = RTRIM(LTRIM((@Variable)))
this might return 2 rows of data,, how would i get both values from @Table/@DataType?
For example if OldVariable is 'dob' -- OldTable would be Fixed and Nat but i only get Nat in @Table.
December 20, 2001 at 1:55 pm
you could
@Table=coalesce(@Table + ',','') + OldTable
which will give 'Fixed,Nat'
or insert into a temp table or table variable.
Cursors never.
DTS - only when needed and never to control.
December 21, 2001 at 9:50 am
You can also do something like this:
http://www.sqlservercentral.com/columnists/sjones/tamestrings6.asp
Steve Jones
December 21, 2001 at 9:55 am
Both solutions worked just fine,, thanks a bunch for your help.
December 21, 2001 at 10:07 am
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy