Agreed. Investigating to see if any updates might have been pushed to the workstations.

What would have changed...

I'm trying to set up a deadlock event as outlined in BOL. The job gets created. When I run the supplied code, I do end up getting the deadlock. However,...

noeld (4/28/2009)

---

That is what I...

This makes sense.

During the interim, I've been looking at the procs that were causing the locking issues. I found a proc that runs one of three select statements with joins...

Check out BOL.

In a nutshell, "If an integer dividend is divided by an integer divisor, the result is an integer that has any fractional part of the result truncated."

So, to...

Please provide table structures (in the form of CREATE TABLE or Declare @table statements ) and sample data (in the form on INSERT statements) so that the volunteers here can...

zsysop (4/27/2009)

---

Thanks, but wouldn't this still update all of the columns for where any of the passed in params are not equal? I would like it to update only the...

It would sure be helpful to have table structures and some test data. Plus, you get some tested code back, instead of "this should work". Please see the link in...

Whoops. Thanks, I fixed it above.

Faye Fouladi (4/27/2009)

---

I get the message: Ambiguous column name 'SSN' when I execute the following SQl statement. what is wrong?

Declare @EMAILID uniqueidentifier

Declare @EmailTypeID int

Set @EmailTypeId...

davidandrews13 (4/27/2009)

---

i personally prefer to set it as null.easier on the eye when looking through the database and working out whether it has a valid date against it or not.

but...

Okay....

So, based on the data in your sample code, what is the logic to determine that the third commercial gets combined with the top, and the last commercial doesn't?

BOL is SQL Server Books OnLine.

This is the built-in help file for SQL Server. You can access it from...

You would get better help by posting in the appropriate forum. Since you have a SQL 2000 question, one of the SQL 2000...

Hi Zeev,

I'm looking at this issue also, and there is one aspect of it that I don't understand:

SELECT

1 AS commercial_break_id,

1 AS...