There are two potential solutions depending on whether the child records have the same category_id and ldk_id as the master record.  (NOTE: this is where sample data would be...

I agree with Phil.  Posting inserts to populate the test table with data will help a whole lot.

Also, the code you posted isn't from SQL Server but, since you...

Hi Phil,

Sorry , I have missed to add test data in my...

Hi,

I am trying to run the SQL query mentioned below. The query executes within 8 seconds in Postgresql but it runs for more than 1 minute 40 seconds...

Hi Sommarskog ,

Sorry for late response !!!

I had a urgent travel..

Thanks very much for your suggestion.. As you advised I have modified the Concat query to below and it is...

Hi ,

My Database is in Oracle but I think the solution to my problem will work in both SQL and Oracle.Please let me know if otherwise.

Ed Wagner (11/16/2016)

---

Is it my imagination, or are you firing INSERTs in a loop against the same table the trigger is firing on? You have a cursor inside your...

Hi Jacob & Steve,

Thanks very much for providing easy solution to my problem.

That solved my problem and i got what i wanted.

Thanks Again 🙂