Ed Wagner (9/4/2013)

---

Sean Lange (9/4/2013)

---

Koen Verbeeck (9/4/2013)

---

Sean Lange (9/4/2013)

---

Koen Verbeeck (9/4/2013)

---

Sean Lange (9/4/2013)

---

Well this post is my 10,000th point. I guess I have proved I too can waste lots of...

The syntax errors are because this is using REALLY old sql syntax. IIRC *= means a left join.

You really need to convert this to ANSI-92 style joins instead of...

Koen Verbeeck (9/4/2013)

---

Sean Lange (9/4/2013)

---

Koen Verbeeck (9/4/2013)

---

Sean Lange (9/4/2013)

---

Well this post is my 10,000th point. I guess I have proved I too can waste lots of time answering forums posts...

Tom Bakerman (9/4/2013)

---

Unfortunately, the named user does not have permission for SHOWPLAN. I won't be able to change that until...

Koen Verbeeck (9/4/2013)

---

Sean Lange (9/4/2013)

---

Well this post is my 10,000th point. I guess I have proved I too can waste lots of time answering forums posts instead of doing my...

azdeji (9/4/2013)

---

Thanks for the pointers guys, I guess i missed out the most important part which is that the value in Segment column will be changing but the formatting will...

You will probably need a tally table for this as the main table for your query. That way when a month has no data the result set will still have...

Start with execution plans. Are they the same?

markjholmes (9/4/2013)

---

This seems simple enough to be a good starting point for me to contribute to the SSC community.

I can take this one, Steve, if you'd like.

Sean: I...

This isn't exactly worth an article. It is nothing more than a single command (t-sql) and a single screen shot to use the UI.

Well this post is my 10,000th point. I guess I have proved I too can waste lots of time answering forums posts instead of doing my actual job. Thanks everyone...

You are seeing this because of integer division. When your count is 100% it works because the integer division returns 1. When it is less than 100% your first calculation...

There has to be something going on. SQL won't just arbitrarily decide to deny connections after 6:30pm because it is done working for the day. There has to be something...

ritika rishi (9/4/2013)

---

John Mitchell-245523 (9/3/2013)

---

Do you only get this error after 6:30 pm? Are you a member of sysadmin on the server? If you are, there should be...

Yet another copy of the same thread. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1491239-7-1.aspx