In SS2k you must use in T-SQL script this version:

INSERT @i VALUES ('Steve')

INSERT @i VALUES ('Stephan')

INSERT @i VALUES ('Stephanie')

INSERT @i VALUES ('Sterling')

INSERT @i VALUES ('Steppenwolf')

Then are 4 rows in...

In this case have parentheses no role. Of principle is DISTINCT behavior of UNION clause.

Hi experts,

--Pleas, compare this two scripts:

---------------------------------

DECLARE @FREQ INT

DECLARE @NUMBER INT

SET @FREQ = 5

SET @NUMBER =10000

BEGIN

IF DATEADD(MM, @FREQ*@NUMBER, '20120501') > '20200501'

SELECT 'O.K.'

ELSE

SELECT 'DateTimeERROR'

END

----------------------------------------------------------------

DECLARE @FREQ INT

DECLARE @NUMBER INT

SET @FREQ = 5

SET...

You can use this approach:

Better explanation is in this link: http://msdn2.microsoft.com/en-us/library/ms190276.aspx

Jiri Vobr