What are the bounds of the missing dates? Gotta know what you require as a Non-missing date before we can find missing dates.

Also, storing dates as NVarchar is a...

Heh... bad day getting worse ol' friend? 😛

Are you using a loop of any kind in the data load process?

We're still waiting for you to post something that can actually be troubleshot...

Another way is to import the spreadsheet into a table as is... then, do something like this to normalize it...

SELECT Vendor,Name1 AS Attendee

FROM sometable

UNION...

Yes... same solution... just export the data as tab delimited and do the split on the tab.

Heh... I don't concur with any of what you're trying to...

I agree... it'll likely require a change to the sproc or a bit of very clever SQL Injection and then only if the sproc is vulnerable.

I think you guys might be missing something... Yep, I'm sure that you're preaching to the choir when it comes to running jobs at night, etc...

The real problem the OP...

You got that from a "SELECT GETDATE()" on both boxes??? If not, what are you using to get this date and what happens if you try "SELECT GETDATE()" on...

Sure, it could be... the real key is to write code that doesn't need it to prevent blocking, though. Generally speaking, code that uses WITH (NOLOCK) everywhere is to...

kappa (6/5/2008)

---

Hi, thanks for getting involved and sorry about the attitude, not enough sleep, I guess 🙂

OK, here we go. I have done the search, and then some... Among loads...

Answer: CROSSTAB or PIVOT!

... but, like Jeffrey stated, you're gonna need another column of information from somewhere that maintains the sequencing of the rows. Of course, that...

That kind of narrows it down to something on the server... are they loading in a different recovery mode than you are? Do you have different server or db...

It's not homework, I swear (does it make any difference).

Yes, it does make a difference... I'm more prone to help someone (anyone, not just students) that shows that they've...