This looks really cool. Does it work with Azure? I can't test at work but definitely will when i get home.

Looks like I have version 8.05.2309 on my machine...

rituchaudhary.work (11/8/2012)

---

Hi,

thanks for the prompt reply but no good..I ran the query after adding the brackets but still got the same error..while the query is running fine on another server...

rituchaudhary.work (11/7/2012)

---

Hi,

I ran the script and it was giving desired results but in some of the servres it threw the below error:

Msg 207, Level 16, State 1, Line 89

Invalid column...

What does the "query text" have to do with the stored procedure, and why is it so different between different runs?

I'm running into the same scenario, except I'm not using a Try/Catch...here's my code:

Exec sp_changedbowner 'sa'

If (@@Error <> 0)

Print 'errored changing owner'

I get an error level...

One other thing that may be affecting all of this is there's a "Top" statement in this query and I'm ordering by the primary key...

gregory.anderson (3/30/2012)

---

Eugene Elutin (3/30/2012)

---

Try:

UPDATE STATISTICS TableA

SELECT *

FROM (

Select FieldA, FieldB

From TableA

...

Well, adding this line to my query:

And cl.CorrespondenceFO <> ''

My query returns data in 1 hour 26 minutes. I guess I never let it run that long BEFORE I added...

Eugene Elutin (3/30/2012)

---

Try:

UPDATE STATISTICS TableA

SELECT *

FROM (

Select FieldA, FieldB

From TableA

...

Wow, this took 3 hours 13 minutes to run. Should I be doing a percentage on the scan instead?

Create Statistics CorrespondenceLog_CorrespondenceFO On IARTS.dbo.CorrespondenceLog (CorrespondenceFO) With FULLSCAN

gregory.anderson (3/29/2012)

---

That one is a little off, here's the fixed version:

Selectb.CorrespondenceTemplateID, b.OccurrenceCount

From

(

-- Gets the Count for each template (username)

Selecta.CorrespondenceTemplateID As [CorrespondenceTemplateID], Count(1) As [OccurrenceCount]

From

(

-- Gets everything that is a...

That one is a little off, here's the fixed version:

Selectb.CorrespondenceTemplateID, b.OccurrenceCount

From

(

-- Gets the Count for each template (username)

Selecta.CorrespondenceTemplateID As [CorrespondenceTemplateID], Count(1) As [OccurrenceCount]

From

(

-- Gets everything that is a Saturday...

dweil (3/29/2012)

---

Thanks for the query but it gets sticky when the employee has multiple services over the same weekend. For example a service both on Saturday and Sunday would mean...

Elliott Whitlow (3/29/2012)

---

Thats a big table, I've only got about 4M but about 1.4TB of space used. And this helped me a lot. Keep in mind they have...