ALTER PROCEDURE [dbo].[delete_report_byuser_01_results] ( @Firmid INT, @filed_start DATE, @filed_end DATE ) AS SELECT a.Id , a.CaseId , z.RcptNo , z.Filedon , z.Approvedon , z.Validtodate, s.description AS casestatus FROM Cases a LEFT JOIN Users AS f ON a.EmpId = f.UserId INNER JOIN dbo.admin_casestatus AS s ON s.idstatus = a.Archived LEFT JOIN Users AS d ON a.AlienId = d.UserId INNER JOIN FilingType AS k ON a.Processtype = k.FilingTypeId LEFT JOIN Employment AS L ON d.UserId = L.UserId AND L.CurEmp = 1 LEFT JOIN FirmAddresses AS m ON a.FirmAddressId = m.Id INNER JOIN Processcatalog AS e ON e.ProcesscatalogID = a.Process INNER JOIN Atts AS J ON a.Id = J.CaseId INNER JOIN Users AS I ON J.UserId = I.UserId LEFT JOIN PreferenceType AS o ON o.PrefTypeid = a.PrefType LEFT JOIN Partiescont AS v ON d.UserId = v.PartcontId AND Relation = 'spouse' LEFT JOIN Users AS h ON v.UserId = h.UserId LEFT JOIN Activities_Misc AS z ON z.act_misc_id = a.Defaultrecpt WHERE a.FirmId = @Firmid AND ( z.Filedon BETWEEN @filed_start AND @filed_end )
EXECUTE [delete_report_byuser_01_results] @Firmid = 2, @filed_start = '01/01/2015', @filed_end = '01/01/2050'
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Connect with Certified Experts to gain insight and support on specific technology challenges including:
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE