Check for port blocking also.

User DATEADD(datepart, number, date) function for this operation.

Put take trace while running your procedure. There might be some trigger... or some other procedure or so, which might be deleting the records.

You will get clear picture in trace.

There are few thing you need to keep in mind

-How you query the database? Means which fields do you use in WHERE clause and which fields do you use in...

I am sure this is interview question. But merge and hash join are Oracle terminology. It is not good idea to ask this question here.

Any way here is the link...

is it some interview question or you have some problem in JOIN query?

By the way sql server uses nested loops and index

nested loops join.

Hi

You can use this script.

============

DECLARE @handle VARBINARY(64), @connection_id UNIQUEIDENTIFIER, @session_id INT

DECLARE @maxCnt INT, @cnt INT

CREATE TABLE #tmp(id INT IDENTITY(1,1), session_id INT, connection_id UNIQUEIDENTIFIER, handle VARBINARY(64))

INSERT INTO #tmp(session_id, connection_id, handle)

SELECT...

There is no other place then default log location.

It gave me result as INT, DECIMAL and MONEY. Result was correct but my interpretation was wrong.

I have also executed the query and tick the wrong answer. 😛

Are you using the SSMS GUI or executing query for removing the FK.

If using the GUI then, some time it drops and recreate the tables. So first see...

Use UNPIVOT statement for this.

Jeff Moden (12/30/2008)

---

The only way it's going to get any faster is if someone sits down with the business rules, and rewrites it using some decent set based logic....

Hi,

you can write your condition in JOIN statement instead of WHERE statment.

table1 LEFT OUTER JOIN table2 ON table1.DATE = table2.DATE and table2.emp = '123'

This way it will select all records...

Merry Christmas to all. See you in new year!.