The original took about 40 minutes.

The current is still running but running right now at an hour and 25 minutes.

I appreciate all the help 🙂

No problem.

Yes it is taking much longer than 40 seconds, but also the main table actually has over 50 columns. I am not sure if that would make a difference...

Ok sorry about that, I figured since it was easily importable that it was readily consumable...my apologies 😀

That is very cool and yes I use SQL Server 2005. Tomorrow when...

Ok I have uploaded a text file with the sample data which contains 426 records. I import this into my database as Order_Table and run the code below (I tested...

I don't use them often, but inevitably I find myself using them on a rare occasion 😀

I have a batch of code that updates a record sequence based on current...

Ah sweet thank mr or mrs 500 😀

I completely forgot about cross joins!

Wow I did not know all of that!

Ok I guess I need to make some modification to my maintenance plans!

Thank you all for your help!

Brilliant,

Works like a charm. I have a stored procedure already in place that pre loads all of this. I just simply added a drop/create synonym statement to accommodate the...

Thanks all.

I realized after posting the problem with the statement I executed.

Your tips helped me get the tempdb situated and the sql server instance is up and running!

Thank you everyone for your responses, I have managed to come up with a solution. I got the Fiscal calendar broken down by week from Finance and reviewed it. I...

Sorry here is a sample of the data this returns.

Calendar_DateYearStartFiscalWeekFiscalDayNum

2007-12-30 00:00:002007-12-29 00:00:0011

2007-12-31 00:00:002007-12-29 00:00:0012

2008-01-01 00:00:002007-12-29 00:00:0013

2008-01-02 00:00:002007-12-29 00:00:0014

2008-01-03 00:00:002007-12-29 00:00:0015

2008-01-04 00:00:002007-12-29 00:00:0026

2008-01-05 00:00:002007-12-29 00:00:0027

2008-01-06 00:00:002007-12-29 00:00:0028

2008-01-07 00:00:002007-12-29 00:00:0029

2008-01-08 00:00:002007-12-29...

Yes, I saw that to, I guess the part I get hung up on is I validated it earlier and it worked. I must have missed something or did something...

Works like a charm. You da man!

Alex, I really like that idea.

The only problem is, I have no idea how to create an ODBC connection or how to set up those privileges to it 🙂

Actually I found out the problem.

I had a column in the query that was a minor subquery. I changed this to a variable instead and now it works fine...