The account column is an int, so you must convert or cast it before looking at only the first 2 numbers. Personally, if you can change this, I would...

There are 7 days in a week, every week. So that one is easy. Why not just store these values in a separate table as a reference table? Like...

Good point 🙂 Thanks!

Thanks for the quick responses. So basically, the maximum CPU time is a function of #cores/cpu * #cpus * elapsed time. Of course it can be lower than...

WHERE sys.dm_exec_requests.total_elapsed_time > 5

capn.hector (3/2/2012)

---

You have to loop through the dates, personal preference is a WHILE loop. below is a stored procedure where you can pass the string all or a specific...

So, you want to look at the number of months between posting date and end date and basically copy data for each month remaining except that posting date should be...

If you are that concerned about performance... why not split it into a couple of separate update statements and get rid of your OR conditions?

Elliott Whitlow (3/1/2012)

---

Always is a strong word, so I'm going to say no. Over a long period of time they will probably be close, but any session remaining open...

aurato (3/1/2012)

---

SQLKnowItAll (3/1/2012)

---

aurato (3/1/2012)

---

SQLKnowItAll (3/1/2012)

---

Umm... Unless I missed something, you are trying to change the data type on a production table that is accessed by Great Plains? I'm not so...

aurato (3/1/2012)

---

SQLKnowItAll (3/1/2012)

---

Umm... Unless I missed something, you are trying to change the data type on a production table that is accessed by Great Plains? I'm not so sure it...

GSquared (3/1/2012)

---

SQLKnowItAll (3/1/2012)

---

The semi-colon at the start of his query is actually bad when demonstrating the method used for creating a CTE. It's there to terminate the previous statement but...

Umm... Unless I missed something, you are trying to change the data type on a production table that is accessed by Great Plains? I'm not so sure it is a...

Let me ask you this... Is this database accessed by a 3rd party application? The application itself may be sending this command.

Are you sure that the jobs are failing? I don't know your level of experience, so let me ask how you have determined that alerts should be sent; i.e. how...