Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).
Full Procedure ALTER Proc [dbo].[sp_CreateTasks] (@SSN as varchar(9), @EventId as integer) AS --Insert all the records into tblSRpEventDataHistory Insert tblSrpEventDataHistory (intPersonnelId, intSRpAttendID, intQuestionId, intAnswer, strData, strRemarks, strDocDate, dtLogged, strLogged) Select intPersonnelId, intSRpAttendID, intQuestionId, intAnswer, strData, strRemarks, strDocDate, dtLogged, strLogged From tblSRPEventData where intPersonnelID = @SSN and intSRPAttendId in (Select intSRPAttendId from tblSRPAttendance where intEventId = @EventId) --Insert all records that have answer of 1 into tblPermTask --Insert only one unique record the id's in both fields that should match are intQustionId and strssn Insert tblPermTask (intQuestionId, intSrpAttendID, strTaskName, dtFound, strSSN, strNotes) Select ed.intQuestionId, ed.intSRpAttendID, q.strShortTask, ed.dtLogged, ed.intPersonnelId, ed.strRemarks From tblSRPEventData as ed INNER JOIN tblSRPQuestion as q on q.intQuestionId = ed.intQuestionId Where intAnswer = 1 and intPersonnelID = @SSN and intSRPAttendId in (Select intSRPAttendId from tblSRPAttendance where intEventId = @EventId)
|Unable to change SQL 2008 from Windows Authentication to Windows/SQL mixed mode||10||24|
|SQL for monthly balance change||15||51|
|Output query to a text file||20||68|
|SQL Syntax: How to Find Commonality Among Similar Results||2||15|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
8 Experts available now in Live!