Old NM.

Login with any other system admin login or windows account and run the code.

SQLRNNR (11/21/2011)

---

Not even a...

ChrisM@Work (11/21/2011)

---

Heh - Remi this looks like motive, when the rest of the world is wondering why the h3ll you want to spend another minute in Mycelium...

Jack Corbett (11/21/2011)

---

Hey, for those not on Twitter (why aren't you). My dad passed away early this morning. Not unexpected. I blogged about it, http://t.co/hCjjRnRh if you...

SELECT * FROM dbo.Table WHERE Col LIKE '%.%'

Or if it's already a decimal columns =>

SELECT * FROM dbo.Table WHERE Col <> FLOOR(Col).

Happy to help!

Are you running this for a single projects or all your projects at the same time?

What version of SSRS are you using?

Stefan Krzywicki (11/21/2011)

---

Ninja's_RGR'us (11/21/2011)

---

Stefan Krzywicki (11/21/2011)

---

Ninja's_RGR'us (11/21/2011)

---

Jack Corbett (11/21/2011)

---

ChrisM@Work (11/21/2011)

---

Move. Some of these fungi can cause serious respiratory problems. It's...

Stefan Krzywicki (11/21/2011)

---

Ninja's_RGR'us (11/21/2011)

---

Stefan Krzywicki (11/21/2011)

---

Ninja's_RGR'us (11/21/2011)

---

Hey guys I need your unbiased view of this.

I got flooded back in late august (Irene).

FINALLY after 2+ months somebody came in to do...

Stefan Krzywicki (11/21/2011)

---

Ninja's_RGR'us (11/21/2011)

---

Jack Corbett (11/21/2011)

---

ChrisM@Work (11/21/2011)

---

Move. Some of these fungi can cause serious respiratory problems. It's not worth taking...

Stefan Krzywicki (11/21/2011)

---

Ninja's_RGR'us (11/21/2011)

---

Hey guys I need your unbiased view of this.

I got flooded back in late august (Irene).

FINALLY after 2+ months somebody came in to do the first response...

If you want to tune the SP as well you can post the execution plan (actual) so we can look it over.

45 sec is on the slow end, even for...

Please don't cross-post, it fragments replies and wastes everyone's time.

Forward all replies here => http://www.sqlservercentral.com/Forums/Topic1209305-1063-1.aspx