WITH Numbers AS
(

SELECT  CAST(ROW_NUMBER() OVER(ORDER BY(SELECT NULL)) AS decimal(8,2)) AS N  
FROM
(VALUES(1),(1),(1),(1),(1),(1),(1),(1),(1),(1))t(N)--10 Rows
CROSS JOIN (VALUES(1),(1),(1),(1),(1),(1),(1),(1),(1),(1))t1(N) --100 Rows
CROSS JOIN (VALUES(1),(1),(1),(1),(1),(1),(1),(1),(1),(1))t2(N) --1000 Rows
/**********Add these lines in if...

You're welcome Paul.

That query will produce up to 1000 rows if needs be just by changing the '<=500' to what you want.

Have you copied all of the query? It should be returning 500 rows.  The last line is 'WHERE N<= 500'.

I'm not sure what...

WITH Numbers  AS
(
SELECT  CAST(ROW_NUMBER() OVER(ORDER BY(SELECT NULL)) AS decimal(8,2)) AS N
FROM
(VALUES(1),(1),(1),(1),(1),(1),(1),(1),(1),(1))t(N)
CROSS JOIN (VALUES(1),(1),(1),(1),(1),(1),(1),(1),(1),(1))t1(N)
CROSS JOIN (VALUES(1),(1),(1),(1),(1),(1),(1),(1),(1),(1))t2(N)
)
SELECT 
N-0.99 AS Lower
,NAS Upper

FROM

Numbers
WHERE N<= 500

Does that work?

I've done a bit of research and experimenting on this and I think I've worked out what's happening.  I've got a theory as to why but I shouldn't take as...

What's worse: a problem which starts spontaneously and for which nobody is able to track down the cause, or, the same problem spontaneously stopping over the weekend and nobody having...

There's a joke that's been going around about Trump since day one of his time in office.  I have no great love for the man (nor any of politicians currently...

• This reply was modified 5 years, 10 months ago by Neil Burton.

Heh... let the silliness continue.  I just got an email saying...

KILL 99.9% OF BACTERIA & HARMFUL MICROBES

FORMS A PROTECTIVE SHIELD THAT DELAYS GROWTH OF HARMFUL MICROBES ON INTERIOR SURFACES

Reg...

I prefer single-character-per-word aliases myself. But that brings up the subject of collisions. Some queries have insane joined table counts and when you have [ATM] and [Audit] in the...

I agree, but I personally don't like multi character aliases.  For me, they clutter the code and make it less readable.  I like to name them a,b,c,d... and that...

I think it's extremely unlikely it...

half a pound of mashed potatoes???I would be asleep for a full day. I opt for salad. i.m a healthy 12.5 stone (I dropped to 9 stone at one...

low carb diet? - I eat bread or fries once a week. It makes me sleepy.

I found that a lot of veg and chicken is a good...

low carb diet? - I eat bread or fries once a week. It makes me sleepy.

I found that a lot of veg and chicken is a good way to...