We are finally migrating from 2000 to 2005 and in our jobs, we run one T-SQL
procedure as our only step.

exec ourprocedure 1, [JOBID]

and then look up our own custom info about that job when "ourprocedure"
runs. This now gets errors at run-time. We have 2005 SP2. I have been reading
about all this macro stuff and can't seem to find a working example of how to
pass the job ID to a procedure, which is expecting type uniqueidentifier.
What is the replacement syntax?

create a sp from query output
Combine records to calculate
Creative solution to relatively simply requirement
TOP by GROUP SQL 2000
JOIN Question...