Create table #temp
(
  gl_group_id Int 
)

insert into #temp
select distinct gl_group_id
from ipadmin.gl_txn
where transacted_on >= convert(datetime, '03/07/2008', 103)
and transacted_on < convert(datetime, '03/07/2008', 103) + 1
and belongs_to_hcare in (100) 

update ipa  
set defunct = 'Y'
from ipadmin.GL_TXN ipa 
inner join #temp t
  ON ipa.gl_group_id = t.gl_group_id

rodneykee (1/2/2012)

---

Terry,

This is what I would've done:

update ipadmin.GL_TXN set defunct = 'Y'
from ipadmin.gl_txn
where transacted_on >= convert(datetime, '03/07/2008', 103)
and transacted_on < convert(datetime, '03/07/2008', 103) + 1
and belongs_to_hcare in (100)

Rodney

update ipadmin.GL_TXN set defunct = 'Y' 
where gl_group_id in 
	(select 
		gl_group_id 
	from ipadmin.gl_txn 
	where transacted_on >= convert(datetime, '03/07/2008', 103) 
		and transacted_on < convert(datetime, '03/07/2008', 103) + 1 
		and belongs_to_hcare in (100) 
	GROUP BY GL_GROUP_ID)