2
Answers

Select Statement Query

Ramco Ramco

Ramco Ramco
1y
528
1

Hi

 In below Select statement if it is false then i want to write another Select statement which should check that if indate exists between StartDate And Endate in Invoice it should also be Break else ''

CASE WHEN ISNULL((SELECT TOP 1 DG.[OnBreak] FROM [SessionDeliveryParticipant] DG WHERE DG.[StudentID]=GP.[StudentID] AND DG.[SessionDeliveryCalendarID]=C.[SessionDeliveryCalendarID] AND DG.[Deleted]=0),0)=1 THEN 'Break' ELSE '' END AS [OnBreak]

Thanks

Answers (2)
Next Recommended Forum