asked on
USE [BlueDot];
GO
/****** Object: StoredProcedure [dbo].[report_basic_employer_01_results] Script Date: 12/29/2015 14:13:02 ******/
SET ANSI_NULLS OFF;
GO
SET QUOTED_IDENTIFIER OFF;
GO
ALTER PROCEDURE [dbo].[report_basic_employer_01_results] @Firmid INT,
@Empids INT
AS
SELECT c.Id ,
c.CaseId ,
c.EmpId ,
c.AlienId ,
c.FirmAddressId ,
c.ExpDate ,
d.FirstNm ,
d.MiddleNm ,
d.LastNm ,
d.Email ,
d.NiStatus ,
d.ExpiresOn ,
c.FirmId ,
c.MainCase ,
d.NIVMaxStatus ,
b.MaidenNm ,
e.Processcatalog ,
c.Archived ,
f.Filedon ,
f.Approvedon ,
f.Validtodate
FROM Cases c
LEFT JOIN Users AS d ON c.AlienId = d.UserId
INNER JOIN Processcatalog AS e ON c.Process = e.ProcesscatalogID
INNER JOIN Users AS b ON c.EmpId = b.UserId
LEFT JOIN Activities_Misc AS f ON f.act_misc_id = c.Defaultrecpt
WHERE c.FirmId = @Firmid
AND c.EmpId IN (@Empids)
AND c.Archived = 0
ORDER BY d.LastNm ,
c.CaseId;