----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: raagz Message 2 in Discussion Hi , Not sure whether this is the correct answer to your question. But i guess Dynamic SQL queries is the solution. more details on Dynamic SQL http://www.4guysfromrolla.com/webtech/102300-1.shtml SQL gurus am i right ? Thanks Raghavendra -----Original Message----- From: Pmurugan [mailto:[EMAIL PROTECTED] Sent: Friday, September 17, 2004 6:17 PM To: [EMAIL PROTECTED] Subject: Best apporch to join tables dynamically in Sp New Message on BDOTNET Best apporch to join tables dynamically in Sp Reply Reply to Sender Recommend Message 1 in Discussion From: Pmurugan Hi All, I need use 15 tables and 20 parameters to fetech the data from the SqlServer2000 database. These 20 parameters spreded over 15 tables, all are optional parameters, i need join the tables dynamically based on the input parameters passed(if is not Null) please suggest me the best approch to do this..., Thanks in advance Regards Murugan _________________________________________________________________ Movies, music, celeb news. Stay in the loop. http://www.msn.co.in/cinema/ With MSN Entertainment! 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]
