Grant Fritchey (12/18/2009)

---

I'm not sure if it's a skill, although it must partly be.

One old story. I wrote an app for managing user access to a database and turned it...

Placement in the WHERE or ON clause could be important, also, when dealing with OUTER joins. It could make the difference between getting the data you need or not.

Since today is Friday (12/18) are we talking about the previous Friday and two weeks back (12/11)? Would this date also be the same when run on Saturday (run...

Anticipation!

Just two more days and my daughter is home for Christmas! :w00t:

Sounds simple but based on what you have given, not exactly sure what the query would look like. Please read the first article I reference below in my signature...

x64 SQL Server 2008??

When writing queries I put the join criteria in the FROM clause and the query filter criteria in the WHERE clause. IMHO, this makes the queries easier to understand...

Here is some code that may help you figure out one possible solution. The idea behind this would eliminate the the triggers used to update the table where the...

I'm not an Access programmer. How does Access retrieve the value from the table? Does it simple select the value or does it use a store procedure to...

It depends. How current do you want the data for testing and/or development. If it doesn't matter, then all you need is the full backup.

We can make all the assumations in the world and still be wrong. I am just asking for clarification of the rules as they aren't clear IMHO.

Okay, based on the fact that you are assigning permissions to the column level the value returned by the call to has_perms_by_name at the table level is correct. The...

James McCall (12/17/2009)

---

If I grant UPDATE on some table columns to another user or group but do not explicitly grant UPDATE on the table then it is possible to update...

UltraEdit. Haven't had a problem with it on any size file I've used it on. Very good, solid product.

Regarding the expected results:

EmpName Reg TourStart TourEnd FOrdDate FOrdType FtOrdAmt LOrdDate LOrdType LOrdAmt

John West 8/15/09 - 8/17 B 57K 9/17 A 78K

Mike South 9/1/09 11/15/09 9/4 A 32K 10/31...