Ok ok fine. but im not getting the value for the following query

set sqlqry = 'select' + @oc +'from inserted'

exec(sqlqry)

yA MY DEAR FRND I KNOW THAT 🙂 🙂 bUT I COMMENTED THOSE LINES. sRY FOR POSTING INCLUDING MY COMMENTED LINES

Thanks for the link, but i need to do the operation using QUERIES

select B.Name as TableName,A.name as TriggerName

from sysobjects A,sysobjects B

where A.xtype='TR'

AND A.parent_obj = B.id

Make use of the abocve query and check for other triggers that are involved in the table.

SELECT EMPNAME,

AMOUNT,

RECIVEDDATE

FROM Table_Name A

WHERE RECIVEDDATE = (SELECT MAX(Reciveddate) FROM Table_Name B WHERE A.RecivedDate = B.RecivedDate)

Plz let me knw, whther this query solved your...

ALTER TRIGGER INSERTTRIGGER ON dbo.opportunitybase

AFTER INSERT

AS

BEGIN

DECLARE @Operation int

DECLARE @opp_Name varchar(100)

DECLARE @EstiCloseValue varchar(100)

DECLARE @Opp_id uniqueidentifier

SET @opp_Name = (SELECT NAME FROM INSERTED)

SET @EstiCloseValue = (SELECT ModifiedOn FROM INSERTED)

SET @Opp_id = (SELECT...

Hi ,

I too faced the similar problems and i came up with a solution. But before telling that, i would like 2 ask the following questions,

1. Did you...

Can you send me the sample datas. And also please send me the script for creating the tables with sample data's.