Prev: Am I supposed to see the OUTPUT parameter's value in SQL Mgmt Stud
Next: Whoever posted this
From: Stefan Hoffmann on 3 Mar 2010 10:53
hi Plamen,

On 03.03.2010 16:21, Plamen Ratchev wrote:
> SELECT staff_id
> FROM test
> GROUP BY staff_id
> HAVING MAX(year) - MIN(year) <> COUNT(DISTINCT year) - 1;
Ah, easier to understand than the Gauss approach.


mfG
--> stefan <--
First  |  Prev  | 
Pages: 1 2 3 4
Prev: Am I supposed to see the OUTPUT parameter's value in SQL Mgmt Stud
Next: Whoever posted this