Viewing 3 posts - 1 through 3 (of 3 total)
Your result doesn't look right to me ..... can't see how week 2 starts one day later than week 1 ....
Try
SELECT weekno,
CONVERT(char(10),DATEADD(dw,(weekno-1)*7,CONVERT(datetime,'01/01/'+CONVERT(char(8),@Year))),101) as BW,
CONVERT(char(10),DATEADD(dw,(weekno-1)*7+6,CONVERT(datetime,'01/01/'+CONVERT(char(8),@Year))),101) as EW,
Agency,
Type,
PartnerName,
Callcenter,
Calls,
Res,
Rnt,
VDN
from #v_BGPartner_WK_TLS
August 3, 2006 at 6:38 am
I suggest you look into a Linksys WRT54GL Router (62.99 at http://www.newegg.com) and replace the factory firmware with the DD-WRT firmware from http://www.dd-wrt.com. The firmware is a free...
June 6, 2006 at 5:33 am
Even a blind chicken gets a piece of corn now and again ...
January 6, 2006 at 7:12 am
Viewing 3 posts - 1 through 3 (of 3 total)