If the time difference is extreme, you can simply execute both procs in Management Studio and look at the execution time at the bottom of the screen.

I've had ones where...

GilaMonster (8/19/2009)

---

Comment...

There isn't a way I know of to do exactly that, but if you query the job schedule in msdb, you should be able to compare the times it was...

Are you just talking about generating test data, or do you mean you want it random and unique in the production database?

Mike in Michigan (8/19/2009)

---

I can just picture companies deliberately bringing in people for a few days at low wages and no benefits and doing it over and over and over...

Lynn Pettis (8/19/2009)

---

Can't find it now, but I read a post earlier this morning where the OP thought he couldn't use an ORDER BY in a query because he was...

It's an older process. Essentially, a retronym. Warm backups are more technically complicated at the engine and OS level, and thus arrived on the scene later.

I've...

Well done!

Dave Ballantyne (8/19/2009)

---

Just simply because after 10 years+ of solid TSQL work, i'd never needed to do that.

You learn something new...

Sounds like a pretty standard "contract-to-hire" situation to me. Lots of companies do that.

Source control for all scripts run against the database is also a good way to control and track what objects get created/modified/dropped.

I just read that article, and...

Okay, I'll bite. Why is that one surprising?

Lynn Pettis (8/18/2009)

---

RBarryYoung (8/18/2009)

---

Lynn Pettis (8/18/2009)

---

RBarryYoung (8/18/2009)

---

Grrr. Another person who seems to think that I should be doing their work for them. ... :angry: My back really hurts...

If you really want a UDF, try this:

CREATE FUNCTION HierarchyTop (

@OrgUnitID_in VARCHAR(12))

RETURNS VARCHAR(12)

AS

BEGIN

DECLARE @Top VARCHAR(12) ;

;

WITH ...