At a guess, the likely reason is that one of the columns that you are joining on contains Char values and the other column in the join...

does it have to be in T-SQL ?

Random numbers are difficult for a computer the only way to get close to true random numbers is to mointor a random...

Elliott W (5/7/2010)

---

Steve,

I don't think i agree with one of the points. You can direct rows into different transformation paths in SSIS.

Products that have been around a while tend...

Steve Jones - Editor (4/28/2010)

---

What's more interesting is that if I do this:

set identity_insert #aa on

insert into #aa(id) select 8

...

yes that will send you into a loop. try using sub query instead

select * from m_items where item_guid not in (select order_item_guid from m_o_items)

Is there a reason why you cant join the tables in the where clause?

1. yes it can cause fragmentation if the id is an index column

Rather than physically changing the data in the table, since the ids seem to have...

there are temp tables, cursors and a while loop. There must be a way to make this code a bit more efficent by using set based code.

From what i...

Why are you using a While Loop?

that part of the code looks fine as long as the variables are declared, can you post the entire code to the stored proc?

this is a double post, it makes it easier to help if you keep to one post

original

http://www.sqlservercentral.com/Forums/Topic902981-360-1.aspx

you should really have some indexes on the temp table perhaps on User and Application.

Can you post the actual execution plan for the stored proc?

These look like questions from INFO 101 not a masters level paper.

What country are the job offers in?

this will mean a lot to the answers, as I know in the UK and several other countries, Germany has been mentioned. ...

Thanks Paul,

We were playing around with them today and thought they may be useful, i guess it can be dangerous to use undocumented features and i would never...

Another way of deleting duplicates is to use the hidden row identifier %%LockRes%% to identify the individual rows

using the test data post previously

DELETE FROM #Duplicates

WHERE %%LockRes%%

NOT IN (

SELECT MIN(%%LockRes%%)...