You cannot use an IDENTITY column for this. You will have to use a Computed Column.

DECLARE @tblTable TABLE

(

Col1 TINYINT IDENTITY(1,1) NOT NULL,

Col2...

It would help if you can give us some sample data and the table structure. It would be difficult to help you with the given information.

From whatever i understood, I...

Thats what i was looking for. But sadly i don't have SQL Server 2008. I can use your other methods till then. Thanks once again Paul.

I had actually googled some information about the error but i was of the impression that the number -0.6401 was of type DECIMAL(5,4). I didn't know SQL Server was considering...

Thanks Quatrei, that worked. Good work around to solve the problem.

Poor guy would...

Yes. And it is also faster than the Cross Tab. But as i said it may...

No idea what's wrong then. It does give the desired result in my system.:unsure: Are you sure you are using DENSE_RANK and not ROW_NUMBER?

Oh, I didn't see that.

SELECTP.pkTransactionID, [TOT],

ISNULL( [TOT], 0 ) + ISNULL( [GBX], 0 ) + ISNULL( [IEX], 0 ) + ISNULL( [UNK], 0 ) UniqueEnvS,

[GBX], [IEX], [UNK], MAX(DateTimeReceived) DateTimeReceived

FROM(

SELECTpkTransactionID, LEFT(...

SELECTpkTransactionID, [TOT],

ISNULL( [TOT], 0 ) + ISNULL( [GBX], 0 ) + ISNULL( [IEX], 0 ) + ISNULL( [UNK], 0 ) UniqueEnvS,

[GBX], [IEX], [UNK]

FROM(

SELECTpkTransactionID, LEFT( ComponentText, 3 ) ColName,

CONVERT( INT, REPLACE(...

This will do it for you..

SELECT*, DENSE_RANK() OVER ( PARTITION BY PatID ORDER BY DisID ) myCol

FROMmyTable

Please make sure you post in the appropriate forums to get faster response.

You can use a PIVOT or a Cross-Tab. But only testing will tell which is the better option amongst all.

Try this as your Where Clause

WHERE 1 = CASE

WHEN @CompanyLetter = 'ALL'

THEN 1

...

You can write your own User Defined Functions for the same. Take four parameters and return the maximum and minimum among them.

You are right:-)