Sanchit297 (6/13/2010)

---

Thanks for the suggestion Lutz, but it is not possible for me to edit the EXE as numerous other reports are produced from the SQL Server 2000 box from...

As Gail already pointed out: you need to add the ORDER BY to your select statement that is used to export the data.

To use the related section of your original...

When thinking about it again:

Why do you need to have separate tables per month?

Do you have to deal with such a large data volume? Did you consider horizontal partitioning?

I'm sorry, missDelinda... You provided ready to use sample data so you should expect a coded and tested answer...

Edit: I decided to use a different style for FromDate and...

Please have a look at the cross tab article referenced in my signature.

You should rethink your concept of generating months.

Instead of dealing with integer data type for your variables you should use datetime (or smalldatetime) together with SET @runningmonth = DATEADD(mm,1,@runningmonth).

To get...

Duplicate post.

Discussion already started here

john-902052 (6/11/2010)

---

Because I want to get to know the person and go deep with the topic. Here people may or may not answer and only will work against a...

Please provide table def and some sample data together with your expected result and definition of the variable used in your query in a ready to use format as described...

john-902052 (6/11/2010)

---

I have been working with T-SQL for a few months now fulltime and have learned some of the things that I need. I would like to take my...

Jeff Moden (6/11/2010)

---

canoedoceanprince (6/10/2010)

---

, CASE DATEPART(dw, startdate)

WHEN '1' THEN 'Sunday'

WHEN '2' THEN 'Monday'

WHEN '3' THEN 'Tuesday'

WHEN '4' THEN 'Wednesday'

WHEN '5' THEN 'Thursday'

WHEN '6' THEN...

Just as a side note: Lynn (Pettis) is male, not...

Your solution seems to work for the...

I second Ninja's_RGR'us recommendation regarding the script screenshot.

For two reasons:

#1) it requires at least a little more effort to run it before answering (for those who otherwise would just...

The best (in terms of most appreciated) you can do is posting your solution. Not only...