Database

Satips wrote:

Then how will you program and create query Diana.

select Academic.AcNum, Academic.FamName, Academic.GivenName, Academic.DeptNum
from Academic
where Academic.FamName in (
   select FamName
   from Academic
   group by FamName
   having count(*) > 1)
order by Academic.AcNum

Declare @stepid int
set @stepid = 1 --change to 2 after you have run the export
 
if @stepid = 1
    create table vendorbak (DCLink int, Account nvarchar(1000), Name nvarchar(1000))
 
select DCLink, Account, Name into VendorBak from Vendor where CT = 0
update Vendor set CT = 1
 
if @stepid = 2
    update Vendor set CT = 0 from VendorBak vb where Vendor.DCLink = vb.DCLink
 
drop table vendorbak

Navaneeth. wrote:

I bookmarked this link long back. And yesterday I tried to get it again and resulted in 404.

column_name<br />
----------------------------<br />
au_id<br />
au_lname<br />
au_fname<br />
phone<br />
address<br />
city<br />
state<br />
zip<br />
contract<br />
(9 row(s) affected)