Interesting idea... Hey, Bradford, you can test that idea by doing a:
Print @SQL Before the execute statement in the code I supplied earlier. That might show something... -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 13:35 To: SQL Subject: RE: Concatenation assistance... Because you pass the list in through a variable, the query actually expands to look like this to the server: (x.cyb_record_num NOT IN ("'32','432','43','23','112'")) In other words, you're looking for a record where cyb_record_num equals the whole string, not one value in a list of values. Thanks, Eric "Bradford T Comer" <[EMAIL PROTECTED]> 09/05/2003 01:17 PM Please respond to sql To: SQL <[EMAIL PROTECTED]> cc: Subject: RE: Concatenation assistance... I finally figured that out, thanks. Here is a second question, I have a SP that I pass into it a list e.g. '32','432','43','23','112' then I use that parameter for the WHERE clause, using IN e.g. (CAST(x.cyb_record_num AS varchar(25)) NOT IN (@spExcludeListB)) However it still returns the records with ID's in the list. If i hard code it, works as it should: (x.cyb_record_num NOT IN ('32','432','43','23','112')) WTF??? Anybody have any pointers? I have been banging my head for an hour. Brad -----Original Message----- From: Raster, Tim [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 9:31 AM To: SQL Subject: RE: Concatenation assistance... Did you initialize your @NewRecordIDList = '' first? If not, then it's null, and null + varchar = null. -----Original Message----- From: Bradford T Comer [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 06:10 To: SQL Subject: RE: Concatenation assistance... Correction...it DOES display the @SID for the PRINT statement, however after the END I have this: PRINT 'TEST' PRINT 'HELLO' + LTRIM(@NewRecordIDList) This displays the following: TEST That is it, why doesnt the @NewRecordIDList get displayed? Brad -----Original Message----- From: Bradford T Comer [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 6:07 AM To: SQL Subject: Concatenation assistance... Why doesn't this output anything? I know that the @SID has a AT least 1 value??? ... WHILE (@@FETCH_STATUS = 0) BEGIN PRINT @SID -- appendIDTo @NewRecordIDList SET @NewRecordIDList = @NewRecordIDList + ',' + CAST(@SID AS VARCHAR(25)) END ... Thanks Brad [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:> Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
