If I have a query based on (see Code below)
This will eventually end up in a stored procedure, I do not need help with the stored procedure, but do need help with getting this part of the query right.
The Month/Day part of the date remains constant, but the Year will change, how do i use date part?
In advance, many thanks for your help.
FROM tms2008.dbo.tblTransactions tx INNER JOIN
tblTasks tsk ON tx.TaskCode = tsk.TaskCode
WHERE (tx.ActivityDate BETWEEN CONVERT(DATETIME,
'2008-04-01 00:00:00', 102) AND CONVERT(DATETIME, '2008-08-31 00:00:00', 102))