Welcome aboard... first, here's one answer two your problem...

SELECT

(

SELECT SUM(ROOMREVENUE) AS 'ROOM REVENUE' FROM RPT_HOTEL_STATS WHERE PROPERTY = 'DELSOL'

AND STAT_DATE > '2007-12-31 00:00:00.000'

AND STAT_DATE <= DATEDIFF(day, 0, getdate())

)

/

(

select SUM(NUMROOMS) FROM...

How do you know that? What if it's updating the table with the same stuff that you have in it (NULLS?)...

Depends... do ya like porkchops? 🙂

Guess I should be pretty happy then... apparently some of my articles inspire people to ask questions. 🙂

Ok, no... you have to use NEWID() to populate the column. It is NOT a self populating column. Then, you would check for an error... if no error,...

Heh... no,... I'll happily continue to be "wrong" on this one... 😉

Dang, Adam... why don't you put your name on that bad boy! 😉

Hmmm.... when it comes to plain ol' delimited text files such as CSV files, I sometimes think people make things way too difficult. You can easily get a listing...

Remove the semi-colon... change the double quotes to single quotes around 'James'.

Heh... don't be warping my words, Paul... I said a new line never starts with a...

Haritha Kodali (3/4/2008)

---

Here is the view that the query is retrieving from. The earlier script is from DDL of the table that this view is using

CREATE view "MAGICSSHD"."Incident" ...

Heh... how well I know... been there and done that! The "R" in "CPR" stands for "REPLACE" and I frequently forget to do just that... 🙂

Please... take just a minute and at least add some carriage returns to your code...

How so? Commenting out lines using either style is exactly the same except...

Just another way of doing it... puts all the different "answers" to the case in groups...

UPDATE rm00101

SET userdef2 = (CASE

...