There is a cute solution which i borrowed from some articles about Tallys on this Web-Site.

Check this out: http://www.sqlservercentral.com/articles/T-SQL/63003/

Here is how i implemented:

1. Create a Tally table. This...

i like this solution "((DatePart(dw,'2009-12-17') + @@DateFirst -2)%7)+1"

this is the best

this is what i've come up with years ago:

it returns Monday as 1, Teusday as 2 etc..., regardles of @@Datefirst.

declare @Date datetime

select @Date = '2009-12-17'

selectcasewhen (datepart(weekday,@Date) + @@Datefirst - 1)%7...

Hi guys,

my reason for googling about varchar(max) and varchar(8000) is daclaration of variables.

Is there any performance effect when using (max) in scalar functions or table-valued functions?

There have been server performance...

very good articel! thx