Your idea looks pretty slick. Let me work with db and test it. However, it may be tomorrow before I can.

Thanks

The only way the vendor will send us our data is a full back up in the morning with logs every hour. I have resigned myself to restoring the full...

We need this database restored locally so we can report from it. We will get a fullback in the morning at 4:00am. We will get a transaction log from the...

It was the only way I knew how to put the database back so users could access it. Without running RESTORE DATABASE [Cadence] WITH RECOVERY. The db status says restoring...

I tried SET NUMERIC_ROUNDABORT,but I still got the arithmetic error. We finally determined that we were pushing [numeric](7, 2) into a [numeric](6, 2). Once we corrected the column...

SET NUMERIC_ROUNDABORT looks like a plan. We will try it tonight.

Thanks

The actual data is coming from an ODBC link using and OPENROWSET. I will try an order By clause the next time we run it later this week.

We have narrowed...

Working...

Thanks

As my salesman father told me, "Nothing happens in business until some body sells something."

That is so much more elegant that the one I wrote, and works like a champ

Thanks for getting back so quickly. I will try to adhere to the custom in...