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