I believe the difference here is in the hash match operation , in your version it is matching on 2 columns and in Jeff's 1 column.

Hash matching is a comparatively...

Doesnt this just completely negate any advantage of table vars though ? .

The main reason to use...

This is why the design is so bad....

Untested , you will have to account for the other columns you need

Declare @SqlString varchar(max)

Declare @CaseStmt varchar(max)

Declare @Upvt ...

There is no neat way to do this, the design is bad.

Possibly the easiest way is to build a dynamic sql string by testing for the incrementing column group...

First off , you are using a table variable here not a temporary table.

The table is being destroyed and recreated on each call so its not suprising your data is...

Another Option

Select Id,DateTime,

case when RowN = 1 then TagA

when Rown...

Can you be any more specific than "some times" ?

All the aggregate functions now support the partition by clause , in this case we dont want to partition so i...

Something like this ?

declare @t table

(

id int ,

Class varchar(20)

)

insert into @t

select 1, 'ADS' union

select 2, 'ggS' union

select 3, 'dS' union

select 4 , 'hhf'

select *,count(*) over (partition...

Team viewer!!! Gone beyond the realms of tell me how to do my work , to ACTUALLY do my work.

" and you need the full fix now, please contact customer support".

Sounds like it is fixed, but in a hotfix. Might be worth taking them up on this offer...

Submitted

http://www.sqlservercentral.com/Contributions/Edit/71571

The 'reads' value is the number of 8k pages read not the number of rows.

That should be in an if statement,

It doesnt reference ANY table data

Not only that but the nested UDF of fnGetValueAndType , could be doing a monstrous amount of work too.

ummmm

SELECT COUNT(*)/8

FROM myTable

WHERE Class = 'Art'