I beg to differ. The statement:

select @max(turno)+1 into @_type from u_contadores

is not valid...

.

It should only have a single column called [Column 0]. Correct? Or did you give the column a name?

Assuming it's called [Column 0], see if...

By the way, the solution I posted is going to take away the optimizers' opportunity to take advantage of any appropriately-sequenced covering indexes. In other words,...

tshad (7/13/2011)

---

I have Sort order I want to do where if a parameter is 1 then it is sorted by one column and if 2 a different column.

The problem is...

Ah... that explains it... not enough bits to make a complete byte...

[font="Wingdings"]I like that!! The little "frownies" are quaintly misleading.[/font]

carl.meads (7/13/2011)

---

My column names are not [2009] and [2010] my column name is PeriodYear and then I have 5000 records for example that are 2009,2010 along with an asset so...

Last I heard, adding produces a sum and subtracting produces a difference (or variance).

I don't know what else to tell you. ...

It is easy, unless there is something you are not telling us.

Do us the courtesy of posting the schema or code for the things you've tried.

If I understand you correctly, you want accompanying detail (refID) to go with the maximum value. Basically you want information for the top row (sorted by value) in...

Understood. But please understand the code posted will ONLY work as long as there are NO changes to those ExamRowID numbers. If those ExamRowID numbers...

Your problem is that there is NOTHING in your data that identifies the READING rows as compared to the WRITING rows, other than the examrowID. Assuming...

Forget Denali and R2... It's almost time to start talking about (American) Football again.

It were only a single table, you could try an index over the three columns you are doing your GROUP BY on. In your pseudocode example, that would...