I don't see any data type definitions. Should we just assume that all columns are varchars?

"It's not getting what you want, .. it's wanting what you've got."

Like this:

DECLARE @PMH as varchar(500)

SELECT @PMH=''

SELECT @PMH=p.TextBody

FROM dbo.PartyText p

WHERE p.DataPointID=186

And p.PartyID=19396

print @PMH

Hey, I just realized... This is the post that you broke 10,000 on! :w00t:

Woo, hooo! Makes...

How's that?

The canonical way to do this is to OR the values to gether and then test the Negative bit (or just test the final result for negative). Unfortunately, there...

What are you hoping to get from us?

Wierd.

Try to rename it?

Oops, you are...

Peso (7/11/2008)

---

Beware of rounding!

If you run the suggested code PM, you will not get today's beginning.

Declare @Today smalldatetime

-- beginning of today:

Select @Today = Cast(Cast(getdate() as int) as smalldatetime)...

You need to use TOP with an ORDER BY clause to give it what BOL calls "a meaningful chronology":

update TOP (1) s

set [past effective date 1] = s.effective_date

...

I think that this works too:

Select Count(NullIf(values,-1))-Count(values) From table

Probably not any faster than Gus's, but I guess it'll help those out aching fingers 🙂

Of course, now that I look at...

Loner (7/11/2008)

---

There are two rooms separating by a wall, one room has three lamps, the one one has three switches, can you tell how to find out which switch is...

I agree with Lynn.

Using commas is the older, "SQL-89" syntax and it is deprecated now.

Using "JOIN" is the newer "SQL-92" syntax and it IMHO much preferred because:

1) It is...

I think that you might have the wrong idea, Mike. Like Lynn, I started to look at this a couple of days ago, but after an hour or so...