Sean Lange (6/6/2014)

Not big on providing details today I see. What does this query return?

select @@VERSION

The bottom line is that there are hotfixes out there to deal with this....

2008

So ... order by does not work with intersect?

Ordering by column name does not help

To craig 81366: Thank you, 81366. Certainly the problem can be easily solved with cte. I just wanted to make sure that order by does not work with intersect -...

I have two tables with patient ID - one contains several records for one ID (tblLetterFlag), in the second it is a primary key. This code works OK:

select ClinicalReviewID...

In my experience pivot codes work slower with big tables than case ones.

Very good article indeed. Learned a lot. I'm just taking on the "age" problem, it seems more complicated than I initially thought. I am working for a large health system...

Right ... it also does not work with infants (before they reach 1 year) ...

Thanks

Thanks. So simple zero can work as well. So far I checked the code several times - and it was ok. Where is a potential error? May be I missed...

Just bumped on this:

DECLARE @dob datetime

SET @dob='1992-01-09 00:00:00'

SELECT DATEDIFF(YEAR, '0:0', getdate()-@dob)

Works ok. Who can explain '0:0' ?

Thanks. Hope you entartained yourself as well (just a bit)

It did indeed (see attached)!

I added another join to the query - it runs now 3 sec (we started with 2 min 25 sec).

I'm excited and proud (as if I...

Sean,

On larger chank of data your CTE-based qry runs 2.5 times faster.

I learned a lot from this discussion.

Thanks, brothers ....

I tested your code with CTE and non-clustered - it does not give any advantage (I'll try it later on a larger range of dates - currently it is just...