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

:-)And i hope you understood why it failed..

If you didn't, have a look at the following link

http://www.sqlservercentral.com/blogs/never_say_never/archive/2010/1/28/in-and-not-in.aspx

Check if this the below code returns any NULL values

SELECT ID FROM @TempTable

If it does your first query will fail..

And posting some sample data along with your table structure will...

This will be a useful link for you..

http://www.sqlservercentral.com/articles/SQL+Server+2008/65539/