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 (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>
Our community of experts have been thoroughly vetted for their expertise and industry experience.