if i have 2 statements in my sp [Example:]
select something from table....
if @@rowcount = 0
select somethingelse from table 2
suppress the display of empty results. the problem i have is related to asp and the way asp calls sql server sp's.
basically if first select did not return any records asp returns empty recordset and not executing the second select statement. what am i doing wrong?