Stored procedures can definitely return a value, either as a select resultset, or as an output parameter.

yes, i believe he uses bigint as his pk's.  do you think that has something to do with this?

No, that's just the behavior. An int column would have jumped by...

• This reply was modified 3 weeks, 5 days ago by ratbak.

Since the jump was 10000, the datatype is presumably bigint (int cache size is 1000).

https://ola.hallengren.com/sql-server-backup.html is a great, widely used solution, including cleanup of old files, driven by stored procedures that can be incorporated into jobs.

What is being done to combat the tidal wave of spam inundating SSC & rendering the forums unuseable?

WHERE 
    (@Type = 'AB' AND PlanDescription IN ('DEF','GHI') OR 
     @Type = 'CD' AND  PlanDescription IN ('UVW','XYZ')
    )

Are you talking about SQL Server Management Studio? What version? Are you running it locally, or on the server?

What are the stats for disk & network throughput & latency when...

Could it be that the SQL Server being Standard edition caps the performance, thus it could be solved by upgrading to Enterprise?

Yes: Standard has a memory limit of 128GB &...

You don't hire good managers, you train good managers.

You don't hire good employees, you train good employees.

I agree, but unfortunately many companies subscribe to management theory that teaches exactly the...

How many rows in dbo.ELIGIBILITY? What is definition of dbo.ELIGIBILITY (including id_ELIGIBILITY_PREMIUM_GR...)?

What's actually in the where clause? Any user-defined functions? functions wrapping columns (ISNULL, COALESCE, CAST/CONVERT FORMAT, etc.)? Views (especially...

😀

Maybe

(target.tblAwardID =  source.tblAwardID or  source.tblAwardID is null)

Look at this line:

and C.nSerialNo = C.nSerialNo

Did you mean for C.nSerialNo to join to a different table?

If so, fix it.

If not, remove it -- It's of no...

Phone call? No.

But for mobile phone carriers with an email gateway you can send SMS via email.