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