...

Read and follow the steps in the following article, you will get better answers to your questions:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

It has cut down some but still a pain.

b.grove (5/12/2016)

---

I would love to use a Max() function but I have 6 statements I need to use the Max() function on. When I use it on just one...

Thought I'd reformat your code some and replace the 3-part naming convention you used with 2-part naming using table aliases. This is important as Microsoft has deprecated 3-part and...

We can call him pp. :w00t:

And Post Padder is still at it.

Wow, why not do something useful instead of just posting "Thanks for the script."

Attached is a modified version of the script in the script library.

Caz68 (5/12/2016)

---

I dont know what IFCode is sorry.

I am using SQL server 2008 so assume that is MS SQL and not MYSQL as per my title apologies as I said...

Would help if you posted your code using the IFCode Shortcuts and formatted your code.

Original code reformatted:

UPDATE dbo_lt_pOperator, dbo_lt_LookupPreSetShifts SET

dbo_lt_pOperator.ShiftID = "2"

WHERE

(((dbo_lt_pOperator.amShiftStart)...

Just padding his post count, like that really means anything.

Tava (5/11/2016)

---

ZZartin (5/11/2016)

---

There's nothing inherently wrong with shrinking the database, it's not that it's unsafe and it has a very specific purpose that it achieves. The problem is when...

We can still help you with a solution if you provide the information I requested in my last post.

DPD0011 (5/11/2016)

---

Copied and pasted with the missing part and received the error below.

Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'with'.

Msg 195, Level 15, State 10,...

The UPDATE statement you have shown is wrong. And again, what you have shown as...