Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.
begin SET NOCOUNT ON --adjust to make the COL refs predictably 2 char set @start = upper(case when @start like '[A-Z][0-99]%' then '@' else '' end +@start) set @end = upper(case when @end like '[A-Z][0-99]%' then '@' else '' end +@end) SET NOCOUNT OFF -- this inserts into table named "Grid" insert blockdirectory (countryCode ,cityCode ,storeCode ,storeType , gridCodeX , gridCodeY) select @countryCode, @cityCode, @storeCode, @storeType, REPLACE(COL,'@','') + right(ROW,2), REPLACE(COL,'@','') + right(ROW,2) from ( -- this inner query generates all the references from @A1 through ZZ99 -- the @ is a placeholder for single-letter columns select char(a.number)+coalesce(char(b.number),'') as COL ,d.number as ROW from master..spt_values a left join master..spt_values b on b.type='P' and b.number between 65 and 90 inner join master..spt_values d on d.type='P' and d.number between 1 and 99 where a.type='P' and a.number between 64 and 90 ) F -- filter for the range of COL/ROW required where COL between left(@start,2) and left(@end,2) and ROW between substring(@start,3,3) and substring(@end,3,3) update blockdirectory set dmsActive = 'False' Where dmsActive IS NULL end
|Getting network error using utl tcp package||7||54|
|I've got to change the date range for this select. How?||4||24|
|How to select/populate table with most current records||2||48|
|Whats wrong with this query||21||12|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!