Be aware that when you change a diagram and save it, it actually updates your database to match... diagrams are really a form of somewhat anorexic data models.

Another possibility would be to use a "Linked Server" which would also hide the login and password from prying eyes.

That's a good start... got any data we can play with and, like I asked, are the tests stored in the same table as the quizzes?  If so, what marks...

Where is the Test info stored?  In the QuizLog?

Sidebar... does you table actually have columns with spaces in the names ?

I think it...

It sounds like the classic "make change" problem that used to be taught in many programming classes... I'm on my way to work right now but I think a function...

Perfect case of too many cooks spoiling the broth Thanks for the feed back on what you found, Ville... definitely something to keep...

No.  Serqiy is correct... the table design is wrong... if you take multiple payments for a given invoice, you should have multiple rows.

Stephen,

If you want separate totals for each payment type, then this would do...

 SELECT SUM(Cash)    AS TotalCash,

        SUM(Cheque)  AS TotalCheque,

        SUM(CC)      AS TotalCC,

        SUM(Account) AS TotalAccount

        SUM(Total)   AS GrandTotal

       ...

Actually, none of them is absolutely right.

If you have one that is, would you mind sharing it...

Thanks for the feedback, Mark...  this one was a lot of fun!

Serqiy... I'd still like to know the "magic" behind your 5 second report, if you get a chance.

Should the totals be by day for the range or are you just looking for a grand total for the range?

Thanks for the benchmark, Serqiy... the computed columns help a lot especially when you make them both deterministic so they can be indexed... got it down to 7 seconds on 4...

Mark,

I don't know if I can get it to be a fast as Serqiy says he can, but I did get it down to 8 seconds...

First, add this index...

October 14, 2006 at 12:27 am