select  Address.*, Person.* from Member.dbo.person as Person left join Member.dbo.addressrelation as AddressRelation on 
                    person.personid=addressrelation.parentid left join Member.dbo.address as [Address] on 
                    [address].addressid=addressrelation.addressid 
                where addressrelation.Addresstypeid='h' and person.PersonID=@PersonID;

			if ROWCOUNT = 0
			begin
				select Address.*, Person.* from Member.dbo.person as Person left join Member.dbo.addressrelation as AddressRelation on 
                    person.personid=addressrelation.parentid left join Member.dbo.address as [Address] on 
                    [address].addressid=addressrelation.addressid 
                where addressrelation.defaultflag=1 and person.PersonID=@PersonID;
			end

quote:

---

Originally posted by prosh0t

Hi!

I have some T-SQL in a stored procedure. What i'd like to do is if one query doesnt' return any results, run another query. I can't figure out how to do that. Any ideas? Thanks!

Here is the code :

select  Address.*, Person.* from Member.dbo.person as Person left join Member.dbo.addressrelation as AddressRelation on 
                    person.personid=addressrelation.parentid left join Member.dbo.address as [Address] on 
                    [address].addressid=addressrelation.addressid 
                where addressrelation.Addresstypeid='h' and person.PersonID=@PersonID;

			if @@ROWCOUNT = 0
			begin
				select Address.*, Person.* from Member.dbo.person as Person left join Member.dbo.addressrelation as AddressRelation on 
                    person.personid=addressrelation.parentid left join Member.dbo.address as [Address] on 
                    [address].addressid=addressrelation.addressid 
                where addressrelation.defaultflag=1 and person.PersonID=@PersonID;
			end

the above doesn't work, i get the error "Incorrect syntax near the keyword 'ROWCOUNT'."

---