where is your query or error-generation command ?

select ...

from employee E

inner join Rooms R

on E.EmpRoomNum = R.RoomNum

inner join Device D

on D.DeVRoomNum = R.RoomNum

and D.DevSignByEmp = E.EmpID

would be...

.Bak files should be restored

check restore database in books online

I didn't check the forum-group

Now my responce...

Is this a clustered server ?

EnterpriseManagers does not autorefresh.

If you don't trust its results, disconnect and connect again so it refreshes all catalog-data.

Hitting F5 at the tables-tree in the lefthand pain, also may help.

check this site's search : "remove duplicates".

Test it before going live !

Many of us use Query Analyzer to perform this kind of stuff.

(Enterprise...

Thanks for the addition, Frank.

I was to much in a hurry for my lunchbreak.

.... and lost...

select yourkeycolum(s) , count(*) as counter

from your_object

group by yourkeycolum(s)

having count(*) > 1

-- order by yourkeycolum(s)

I hope this helps

I'ts always a nice year if you can look back on it  

Be patient, be strong and shut off your nose

also check this function :

http://www.sqlservercentral.com/scripts/contributions/1199.asp

actualy I guess it is a rounded value (...6667)

You might also consider float-datatype

set nocount on

create...

you might try this :

set nocount on

create table #t1 (col1 varchar(100) not null, col2 decimal(8,2) null)

insert into #t1 (col1) values ('.0366666666666666666666666666666666666667')

select * from #t1

update #t1

set col2 = convert(decimal(8,2),substring(col1,1,CHARINDEX (...

Check dbcc spaceused, to find out the index-statistics for your table/index.

dbcc dbreindex yourtable will optimize spaceusage of your table when you'r using a clustered index.

sp_updatestats, dbcc updateusage may help to...

Is this what you mean ?

-- Begin Tran

-- update T

-- set end_date = MEdt.MaxEndDate

select T.*

, MEdt.MaxEndDate

, Mmog.Maxmemberofgroup

from mytable T

inner join

(

select person_id ,max( end_date ) as MaxEndDate

from mytable

group by person_id

)...

... (repeat 80,000 times).... 

with waitfor delay '00:01:00' ? 

Adjust the set rowcount ***

select dateadd(mi,80000,getdate()) - getdate()

results :