As many as you want.

I know there might be a max stored procedure byte count (or batch size), but apart from that, as many as you want.

How many do...

I'd experiment with the counts. I've had systems run better with 1000 than 10,000, but it's varied. Test a little, maybe for few batches and get timings.

How are you compiling as a script? Perhaps there's something in the script that gets left out. For example, a GO might terminate a batch, and let the rest of...

Please tell me it isn't a friend at a government agency or other place where security should be taken a bit more seriously.

I think serious-ness departed this thread long ago.

A long, long time ago, in a post far, far away....

Just venting, just venting, my friends. A good way to relieve some stress.

A broken URL has no answers today 🙁

However here's one I got in email:

For the record, the main reason to remove SPs that are surplus to requirements is to ensure...

Cynical indeed, though advanced education in CS doesn't necessarily mean that you know how to do anything in production.

However, I agree that this person, while possibly having trouble understanding, is...

How are you viewing this? Some apps might limit it there. TEXT should bring back the full value unless you are CASTing it somehow.

I'm guessing you have some data that is throwing this off.

Do the subselect's work fine by themselves?

I'd think you'd be able to CASE the SUM and not need the...

where string like column?

Isn't it WHERE MyCol like '%searchstring%'

I hate these types of searches. I think it's a lazy developer. It might take you more time to build a few...

Crazy as a Jedi?

Google might do that. We actually have some development resources coming available in a couple weeks and this is one of the priorities to fix the search so it works...

There shouldn't be a lot of duplication. There are some older ones from before we had a unique check on the column.

Who's duplicate?

I'm sure he knows how to cut and paste, but might not use that term. What if he's primarily a *nix guy? Might not be used to the term. I'm...