It sounds like you just need to join invoice and salesman then do a group on salesman.name and invoice.date and a sum on invoice and another sum on discount.

Give it...

I would read the following post, it will help you get the best response for your post.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

I would read the article below and repost:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

It sounds on the surface like a fairly simple grouping but it would be alot easier to tell if you had some sample...

Just remember that @@fetch_status contains data based on the last fetch run regardless of which cursor it is.

viacoboni (1/28/2008)

---

Gordon,

Based on the most popular "incorrect" answer, I'd say it was more than just you interpreting...

Actually I read an article that said that Microsoft will even provide support for using SQL with VMWare .. as long as the VMWare is their version of it :).

True. I've only ever used it on development and test boxes.

It was very nice though when using for test boxes because you could put up a new test box...

Also just to point it out, part of what I was trying to get at was that you could create a loop in your package to run through a list...

I've used virtual machines with SQL Server at my last 2 jobs and its worked fairly well. The only thing I can think of off the top of my...

Gordon Radley (1/28/2008)

---

I realze option 4 is correct if you use the DTS object model to execute the task, but I use package configurations all the time to change connection...

Actually I wouldn't use UNION ALL unless you know you aren't going to get duplicates (or you want to count duplicates)

Also It would probably be easier to do the following

SELECT...

Matt Miller (1/24/2008)

---

As with most things Jim - "it depends". A lot of thing can be written using either notation with no difference in execution (derived table vs CTE),...

Ok someone who is better at how indexes work tell me if this is correct.

If you change the code

isnull(old.avgcostprice,0) <> sub1.cost

to

NOT (old.avgcostprice = sub1.cost)

1) Are these equivalent? (after almost...

Antares686's solution looks good although I'm somewhat uncomfortable about pulling the where clauses out of the subqueries and into the main one. It certainly makes the solution alot easier...

I'm actually in the middle of a project where we are having to remove SYSADMIN rights from anything other than the DBA's. This is in order to meet audit...