----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Arian_Intellect Message 2 in Discussion y don't u create the table structure before and then update the value. I am not very clear what ur trying to say. Be a bit clear Shaju Thomas e-Cosmos Technologies Ltd., Mail: [EMAIL PROTECTED] Phone(Off) : 51217038/39 Extn: 132 Mobile: +91 98455 21794 ----- Original Message ----- From: Mrinal To: BDOTNET Sent: Thursday, October 16, 2003 7:46 PM Subject: Regarding Sql Server Temporary Tables ----------------------------------------------------------- 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] ----------------------------------------------------------- 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]
