Thanks for the help.

Input

DECLARE @FREQ INT

SET @FREQ = 5

SELECT DATEADD(MM, @FREQ* NUMBER, '20120501') AS MYDATE, NUMBER

FROM UTILITY..NUMBERS

WHERE DATEADD(MM, @FREQ*NUMBER, '20120501') < '20200501'

Ouput

MYDATENUMBER

2012-05-01 00:00:00.0000

2012-10-01 00:00:00.0001

2013-03-01 00:00:00.0002

2013-08-01 00:00:00.0003

2014-01-01 00:00:00.0004

2014-06-01 00:00:00.0005

2014-11-01 00:00:00.0006

2015-04-01...

Its an overflow message in trying to create the date in the where clause for the last date..but it makes no sense to me because if I increase the date...

09697

(1 row(s) affected)

as you would expect I think.

Rolf

I am really using 2000, have no reason to upgrade and I don't have time to rewrite all my DTS tasks either.

DECLARE @FREQ INT

SET @FREQ = 5

SELECT DATEADD(MM, @FREQ* NUMBER,...

Yes I've been scratching my head looking for a simple one liner dateadd statement that will get it but I my feeble brain cant work it out so I have...

Thank you, that sort of does the trick..you can control the row output so you might have three rows where they could fit on two but thats front end stuff...

Hi there,

Please find below an edited version with a code snippet that will bring up the results I am getting now.

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#mytable','U')...

ermm...is it just me or can anyone else 'see' the article..? I only get the second code block but then no more text..?

Hi there,

Thats what I have done in the past created derived tables but I was wondering if there were any alternatives, better options, opinions about the performance hit of derived...

I have already tried the registry rebuild, made no change.

I have tried reinstalling....there is no repair option as such, just the option to add or remove sections. I could try removing all the client tools and reinstalling them.

I'll try...

update

set @rank = rankorder = @rank + 1

that will certainly reset all the columns to a sequential run but it will also reset their order! as it will just...

OK in 2000 I am using three tables, one containing all materialIDs (MATERIALS), one with BOMIDs and assocaited materialIDs (BOM). The final table represents the materials available (AVAILABLEMATS), in the...

OK thanks for the replies..will look into the CTE on 2005..not sure if the development server will have 2005 so I need a 2000 solution as well..from initial investigation it...

Thanks for the massive amounts of help!

Its all sorted now...all my problems were due to clashes with the instances...Because both 2005 and 2000 were running at the same time I...