sql server 2012

iam having one sp every ten min once the sp will run in scheduled. i have one doubt in that. iam having trigger table in that trigger table any updation and insertion happens pkid will store in trigger table. by joining trigger pkid and my original table i'll get the  changed record.  by checking this i'll update the changed record in one table  (loln_lnmistranprocess)  if not that record i'll insert  (loln_lnmistranprocess)

For Eg: in that table already some cases are processes and marked as record processed as Y . my doubt is some old record processed  y  anything again changed in trigger ( 15 records are tere 5th record got again changed it processed in loln_lnmistranprocess this table how can i identified)

how can i identify in between records changed?

i'll attach my sp
kowsika deviAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

HuaMin ChenProblem resolverCommented:
The trigger would be fired whenever there is ANY change to original table. Each record change (like insert/update), would fire the trigger (of table) once.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
HuaMin ChenProblem resolverCommented:
Hi Kowsika,

Is this resolved?
HuaMin ChenProblem resolverCommented:
Details are given to resolve this
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.