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)

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)

Declare @EMAILID uniqueidentifier

Declare @EmailTypeID int

Set @EmailTypeId...

davidandrews13 (4/27/2009)

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...

Bridget Elise Nelson (4/27/2009)

1 - used to represent either a missing value or a value...

Bob Hovious (3/11/2009)

No M R not.

S M R. Look at M webbed feet.

L I B !! M R Ducks.

I haven't thought about that since...