----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: GreatScorpion75 Message 8 in Discussion Hi Balaji, As Srinivas suggested, in a stored proc send these 4 numbers as parameter. Form a combination of values (16 combinations) A,B,C,D out of the 4 numbers. Take all these combinations in a temporary table. Check if any of the values from the temporary table exists in your tablename. If no combination exists, then insert the value in tablename. Regards Naveen <LABEL id=HbSession SessionId="4167614605"></LABEL> -----Original Message----- From: BalajiKrishnan [mailto:[EMAIL PROTECTED] Sent: 24 November 2003 14:59 To: BDOTNET Subject: Re: PLS HELP IT IS VERY URGENT.................. New Message on BDOTNET PLS HELP IT IS VERY URGENT.................. Reply Reply to Sender Recommend Message 4 in Discussion From: BalajiKrishnan Hi Srinivas, Actually I am stuck with the logic... how can i check the values bcos the user has enteed 32,45,56,66 where as in the table it might be 32,45,66,56. so my check will fail Select * from tablename where value = '32,45,56,66' No result will be found...... can you get my proble..if not i will explain you again.. Balaji View other groups in this category. ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
