----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Mrinal Message 1 in Discussion Hi EveryBody , I am dealing with a problem related to temporary tables in sql server , basically i am implementing them to remove the usage of cursors in stored procs. now problem is that while filling the temporary table i am adding couple of additional fields in that select statement itself , foe e.g: select a,b,c, 0 as d , 0.0 as e from MyTable1 , MyTable2 Where < Condition > Now These d & e fields , i am utilizing for processing some logic as they are not ordinary columns but they pertains to a column in some other table not in that select statement , but is used to execute update statement later on . Now those columns are having data types as money(8) for d and numeric(5) for e Now when i go ahead this creates a problem as it throws some overflow error as i am sure that by default it can't take those fields as money & numeric and when i try to use Alter Table Command in my stored proc it gives an error : " Access Violation / Driver Error or syntax Error " Can Anybody Suggest me a solution for this problem Regards , Mrinal ----------------------------------------------------------- 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]
