question

BHVSVASU avatar image
BHVSVASU asked

Recursive CTE

  1. tables-script.txt
  2. query.txt

If i execute the above query getting error message Transaction log for TempDB is full.
Is there any way to write recursive CTE for above query to improve the performance?

tsqlperformancecterecursion
tables-script.txt (10.3 KiB)
query.txt (2.9 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.