Hi there,

i am a starter for SQL server, i wonder someone of you could help me out as i am struggling to execute second select statement based on the first sql statements result.

i have two sql statement, say the first returns the customer record,if i get the result then exit the SP otherwise try for another select statement for an agent.

immediate response will highly be appreciated.

regards
ibs

After your first select statement check the @@rowcount variable:

IF @@rowcount > 0
   return
Else
   Run your second query here ....

Hi jbenson001,

thanks a million ! that work very well for me.

cheers
ibs

can you please also let me know how to handle this from my ASP page, when i try to call this SP , works fine for the first query but when i try to give username/password for the second select statment its not returning nothing on my asp page.

whereas i can see the result returned back in sql-analyser.

could you see my point ?

I would need to see your code to find out what you are trying to do.

Jim

Hi Jim,

its basically a login page, two types of customers trying to access one single login, say type A,typy B customers.

when tpye A customer try to login, i will be using first select statement which takes username/password and returns back the record, if this query returns nothing than i try for the second statement assuming that this is type B customer, if it matches than return back the record.


it works very fine in Query Analyzer but through ASP page its not,
it is working fine for the first type A , i beleive its only referring to the first select statement all the time.

if this is not cleared, i would than try to post my code then
.

thanks much
ibs