Again iam getting the dec month in end of result...

[2009-Nov],[2009-Oct],[2009-Sep],[2009-Aug],[2009-Jul],[2009-Jun],[2009-May],[2009-Apr],[2009-Mar],[2009-Feb],[2009-Jan],[2009-Dec]

Can you please help me how to prevent this.

For this i am using following SQL: CAST(DATEPART(yyyy,getdate()) as varchar) + '-' + CONVERT(varchar(3),DATENAME(m,(DATEADD(m,-1,getdate())))).

I am gussing that this should give the proper result

I am trying to generate the months dynamically. I should have to get the months till current month(i.e Jan-Nov). In Jan 2010 i should have to generate the months from...

This should give date range from Nov01 to Nov'30

i got your problem....The server should be FTP and Folder should be shared...

If you get a chance place the error message..it would helpful to debug...

i will give you an example...Let's take december month..I have to get 1st week in 1-5 and second week 6-12 and third week 13-19 fourth week 20-26 and fifth week...

i will give you an example...Let's take december month..I have to get 1st week in 1-5 and second week 6-12 and third week 13-19 fourth week 20-26 and fifth week...

This shouldn't give any erros. you can use this

BULK INSERT <Table Name>

FROM <File Location> (Full path)

WITH

(

...

can you please tell me how do i get only dates like 1,2,3 and so on 31. i don't want to display the time stamp, month and year and all...

thanks...

i have one small request instead of getting to display all i just wanted to display like 1,2,3,4....and so on 31 thats it.

Thanks much

In my report i should not use any other tables.

I just wanted to get days to be displayed for given month

actuvally there are 2 reports One for all the dates, another for data just from last week. By last week I mean a previous week for any given date.

suppose if...

currently i am generating the report for all the weeks. now i would like to generate the report only for previous week in any given date for that i need...

week can be considered SUN-SAT. Please let me know if you need any more details

I want the report like this.

program name Jan(01/01-01/07) jan(01/08-01/14)......may(05/25-05/31)

XXXXXX ...