Hi Here is your complete solution please check.
Declare @Start DATETIME
declare @end DATETIME
DECLARE @ans nvarchar(1)
SET @Start='2014-12-6'
SET @end='2014-12-15'
WHILE @Start <= @end
BEGIN
if((select DATENAME(dw,@Start))='Saturday' or (select DATENAME(dw,@Start))='Sunday' )
BEGIN
SET @ans='Y'
BREAK
END
ELSE
BEGIN
SET @ans='N'
END
SET @Start=DATEADD(day,1,@Start)
END
PRINT @ans