I'm not familiar with CONTEXT_INFO. I'll try it out. Thanks

Florian Reischl (3/28/2009)

---

Try to handle it with CONTEXT_INFO and a transaction.

Within your DELETE trigger:

-- ...

BEGIN TRANSACTION

SET CONTEXT_INFO 0x01

-- do...

The table is a status table with a begin and end date. Only one status can be the current status and is identified by a null in the end...

Thanks for the reply. I'll try that.

John

That's great. Thank you very much. I always seem to have trouble getting my head around recursive queries.

John

My favorite quote regrading any job:

"Your hard skills will get you hired, but your lack of soft skills will get you fired." I think that good soft skills will...

It's not  that it doesn't apply.  For instance, if I enter a customer record, but don't know the birthdate, I leave it blank.  It has to be null or there...

That might be OK depending on the field.  It wouldn't work for birthdays (in our application - at least for a whiile) for instance.

One approach is to create a date table (or table variable) and do a join against it.  I have used a table valued function to create a table variable with the...

Thanks.   I'll give it a try.

Great idea!  I had originally created a function that, given a date range, would create a table variable with the begin and end dates of every month in the range. ...

Thanks for the reply.  In your example though, the second insert statement starts on 2/16/2006 which means that month 2, year 2006 should have a count of 1.  That's why...

We look for names of people (last first).  We never use the leading %, only the trailing %.  So an index is very useful.  I just wonder if using a varchar instead...

Good article.  I have a question about the comment not to index free form text fields, though.  Does this mean not to index a name field at all (a concept...

Check out sqldts.com

Thanks for the reply. I'll try it.

John

quote:

---

It would help to know the table structure to see if anything else can a...