SELECT * FROM

( SELECT a.AssigneeID, b.ProjectID, c.StepID,d.StepDesc, d.statusid FROM KLA_ProjectAssigneeXRef a INNER JOIN

KLA_PROJECT b ON a.projectid = b.projectid INNER JOIN

KLA_ProjectStep c ON b.projectid = c.projectid INNER JOIN

KLA_Steps d ON...

There are 1400 record into KLA_steps table if i ran for 10 it works bit 1400 it dont work

DECLARE

@v_sql AS NVARCHAR (MAX) = '' ,

@v_statusdec_in_sql AS NVARCHAR (MAX) =...