My question is why should it? It is captured by the default trace.

gbritton1 (4/24/2014)

---

Here's a great article on the topic:

http://www.brentozar.com/archive/2012/07/identifying-correcting-sql-server-implicit-conversion/

I stopped relying on implicit conversion years ago. In fact, in all languages I write I try to adhere to the "Explicit...

And what is the problem?

Here is some code:

create table dbo.Source (

EntryID int,

Categories varchar(200)

);

insert into dbo.Source

values

(541,'A,B,C'),

(345,'B,C'),

(234,'A,C'),

(657,'D,E'),

(435,'D');

go

create table dbo.Target (

EntryID int,

...

below86 (4/23/2014)

---

Matt Miller (#4) (4/23/2014)

---

below86 (4/23/2014)

---

Good to know, I wasn't aware that it rounded up.

It is wierd that if you do .998 it shows as .997.

declare @d datetime;

set @d =...

below86 (4/23/2014)

---

Lynn Pettis (4/23/2014)

---

below86 (4/23/2014)

---

Wouldn't it be better to use the BETWEEN with these dates?

WHERE (ath_postype = 'NTC' OR ath_postype='NTD')

AND ath_postdate BETWEEN '2013-01-01 00:00:00.000' ...

And...

Just making it easier for others:

http://msdn.microsoft.com/en-us/library/ms190682.aspx#TsqlProcedure

I have downloaded and looked at both of the latest sqlplans, both use the same index due to the use of the WITH(INDEX(AI_OperatorCBGEstimate_HAP)) index hint on the query.

ChrisM@Work (4/22/2014)

---

GilaMonster (4/22/2014)

---

ChrisM@Work (4/22/2014)

---

And yes, every other plan the OP posted show only KeyInstn and DateEndedStandard coming out of the index seek, as you'd expect.

Systems here won't let me...

More issues. You renamed the table to TABLE2 and...

But you didn't answer any of the questions. Changing the...

Brandie Tarvin (4/21/2014)

---

:crying:

Why, oh why, oh why do people insist on pulling scripts off the internet then asking us to modify them to do what they want the scripts to...

One other question, are we talking calendar years here?

That is...