RE: Subroutines in TSQL – SQLServerCentral

SSC Guru

Points: 1003863

August 14, 2017 at 5:45 am

#1955125

dmeissner - Monday, August 14, 2017 1:16 AM
Calm down now Jeff. Don't be triggered yourself. I was only joking will the "Comprende" comment and it wasn't directed at you.
Time and time again, I run across posts where someone asks a specific question and everyone has to question the person's motives rather than answering the question. This was no exception. If there were other ways to perform the same feat, there wasn't much dialog about it.
I did run across the thread searching for the same thing for an old mssql 2000 box. I ultimately created a single procedure on one db that could be referenced from another, passing the requesting db name to the procedure so it then could perform the task (like checking if an object exists) against the requesting db. Sort of cumbersome, but much better than installing a solution in each db and for sql2000, a pretty decent solution.
Anyway, isn't it great reviving a thread that's 7 years old? Must be a world record.
Take care...Dave

Heh... calm down? Ironically, I was going to suggest that you do the same. Your first post on the site and you came out with words like "lame" and suggested that many of the responses came from weak minds.

The reason people here ask questions rather than providing immediate answers is because the OP frequently has no clue of what they're asking and so folks try to get to the root problem with the OP rather than providing an immediate answer which is frequently wrong for either the actual or future usage and teaches the OP little either way.

And, no... resurrecting a 7 year old thread isn't close to a record although resurrecting one in such a thoughtless fashion may be. And speaking of triggers, consider the fact that you did exactly what you accused others of doing... you have an answer and still you didn't post it.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)