Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).
declare @curr int declare @cstatus int declare @cnotin int DECLARE @cepp int DECLARE @cproduction INT DECLARE @cdone INT set @curr= (select min(jobn) from OpenJob where jobStatus in (0,2) and jobN > 0) SET @cnotin = 0 SET @cepp = 0 SET @cproduction = 0 SET @cdone = 0 WHILE @curr <= (SELECT MAX(jobN) FROM openJob WHERE jobStatus IN (0,2)) BEGIN IF EXISTS(SELECT jobn FROM openjob WHERE jobn=@curr AND jobStatus IN (0,2)) BEGIN SELECT @cstatus=StatusCoden FROM statuscode where statuscoden = (select statuscode from JobStatus1 where jobn = @curr and transactionN = (select max(transactionN) from jobStatus1 where jobn=@curr)) if @cstatus IS NULL set @cstatus = '' IF @cstatus BETWEEN 35100 AND 35108 SET @cnotin = @cnotin + 1 ELSE IF @cstatus BETWEEN 35109 AND 35254 SET @cepp = @cepp + 1 ELSE IF @cstatus BETWEEN 35255 AND 78100 SET @cproduction = @cproduction + 1 ELSE IF @cstatus >= 78101 SET @cdone = @cdone + 1 END set @curr = @curr + 1 END SELECT @cnotin AS 'Not In', @cepp AS 'EPP', @cproduction AS 'Production', @cdone AS 'Done'; IF @cstatus BETWEEN 35100 AND 35108 SET @cnotin = @cnotin + 1 ELSE IF @cstatus BETWEEN 35109 AND 35254 SET @cepp = @cepp + 1 ELSE IF @cstatus BETWEEN 35255 AND 78100 SET @production = @production + 1 ELSE IF @cstatus >= 78101 SET @done = @done + 1
|Macro to Refresh the Hyperlinks without opening the source files||1||35|
|Relative link_location when pasting a =HYPERLINK() formula to a different cell in Excel||7||17|
|Need Distinct Value from Joined Tables in MSSQL||5||23|
|Why did I get the file extension .xlk when I added a plug-in in my Excel 2007 and can/should I save it as .xlsm next time?||3||16|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!