Thanks guys. These seem to be working just fine for me. That saves me a lot of trial and error. I really need to delve into CTEs...

This was hanging in our elevators this morning...

Downtime is downtime, scheduled or not. So IMHO it ought to be included.

If you don't want to use a trigger, use multiple DELETE statements within your SP. Delete the proper "related" records (based on key value) before deleting the main record(s).

Ben Moorhouse (10/15/2010)

---

With disk space getting cheaper and cheaper, I'm considering doing some basic disaster recovery for home.

Copying all music/photos etc onto a big disk and taking it to a...

I've taken advantage of the Home Use Program via my employer (US Air Force) a couple of times for Office (2007 and 2010) and Visio (2007 and 2010) but not...

I sure wish we spent more effort, especially after yesterday! I've on the development side, so it was "NMP" (not my problem) but our two-server SQL cluster, connected to...

I'm a bit surprised that an Aug 2009 article updated Oct 2010 wasn't expanded to include SQL 2008 and the user-defined table type option. Anyway, if you're on 2008...

Nothing fancy, but within our rather large .NET WinForms application, for some of the longer running processes we use a Stopwatch object and Debug.Print statements to show how long the...

I think the "lot of variations" piece is the...

I would love to have the same XML documentation capabilities in SQL Server as in Visual Studio. I fact, we're using the same notation even though you can't do...

Thanks guys. This is what I finally got to work (I'm using DATE datatypes)

NULLIF(MIN(ISNULL(MyDateField, '1/1/1900')), '1/1/1900')

I was getting "int" conversion errors using values other than '1/1/1900'. I actually...

I will second this. Making a "clone" of...

Everyone -- thanks a million for all the constructive inputs and feedback on my issue. Based on what everyone's ideas, here's what I came up with. Let me...

matt stockham (2/2/2010)

---

So what exactly are you trying to protect against? Is securing the application, SQL Server, drives, backups, network traffic (and don't forget the information could also reside...