Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat. The purpose of this eBook is to educate the reader about ransomware attacks.
ALTER PROCEDURE sp_GetAllEvaluationVisit( @ParticipantID as int) AS BEGIN SET NOCOUNT ON --declare @ParticipantID as int --set @ParticipantID = '1' Select e.ParticipantID as [ParticipantID], e.DateEvaluation as [DateEvaluation], (case when (e.EvaluationID = 0) then '' when (e.EvaluationID = 1) then 'Program Begin' when (e.EvaluationID = 2) then 'Program End' when (e.EvaluationID = 3) then 'Six Month' end ) as [EvaluationType], (case when (s.SchoolID = 0) then '' when (s.SchoolID = 1) then 'Santee Educational Complex' when (s.SchoolID = 2) then 'Jefferson' when (s.SchoolID = 3) then 'Dorsey' when (s.SchoolID = 4) then 'Fremont' when (s.SchoolID = 5) then 'West Adams' end ) as [SchoolName], s.Age as [Age], (case when (s.Gender = 1) then 'Male' when (s.Gender = 2) then 'Female' end ) as [Gender] from tbl_EvaluationVisit e join tbl_Survey s on e.ParticipantID = @ParticipantID and s.ParticipantID = @ParticipantID
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!