John

Have a look at the execution plan and see if you can tell what part of the query is taking the most resources.  Do you have an index on each...

Jeff

Somehow you have changed data_type to date_type.  If it still doesn't work after you've corrected that, chances are you have a case-sensitive collation, in which case you will need to...

Private message from original poster:

Table structure  is like this..

empId,Name,Address,Salary,Hire Date,Department

Sample data:

001,Lenin,bangalore,30000,12 Sep 2004,HR

I think Avinash means to use getdate() instead of sysdate()...  Also, if...

Answered here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=291993

Answered here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=291993

You might find that you try members' patience if you repeatedly post the same question three times.  If you post it in the correct place just once, we will still...

No need to post more than once, even if you are desperate!  Answered here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=291984

No need to post more than once, even if you are desperate!  Answered here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=291984

I imagine that the original poster want the Nth salary, ie the one with N - 1 salaries higher than it, whether they be distinct or not.

This one is a...

Brij

Try this.  It will return a date whose time component is the same as the date you specify.  If you want it to return a date that ends with 00:00:00.000...

Neil

Sysadmins can do anything they like on the server, no matter what.  If that isn't what you want, you'll need to go for a lower server role, such as Security...

Gary

If you use the /3GB switch then you will, in theory, be able to use 3GB of RAM.  I'm sure I don't need to remind you to reboot after you've made...

Profiler is a diagnostic tool that records events that happen on SQL Server.  You will find it in your Start menu, in the same place as Enterprise Manager and Query...

I don't know anything about Project Server or Sharepoint, but it sounds likely to me that you've got a perfectly good SQL Server installation and that reinstalling it may not...

You need the SQL Server 2000 setup CD to uninstall.  But, before you try that, if the database definitely does exist, then it's probably just a login or permissions thing. ...