Thank you so much for your reply.

My case is

I am exporting rows from OrderHeader and Orderdetail tables into a text file to create the invoice. I want...

Thanks

Thank you so much for your suggestion.

Could you suggest me the steps to be set up those task within a package.

Thanks

How about SQL Server 2005 Developer Edition?

I did not see it for sell.

Thanks

I have been working in SQL Server 2005 environment. However, we have few applications in SQL Server 2000 environment too. Now, my boss wants me to look and manage...

Lynn and Mani,

Thank you so much for your reply.

I got it.

Thanks

Ganesh

Hello all,

I thank you for your suggestions

Finally, after struggling many days, I am able to deliver weekly sales report to my client.

Ganesh

Yes, I am trying to create a report based on fiscal year.

We have many tables such as Customer, Product, Order, OrderHistory etc in SQL Server 2005. When the customer...

Hi Lutz,

Thanks for your reply.

This is my first posting. I will follow your suggestion from next posting.

Again,

I thank you for your advice

G

My challenge is as follows

Business Calender year starts from 12/28/2007 and ends on 12/27/2008

A part of the table is:

BusinessDate(DateTime), QuantitySold(int)

12/28/2007, 25000

01/02/2008, 35000

01/09/2008, 45000

..............., ........

12/25/2008, 20000

Expected Output(for Reporting)

Period, QuantitySold

WK1(12/28/2007 -...

My challange is as follows

Business Calender year starts from 12/28/2007 and ends on 12/27/2008

A part of the table is:

BusinessDate(DateTime)QuantitySold(int)

12/28/2007 ...