SQL script to list reservations between certain dates Follow
This script will list the user and reservation between certain dates.
Be sure to change DavidW2_Reservations to the name of your database.
Also, change the date range to match what you are looking for.
SELECT res.ReservedByFullName,
resOBJ.ObjectName,
res.StartDate,
res.EndDate
FROM [DavidW2_Reservations].[dbo].[Reservations] as res
left join (Select * from [DavidW2_Reservations].[dbo].[ResObjects]) as ResOBJ on resOBJ.ObjectID = res.ObjectID
where StartDate between '2020-07-27' and '2020-08-27'
Comments
0 comments
Please sign in to leave a comment.