I have 200 records in my test database that did not meet the criteria. I changed one record to meet the criteria and executed the script. It updated all records.

This updated all the records regardless of dates. What am I doing wrong?

/code

UPDATE CUST_LINE_DEL SET USER_ORDER_QTY = '9'

FROM CUST_LINE_DEL

JOIN CUST_ORDER_LINE ON CUST_LINE_DEL.CUST_ORDER_ID = CUST_ORDER_LINE.CUST_ORDER_ID

JOIN CUSTOMER_ORDER ON CUST_ORDER_LINE.CUST_ORDER_ID =...

Perfect! Thank you!

Yes. If I already have management studio open it will open fine. I can live with it but it did not happen on my XP or Vista machine. I also...

It will open fine if I open it via notepad or the management console. When I was running vista I was able to just double click the .sql and managment...

Thank you very much. It is greatly appreciated. Learn something new each day!

Thanks for the lesson. It is appreciated.

Is what you did. Thanks a million for the help. It is greatly appreciated.

That worked! How was it getting turned into an inner join?

Tried flip flopping the tables but it still does not return any records. I believe it is due to the fact that I am testing for a program id of...

Here is the script I built on your suggestion. It returns no records.

SELECT DISTINCT NAME

FROM APPLICATION_USER

LEFT JOIN USER_PGM_AUTHORITY ON APPLICATION_USER.NAME = USER_PGM_AUTHORITY.USER_ID

WHERE PERMISSION IS NULL AND PROGRAM_ID = 'VMINVENT'

If a user has permission to a program there is not a null value. There is no placeholder whatsoever. So, I can not use "permission is null" in a script....

How could we modify the code to include the growth of the log file?

I can do that. Thanks for the feedback.

Ok. The weekly maintenance job executed last night without a hitch. However, due to the rebuild on the indexes the log file grew 4G. The VLF's grew from 4 to...