5GoldenRings

Chris Quinn-821458 (12/21/2009)

Much closer to home, and a much...

Now hippos will be dancing in my head. Oh no, not sugar plum fairies, nor the Nutcracker sweet - it must be a hippo. In a tutu no-less.

My apologies for that. When I scrolled down my browser jumped past the table.

Even when not working, you're still working (around the house, or at the house in your office). And if you're truly not working, then there is SSC - which...

Nice one. Thanks for jogging the memory. I use sql so rarely to query the file-system that I forgot about this one.

It would work well with xp_getfiledetails.

Sorry, are you asking a question for help on a specific topic or just looking for help in general?

Jack is accurate in his statement.

and the udf's

udf_GenBatchID

udf_GetApplicationID

And, has the job ever worked?

Anything change that would have caused it to start failing?

How about the sql for the job that runs this monster?

I'll still be working too, minus a few days off around each of the holidays.

Please post the "master" proc.

I was initially leaving out the 2/3 comparison due to this looking like a homework assignment. I was hoping to leave out just enough he would finish it up.

But...

BTW...Thanks Jack and Andrew for pointing it out.

When tested against the data provided I got distinct records on my end. I scaled the testing up and started seeing what you guys saw.

Here is the revised:

;

With custvisits...