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:-)

; WITH cteTableName AS

(

SELECTROW_NUMBER() OVER( PARTITION BY Man_name ORDER BY Model ) RowNum, *

FROMTableName

)

SELECTCASE WHEN RowNum > 1 THEN '' ELSE Man_name END Man_name, Model

FROMcteTableName

This should do it for you..

Why such a strange requirement? What is the problem if the trigger gets called 10 times? But still if you want the trigger to be called only once try converting...

SELECTE.*

FROMTRANSACTION T

INNER JOIN EMPLOYEE E ON T.RegisteredBYEmpID = E.EmpID

WHERET.RegisteredBYEmpID = T.ApprovedByEmpID

I hope this will give you the desired result. It would have been better if you had provided some sample...