tbiggi
Posts: 59
Score: 1
Joined: 9/13/2001
Status: offline
|
Here is a report that shows advertisments with a start date within the past seven days.
The query for the report is:
select distinct PresentTime as AdvertisementStartTime,
OfferID as AdvertisementID,
OfferName as AdvertisementName,
PkgID
from dbo.vOfferStatusSummarizerRoot
where PresentTime >= (GETDATE() - 7)
order by PresentTime Desc
and it is setup with a link (drill down) to report 111 (Status of a specific advertisment).
For those reports within the past seven days we create and send out status reports on day 1, day 3 and day 5 after the start day. This will eventually be tied in with a SQL job to automatically generate the report and email it out but I only want that to occur on weekdays and not on weekends. The challenge is to determine if that day 1,2 or 3 falls on a weekend day and if it does, pick the next weekday.
How can that be accomplished in TSQL or WSQL (I'd like to add the Day 1/3/5 days/dates to the web report as well)?
|
Printable Version
Web Report for advertisements in the past week - need t... - 
New Messages
No New Messages
Hot Topic w/ New Messages
Hot Topic w/o New Messages
Locked w/ New Messages
Locked w/o New Messages
Post New Thread