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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply