Oh - entirely different problem. I see where we're heading now....

But I guess that's so that you can't backdoor your way into having all of the advantages of DBPro...

Have you tried using Bulk Insert to do this instead? Specifying codepage='raw' seemed to bring in all characters you had: otherwise some seem to go to unprintable characters.

I did...

hmm - I could swear I saw something under deploy options to drop objects from the server that don't exist in the database project. I will have to go...

It certainly is - but in both cases - it just goes to show how unwieldy it would get to calculate every single holiday based on some crazy set of...

If you import it in to a temp denormalized, then your renormalization process is simply a series of UNION statements

Something like

Insert myfinalTable (account_id, product_id, support)

select account_id, product1, support1 from #temp

UNION...

While I fully agree with Joe that it becomes unwieldy without the dates table - there IS an algorithm that calculates Easter....Thought you might be interested.

http://users.sa.chariot.net.au/~gmarts/eastalg.htm

Even in a report, CrossTab represents a summarization or aggregation operation, so you would STILL have to fix the duplication issue (i.e. if all children were marked as relcode=1, only...

Radovan Jablonovsky (2/6/2008)

---

Andy is right. We have setup MSSQL2000 (4 CPU) with parallel query execution and your example/code does not work. I tried it 3 times but always with messy...

Actually my first assumption when hit with that many problems is that a. I am sitting across from someone not qualified, b. they're reading from a script and don't have...

Question is - could you run that update from within Access itself?

OLE being what it is - there are some provider specific errors that don't get past back correctly. ...

it works fine in either case...it just reorders your rows from how you inserted them...

No - reallly:)

I'm not sure what you're seeing, but here's what I get:

new customer ...

Assuming you had a way to order the table to set up the sequential number, yes - but that method is worse than the temp table method. Meaning -...

looks to me that it's further down on the list? as in - row # 4 of your SELECT statement?

gordon_griffin (2/7/2008)

---

wow, there's some real attitude here. I'm not talking about being an @rse or trying to screw people up, just challenging someone's answer, or seeing if they will...

Jim Russell (2/7/2008)

---

"Whilst you may know how they join, an end-user making a simple report has a much easier time if the joins are already defined for them."

Tell me more...