----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: VinodK [TLabs, SCT] Message 2 in Discussion Hi Srini, Me again ...Was wondering if anyone opened this thread after seeing the subject ... :) ... Jokes apart I was also seeing the same thread that was opened in the Public Newsgroups ... Thought of giving my shot at the problem in hand ... Well, Is your primary key the Identity column. If that being the case then use the SCOPE_IDENTITY() to find the value. This is a better off way to access the same. I am not sure why you went for a complex implementation with temp tables ? Any specific reasons ? >> SELECT @V_KEY1 FROM INSERTED Surely you cannot use this way. This is not possible ... You need to use D-SQL for such syntax. And since D-SQL has its own context of access your Inserted Table is not visible outside the trigger execution context .. Basically give more information and the DDL/DML statements so that we can replicate them ... It would of great use for us to debug the same. HTH, Vinod Kumar Microsoft India Community Star www.extremeexperts.com ----------------------------------------------------------- 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]
