Thanks a lot

Thank you

Thank you sir

Thanks for all reply. Really appreciate

Hello Sir,

It is masterpiece

Thanks Jeff

Hi Jeff Moden,

Your Trigger looks working (Insert & Update). But Delete, I need TrnxUserId same like CrtBy and UpdBy. Not User in SQL Server

This is the Front-End...

Any chance you can convert that multiline scalar function to an inline table value function? Multi-line scalar functions can perform poorly, and your function has a WHILE inside it,...

Thanks. It workable

Adelia,

Don't go yet.  I asked you some questions about datatypes that you've not answered yet.  If you let me know that the datatypes of the start...

Thanks to all

Thanks

I got the answer. Yeahhh

You have data. How about posting CREATE TABLE and INSERT scripts so we can see what you're working with? While you're at it, post the expected result... but for...

It's perfect