Not too clear. Do you want to delete the records in Table1 or just set the EID to null. Either way to get the opposite result of your...

have to wait until Monday.

works for me.

what does this bring back for you?

select a.code,a.price, b.code,b.price from table_b b join

(select code,max(eff_date) eff_date from table_b group by code) tbmd

on tbmd.code = b.code and b.eff_date = tbmd.eff_date

join...

use a derived table

select code,price from tableb join

(select code,max(date) from tableb group by code) tbmd

on tbmd.code = tableb.code and tableb.eff_date = tbmd.date

and join it to tablea

You seem to be running a few threads all on this same topic. I would suggest that you post a sample (10 or 20 rows) of the data in your...

isdate('13/34/2007') will return false

You should review BOL for SET ROWCOUNT as there are warnings about using this in updates,deletes, and inserts.

If you are just doing selects then you should be ok.

select * into #temp from mytable where

(postion not in (4,6,7))

or

(datefield not between mindate and maxdate)

or

somefield <> [what it should equal]

and you could do the same for table2

You would need...

Only way I have ever heard of is with dynamic sql.

Why do you care where it is? Data is displayed in the order you select it. I think when you do that through EM it causes the table...

Why not

select * into #temp from mytable where postion not in (4,6,7)

I was working on a simialr solution but when I tried your index trick to get the update in the right order it still goes asc. Might be because...

alter table mytable

add id int IDENTITY(1,1) not null

to limit the display you want to cast or convert it after the math. Or you round it.

SELECT CONVERT(DECIMAL(2,0),83)/CONVERT(DECIMAL(2,0),97)

SELECT cast(CONVERT(DECIMAL(2,0),83)/CONVERT(DECIMAL(2,0),97) as decimal(9,2))

SELECT round(CONVERT(DECIMAL(2,0),83)/CONVERT(DECIMAL(2,0),97),2)

The way ours works is if you don't scan in you cannot scan out and vice versa.All cards scanned in but not out are reset at the end of the...