Have you tested the code that David Burrows posted above in this thread?

It should still be there since I found this on MSDN:

http://msdn.microsoft.com/en-us/library/ms189628.aspx

Only suggestion I have then is run this and look through the result set:

SELECT [object_name], [counter_name], [cntr_value] FROM sys.dm_os_performance_counters WHERE [object_name] LIKE '%Manager%'

If you don't see it, perhaps something happened...

Quick question, what is your server collation?

Evil Kraig F (6/27/2014)

---

Eirikur Eiriksson (6/27/2014)

---

The Dixie Flatline (6/27/2014)

---

Grant Fritchey (6/27/2014)

---

Koen Verbeeck (6/27/2014)

---

Grant Fritchey (6/27/2014)

---

Anyone think they can help this person? I think they really need it, and what's more,...

Here is the code I developed:

create table #Batches(

cmdBatchNb bigint,

PdsLbs decimal(10,6),

Zone tinyint);

insert into #Batches

values

(817159644,1.553200,31),

(817159652,9.095900,31),

(817159679,2.589180,6),

(817159687,5.712300,6),

(817159709,2.390300,6),

(817159733,2.279200,6),

(817159741,2.064700,7),

(817159768,1.243000,7),

(817159784,4.154700,6),

(817159792,3.565760,13);

create table #ZoneRates(

...

Here is a quick rewrite of the query:

SELECT

[Customer No_],

SUM(CASE YEAR(cle.[Posting Date])

...

What ever, I'm wrong, I get it.

I don't think in a CI manner unless I'm told otherwise. It isn't natural for me to think that 't' = 'T'. ...

sgmunson (6/26/2014)

---

Yep, Lynn, that would be mine. It IS dependent on the initial conditions, but with so little detail on what the real world scenario might be, I...

Also, instead of maintenance plans you may want to check out something like this:

http://ola.hallengren.com/

Yes.

With the same requirements, if you add a Marker with a third value for val, one of the options provided fails. Run this:

create table #Temp(Marker char(1), val char(1));

insert into...

And here, using the minimal sample set, are the execution plans for the suggested solutions.

create table #Temp(Marker char(1), val char(1));

insert into #Temp

values ('A','Y'),('B','N'),('B','Y');

select

*

from

...

Here is another option, requires two passes of the table though.

create table #Temp(Marker char(1), val char(1));

insert into #Temp

values ('A','Y'),('B','N'),('B','Y');

select

*

from

#Temp t

where

...

Again, congrats! Enjoy the new journey you are now embarking!