
Assuming basedate is required, the following 2 results were found.
DECLARE @GivenDate datetime, @GivenCampus varchar(100), @setId varchar(10), @weekNumber int, @siteId nvarchar(5), @baseDate datetime, @specifiedDate datetime, @specifiedCampus varchar(25) SET DATEFORMAT dmy --SET @GivenDate = '1/7/2011' --SET...
wm ON (wm.[SetId] = tt.[SetId] and wm.[WeekId] = tt.[WeekId]) WHERE sd.[SetId] = @setId AND dateadd(d, tt.[WeekDay] - 1, @baseDate) = @GivenDate AND wm.[WeekNumber] = @weekNumber AND tt.[SiteId] = @siteId AND upper(sd.[Descrip]) not like 'ADDITIONAL...

bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF