I think you've got what I mean and that kind of query would be my first choice.  But here's the rub, there will be rows in the main table like...

Ok, own up, which one of us was it?

So we have this third party shipping system that is...well...user hostile at best. To add insult to injury for the users the system has been suffering increased performance...

• This reply was modified 4 years, 8 months ago by Neil Burton.

You can use sp_update_jobstep.  Are you sure you can't do it in SSMS?  If you open the properties tab of the step in question you can edit the Step...

• This reply was modified 4 years, 9 months ago by Neil Burton.
• This reply was modified 4 years, 9 months ago by Neil Burton.

My boss manually deleted the backlog in chunks on Friday and things appear to have been fine over the weekend.  I'll know a bit more definitely when the...

Found out the other week, we're likely to be working from home to the end of June 2021...

So I splurged and bought myself a new, more adjustable desk chair...

Well, that took a tangent...

Thanks for your input gents.  I'd done some poking about and I'd couldn't find what was calling the task anywhere.  I did find the proc that...

Typical WYPIWYG, what you pay is what you get.

😎

The number of rows limitation just tells us that someone is using an old version of...

Well this is awkward.

• This reply was modified 4 years, 11 months ago by Neil Burton.

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...