Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
CREATE PROCEDURE [dbo].[Office_stats] @searchString varchar( 38 ) as IF @searchString IS NULL SET @searchString = '%' IF @searchString = 'LIKE ''%'' ' SET @searchString = '%' IF @searchString IS NOT NULL SET @searchString = SUBSTRING (@searchString , CHARINDEX ( ' ', @searchString ) + 1, LEN (@searchString )) SELECT * from employee left outer join OfficeEmps on employeeid = acempid and ( acchannelstatus = 'complete' or acchannelstatus = 'WaitForComplete') left outer join EmpsHistory on chempid = employeeid and chid is not null and chdistrict = '' left outer join officeNames history on chid= history .cnuid and chid is not null and chdistrict = '' where worklocation in( 'Blue Room Services' , 'Green States town' , 'Estats service' , 'Valley union' , 'pringles Office' , 'Eddies Office' , 'Bluntsville Center' , 'Palisdale Center' , 'Union Station Center' ) and deptid in( '523' ,'521' , '525', '529' ,'524' , '631') and worklocation LIKE @searchString Go PRINT @searchString Go
Join the community of 500,000 technology professionals and ask your questions.