Select top 2 gop.iOpendOnID
, dbo.fc_GetTypeCode(gop.iDayID) As cDay
, dbo.fc_GetTypeCode(otd.iDayPartID) As cDagPart
, otd.cHHMMFrom
, otd.cHHMMTo
From OpenTimes otd
Inner Join OpenOn gop On otd.iOpenOnID = gop.iOpenOnID
Where gop.iLocationID = @tiLocationID -- FK
And ( gop.iExamID = @tiExamID
Or IsNull(@tiExamID,-1) = IsNull(gop.iExamID,-1)
)
Order By cDay
-- For XML Auto, Elements
iOpendOnID cDay cDayPart cHHMMVan cHHMMTot
------------ ---- -------- -------- --------
2 DI DAYTIME 0900 1700
2 DI EVENING 1800 2100
<gop>
<iOpendOnID>2</iOpendOnID>
<cDay>DI</cDay>
<cDayPart>DAYTIME</cDayPart>
<otd>
<cHHMMFrom>0900</cHHMMFrom>
<cHHMMTo>1700</cHHMMTo>
</otd>
<otd>
<cHHMMFrom>1800</cHHMMFrom>
<cHHMMTo>2100</cHHMMTo>
</otd>
</gop>