----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: BalajiKrishnan Message 1 in Discussion Review this code ALter Procedure MOL_Excel_TEST_SEC @Mode varchar(10), @SectorID float(10), @year float(10), @Month float(10), @VType varchar(25), @Value float(25) as If @Month = '1' Begin Set @strVal = 'Update tblSectorIndexData set jan = ' + CAST(@Value as varchar) + ' where SectorIndexID =' + CAST(@SectorID as varchar) + ' and year = ' + CAST(@year as varchar) + ' and ValuType =' + CAST(@VType as varchar) print @strVal End When I print this I get Update tblSectorIndexData set jan = 2629.8 where SectorIndexID =201 and year = 1995 and ValuType =Average this gives errror bcos valutype is a varchar(30) so how can i overcome this.. pls help it is very urgent Balaji ----------------------------------------------------------- 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]
