A few corrections: instead of using weekday (dw) need to use day(dd).
Also should be adding 6 instead of 7 to get the last day of the week.
************************************************

declare @mydate varchar(20)
declare @yearbegin varchar(20)
declare @firstday varchar(20)
declare @endday varchar(20)
declare @day int
declare @year char(4)
declare @week int

set @year = '2001'
set @week = 25
set @yearbegin = '01/01/'+ @year

set @mydate =  dateadd(ww,@week, @yearbegin) 
set @day = datepart(dd,@mydate)-@@datefirst
select @firstday = dateadd( dd,@day, @mydate)
select @endday = dateadd(dd,6,@firstday)
select @year 'Year',@week 'Week', @firstday 'First Day of the week',@endday
'Last Day of the week' 


-----Original Message-----
From: Zadoyen, Eva [mailto:EZadoyen@s...]
Sent: Tuesday, January 15, 2002 12:33 PM
To: sql language
Subject: [sql_language] RE: How can i find out dates


Hi, Venugopal!
Try to build your date using system defined First day of the week
(@@datefirst) 

You can try the following:
************************************************

declare @mydate varchar(20)
declare @yearbegin varchar(20)
declare @firstday varchar(20)
declare @endday varchar(20)
declare @day int
declare @year char(4)
declare @week int

set @year = '2001'
set @week = 25
set @yearbegin = '01/01/'+ @year

set @mydate =  dateadd(ww,@week, @yearbegin) 
set @day = datepart(dw,@mydate)-@@datefirst
select @firstday = dateadd( dd,@day, @mydate)
select @endday = dateadd(dd,7,@firstday)
select @year 'Year',@week 'Week', @firstday 'First Day of the week',@endday
'Last Day of the week' 
**********************************************

Good luck!
	Eva

-----Original Message-----
From: venugopal k bhandary [mailto:vgbhandary@r...]
Sent: Tuesday, January 15, 2002 4:51 AM
To: sql language
Subject: [sql_language] How can i find out dates



Hi all 
In my table iam storing week no ,yearno as(2001 or 2002 etc ) 
now  using the weekno i have to find the starting date of that week and
ending date of that week in a querry 
please help me out