Everything else runs exactly as normal for the user.

When one user runs our FedEx software on their pc, it initiates the trigger. When another user runs the FedEx software on their seperate pc, the trigger doesn't initiate.

I had an issue this morning...

...two users have the FedEx software. One can use the software and the trigger trips each and every time while the other user cannot get...

Haha....good point capn.hector

Lowell,

Your suggestion worked beautifully.

I appreciate the help you guys!

I don't think I'd need to test for a valid date as the FedEx software would take care of that itself.

I'll give your suggestion a try and let you know...

Lynn and Drew,

This is exactly what I was looking for. I appreciate it!

That's what I figured. I've used AD groups before and have had no issues.

WHat's wierd is that before the migration, I had this principle in place. Syspro must have clinged...

Snapshot replication is most definitely an option. I already need to have one database with this method since it used indexes instead of primary keys (not my choice :-)) so...

Just to clarify, we are running a SAN. I forgot to mention that

It's my first realm into complete virtualization with SAN storage. We're a small company that looks to be...

I appreciate all of the feedback guys.

I haven't begun to think of performance since we're a small user base (25-30 users). I figured if we're going to have a clean...

I didn't have a semicolon in front of the WITH statement.

Thanks for the help and prompt response!

Thanks for the tip. It didn't actually work, though.

I think since the query was looking for DocNo, CustomText01 and KEY1 to be joined together, I wasn't going to get the...

sdvoranchik,

Here's what the report looks like: http://i55.tinypic.com/124jw2u.png

The white area is hidden

I'm not sure how it worked, but now I have the totals working. I had to put them in a...

That's correct.

That's my dilemma....here's the result set when I add in CASE WHEN RowNumber = 1 THEN dd.Budget ELSE 0 END AS Budget I've included the DocNo and the RowNumber:

team_idspecialist_idTeam_NameRowNumberDocNoSubTotalBudget

4SCOTTVikings1AAAQ5790920225000.00

4SCOTTVikings1AAAQ571015167.2225000.00

4SCOTTVikings1AAAQ5675720256.7425000.00

4SCOTTVikings1AAAQ57509189025000.00

4SCOTTVikings2AAAQ5675700.00

4SCOTTVikings3AAAQ5675700.00

Since...

Maybe this might spark something....

I realized that I need to rethink my query

What I'm trying to do is make sure that the Budget result shows only once in each result...