Sql Queries, Sql Tips, Sql Server, Programming Tips, Sql.
TRUNC(DATE_VAR1)) >= CASE WHEN SEQ_VAR IN (1,2,3) THEN 0 WHEN SEQ_VAR IN (4,5,6) THEN 1 ELSE 2 END ORDER BY ID_VAR, SEQ_VAR Tip 4: Use SET NOCOUNT ON When performing INSERT, SELECT, DELETE, and UPDATE operations, use SET NOCOUNT ON. SQL always returns the affected number of rows for such