For once, I'm glad I'm wrong too!

Correct me if I'm wrong...

If you delete a record using the query tool in Enterprise Manager (NOT Query Analyzer) I believe its not logged.  Thats why its so dangerous to mess with data...

I was being sarcastic... GreatPlains is a disaster to understand!

I think all tables and there attributes should be singular, not plural.

Customers.FirstNames???? NO

Customer.FirstName

Be careful with the MODEL database.  Other developers/DBA might be expecting and needing these objects when a database is created.  Better to be sure that these objects are indeed eronious.

Do y0u have a VPN connection from home to work?

Create an ODBC Connection

In Access go to File,Get external data, select the ODBC option, select your view

This way your Access data is in sync with the view.  This is a...

Anyone ever look inside MS GreatPlains eEnterprise?  How does MS name its tables?

I just got off the phone with MS...

License your test/devlopment area with Developer licenses.

License production with Production Licenses.  Active/Active needs a license for each Active node.  Active/Passive needs only the Active to...

What about creating views (as your groups) and querying (UNION) the views?

Why not use a join statement.  I avoid large IN clauses, It seems inefficent to have them when you can make it simpler with a Join.

You can have a look at "Expanding Hierarchies" in BOL.  It can give you a few ides on how you might use hierarchies.  This is a common question and theres lots written about...

Ryan,

The above SQL gives the grand total however, I need to show the total for each employee as well (grouped by employee) Also, to be able to pass a date range like 1/1/2004...

Ryan,

Great code!  I like the approach (full cost - temp) as it can be applied to both sides, ie calculate regular or temp.  I'm enjoying pulling apart the SQL from the various...

AKM,

It's not necesary to pro rate, if the move happends in the middle of a period then the action is effective the following period.  This is standar HR/Payroll pratice.  Same...

Just to let the readers know, this is not just an exercise for me.  I need to be able to answer these kinds of questions.  I can't alter the database...