If you just need to know the name of the jobs, use the query below (replace name_of_your_database):

SELECT js.job_id,

name

FROM msdb.dbo.sysjobsteps js

...

demonfox (10/4/2012)

---

Lokesh Vij (10/3/2012)

---

One more way to achieve the result:

SELECT c.Cnum,c.D1,c.D2,c.D3,c.D4

FROM #cnums c JOIN #dnums d

ON c.D1 = d.D OR c.D2 = d.D OR...

One more way to achieve the result:

SELECT c.Cnum,c.D1,c.D2,c.D3,c.D4

FROM #cnums c JOIN #dnums d

ON c.D1 = d.D OR c.D2 = d.D OR c.D4 = d.D

GROUP...

Good question indeed...but unfortunately got it wrong 🙁

Please check my previous post, Praveena has the same question..

Praveena-487125 (10/3/2012)

---

I did not get default of 30 (which you mentioned in the answer in case of Cast/Convert) in what ever way I try... Can you please explain more on...

Interesting question Dwain..Kept me thinking for a while 🙂

Thanks for this easy point Ron in the middle of the week 🙂

Very nice question Ron. Thanks for posting 🙂

Thanks Amit! a real easy and back to basic qotd!

Thanks Tom!

I have updated the blog now 🙂

Hugo Kornelis (9/25/2012)

---

A good question; thanks!

However, I did find myself staring at the wording for a bit before answering - and hoping that my interpretation was the correct one. The...

A little attempt from me to make "DDL inside transactions" more informative. Hope you all like it 🙂

http://sqlpathy.wordpress.com/2012/09/25/myth-truncate-cannot-rollback/

Nice question Jason!

CDC is a good option to work with in such scenario. Check the below link for details on what CDC is and how this can be implemented.

http://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-%28cdc%29-in-sql-server-2008/