; 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...

Which company would be having thousands of...

Born in Kanniyakumari ( India )

Brought up in Mumbai ( India )

Employed for a year in Chennai ( India )

Now i am back in Mumbai working on SQL Server 2005.

But...

steveb. (3/22/2010)

---

Kingston Dhasian (3/22/2010)

---

SELECT*

FROMdt

WHEREDAY( DATEADD( DAY, 1, dt ) ) != 1

I don't think performance should be a concern as almost all the rows ( hopefully ) are returned....

Jeff Moden (3/22/2010)

---

Will any of those dates ever have a time associated with them? That's a bit of a rhetorical question... you should always assume they will and write...

SELECT*

FROMdt

WHEREDAY( DATEADD( DAY, 1, dt ) ) != 1

I don't think performance should be a concern as almost all the rows ( hopefully ) are returned. In such a case...

No, you can't. You can use the RANK or the DENSE_RANK for the same.

Again both of...

ROW_NUMBER gives unique values even if it is a...

chandrasekaran.ganapathy (3/22/2010)

---

I guess DENSE_Rank is the better way. I don't like to use Row_Number. Thanks for the answer.

Select Salary from Table1 Where Salrank='3' Where (Select Dense_Rank()

over (Order By Salary...

What is the result set that you are getting.

Does the below query return any NULL values

select (EngineerId) from Table2

chandrasekaran.ganapathy (3/19/2010)

---

This is ok if the table1 does not have the repetition of EngineerId. But Table1 has the repetition of EngineerId. I've tried your code. It says Primary Key violation....

I doubt if anybody is going to get this right. 20 attempts so far and nobody has got it till now.

It would be better somebody from SSC reviews the Question...