The definition was a typo, actually it is in a table with datetime columns.

Your previous day code works fine with specified vendorid and specified schedid, but i am having trouble...

Thanks so much, i progressed a lot with your inputs, but now i need to loop this whole thing with a table that has multiple startdate and enddate instead of...

Thanks so much

Thanks so much, well I had already achieved the resultset yesterday (but with loop:)) urs worked liked a breeze without loop!!Thanks again..

OfficeId WeekdayId ...

Hi Can you check if this helps....

SELECT * FROM (SELECT

Top 2

entriesID

,name

,packageLevel

,NEWID() AS [RANDOM]

FROM Entries

WHERE packageLevel = 1

ORDER BY packageLevel desc, RANDOM) TableA

UNION

SELECT * FROM (SELECT top...