check this link....

[/url]

declare @chr char

declare @chr1 char(1)

select LEN('1234567890abcdefghij0987654321xyz') -- = 33

-- when declared as CHAR or VARCHAR, default length of variable is 1, as shown.

set @chr = '1234567890abcdefghij0987654321xyz'

set @chr1 = '1234567890abcdefghij0987654321xyz'

select @chr...

Add a month to the startdate

declare @StartDate date

set @StartDate = '01-31-2010''

select DATEADD(mm, 1, @StartDate)

Repeat above code through any number of frequencies. Hope this helps.

Below is the psuedo code .... you may have to tweak it to your requirement. For more details, look up CTE in BOL and ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/82fa9016-77db-4b42-b4c8-df6095b81906.htm for Using ROW_NUMBER() with PARTITION.

Below,...

you could insert your values into a table and return the table.

declare a table variable in the function, insert ur multiple values into that table variable and return thetable variable.

Did you try using > and < instead of BETWEEN for the date range?

Hello Ahmed,

If you have got the solution, please do post it here...i would love to learn this too....

Thanks.