Date and case loop

My date work but I need to put it in a case loop, can anyone help me.

Declare @DayOfWeek int
Declare @dayname varchar(10)
set @DayOfWeek = datepart(dw, getdate())
case
When @DayOfWeek = 1 Then @dayname ='Sunday'
When @DayOfWeek = 2 Then @dayname ='Monday'
When @DayOfWeek = 3 Then @dayname ='Tuesday'
When @DayOfWeek = 4 Then @dayname ='Wednesday'
When @DayOfWeek = 5 Then @dayname ='Thursday'
When @DayOfWeek = 6 Then @dayname ='Friday'
When @DayOfWeek = 7 Then @dayname ='Saturday'
End
print @dayname

Thanks
Freddy

On May 17, 7:26 pm, freddy wrote:
> I need the case to show if its 1 than it's Sunday or 2 for Monday and so on....
>
> "Aaron Bertrand [SQL Server MVP]" wrote:
>
> > Why do you need to do all of that?
>
> > DECLARE @DayName VARCHAR(10);
> > SELECT @DayName = DATENAME(DW, CURRENT_TIMESTAMP);
> > PRINT @DayName;
>
> > "freddy" wrote in message
> >
> > > My date work but I need to put it in a case loop, can anyone help me.
>
> > > Declare @DayOfWeek int
> > > Declare @dayname varchar(10)
> > > set @DayOfWeek = datepart(dw, getdate())
> > > case
> > > When @DayOfWeek = 1 Then @dayname ='Sunday'
> > > When @DayOfWeek = 2 Then @dayname ='Monday'
> > > When @DayOfWeek = 3 Then @dayname ='Tuesday'
> > > When @DayOfWeek = 4 Then @dayname ='Wednesday'
> > > When @DayOfWeek = 5 Then @dayname ='Thursday'
> > > When @DayOfWeek = 6 Then @dayname ='Friday'
> > > When @DayOfWeek = 7 Then @dayname ='Saturday'
> > > End
> > > print @dayname
>
> > > Thanks
> > > Freddy

Why do it yourself if the system will do it for you?

http://msdn.microsoft.com/en-us/library/ms174395.aspx