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

 

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...

Even a blind chicken gets a piece of corn now and again ...