Ramco Ramco

Ramco Ramco

  • 443
  • 3.4k
  • 521.1k

Select Statement Query

Apr 11 2023 9:05 AM

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)