What if you've got 2 records with the same Client_id & Code_id but with different Isactive_flag?

Should Server consider...

Make your "... some more tsql ..." a SP in myTESTdb and run dynamic SQL:

EXEC('USE myTESTdb

I'm talking not about POWER from your query.

I'm talking about 12 rows involved in 5 CROSS JOINs.

SQL Server will create temp table to hold the result of these joins, and...

Does "today" go back to prvious month with "yesterday"?

And performance must be terrible.

5 cross joins - I'm not sure it's something I would ever accept. I stopped thinking about solution with Numbers table when I realised it gonna...

Peter, are you insane?

For many years here nobody saw me copying anyone's algorythm.

Are you sure that one is good enough to start?

I even...

Actually I don't see why 9+5 is wrong.

In difference between denominations less than 2 times there are too many options.

You need to work out more complex algorythm.

I would rather have it in function.

Just more useful.

They say "think before you do".

Otherwise you'll always end up in enormous "amount of work and code rewrite involved "

> Are you saying I should have a 3rd table to store the payment types for an invoice instead of fields in the sales table?

Yes, exactly.

And ths is actually relational...

Didn't think much, but the simplest approach seems to be this:

CREATE TABLE dbo.BankNotes (

 ID smallint IDENTITY(1,1) NOT NULL,

 FaceValue smallmoney NOT NULL,

 Available smallint NOT NULL -- Number of available...

SELECT Text, SUM(answered ) as answered , SUM(correct) as correct, SUM(correct)*100

/SUM(answered ) as Percent

FROM QuestionHistory

INNER JOIN Questions ON assessment_question_id = Questions.ID

GROUP BY Text

Yes, it does the job.

But only if your database does not exceed several thousands of records.

As soon as it will become more than Excel spreadsheet you'll face performance issues.

Did you ever pay for something by cash and by credit card and by check?

Can you describe the circumstances?

It's very interesting to hear about such experience.

Use OPENROWSET