Thanks,

I have got the solution.

After Insert statement trigger:

CREATE TRIGGER Field_Executive_Trigger

ON FIELD_EXECUTIVE_DETAILS

FOR INSERT

AS

BEGIN

DECLARE @FIELD_EXECUTIVE_ENROLLMENT_NO INT

SET @FIELD_EXECUTIVE_ENROLLMENT_NO = (SELECT FIELD_EXECUTIVE_ENROLLMENT_NO FROM inserted)

DECLARE @BRANCH_ID INT

SET @BRANCH_ID = (SELECT BRANCH_ID FROM inserted)

DECLARE...

Thanks for the reply it is working great.

Thanks again

Syed.

Thanks for the reply,

You didnt get my question right i want to select the values from that xml data column randomly, because I wanted to Insert a lot of data...

Hi,

My Inputs at present in my stored procedure is hardcoded. If one query match in a single row then some percentage is assigned, if two querys match then different percentage...

Hi,

I want in a single row how many columns are matching and accordingly get the percentage of columns matched in a single row

Thanks,

Hi,

I want in a single row how many columns are matching and accordingly get the percentage of columns matched.