Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SQL Express connecting form remote error 26||7||55|
|Bubble user-defined Sql RAISERROR(...) to c# exception||14||202|
|SQL Server Insert where not exists||24||52|
|Find unused columns in a table||12||68|