rbarryyoung Rocks!

Thank you Lord Vader!

I thought it was @@ for local variables?

Isn't order by new id() random?

There is something not quite right with the TOP syntax. Any idea?

Msg 156, Level 15, State 1, Procedure sp_GetInstantWinCodePlusUpdate, Line 16

Incorrect syntax near the keyword 'top'.

Msg 319, Level 15,...

Thanks!

OK, Thanks!

Just one more.. Can this be done? I have to count each for 20 different REFID's

CREATE PROCEDURE [dbo].[sp_CountByRefID]

@CountA as integer output,

@CountB as integer output,

@CountC as integer output,

@CountD...

What if they were different tables?

CREATE PROCEDURE [dbo].[sp_CountAll]

@CountHigh as integer output,

@CountExams as integer output,

@CountStudents as integer output

As

SELECT @CountHigh = count( *) from exams where score between 36 and 52

SELECT...

Thanks! you rock!

That works perfectly!