Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.
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
|How can I limit the number of rows I'm getting in my recordset?||4||50|
|Powershell SMO script not working.||18||100|
|How to order Highest and lowest value rows alternatively in SQL Server ?||4||24|
|SQL Server memory Issue||7||74|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!