Jeff Moden (4/11/2009)

---

Oh... be careful folks... this wonderful and great interplay of thoughts and ideas to come up with some absolutely outstanding code all share the same common fault... they...

The answer is wrong - you click No - and get told you are wrong.then the explanation goes on to agree that you cannot use RAND...@?

Florian Reischl (4/11/2009)

---

Always welcome! That's the reason for sample data! 🙂

This is an output solution, it does not affect the table.

Also, it is kind...

Borrowing a bit from Flo... another set based solution without CTE ....

DECLARE @t TABLE (Name VARCHAR(30), Reading INT, Result INT)

INSERT INTO @t

...

jsanborn (4/10/2009)

---

Maybe this example will be clearer. ...

I've included a script to build a table for the rats. ...

So again (and I'm sure someone will say I'm completely changing the...

Jeffrey Williams (4/9/2009)

Modify the where clause like this:

WHERE 1 = CASE

WHEN @Report...

My advice is don't try and do it all in the where clause.

Use a table for the report classes....

CREATE TABLE ReportKeys(

report_key CHAR(10),

report_id CHAR(10)

)

GO

INSERT ReportKeys(report_key,report_id)

SELECT 'TTT','TTT' UNION ALL

SELECT '370','National' UNION...