Printing No Records Found

[brown3313]

I am new to this. Someone please help.

I am creating stored procedures that queries the tables to pull certain information together in a listing (report). I would like to be able to print to the user "No records found", if no records were found based on the search criteria. I can able to query the information, but can't get the "No records found" to print. The listing just comes back with no records.

Is there a canned syntax/statement to make this happen and should it be placed before or after the select statement?

Is there some sort of end of file checking that needs to happen?

[blade_in_exile]

try an IF ELSE query

EXAMPLE

IF (there are records) { DO SOMETHING
} ELSE {
DO SOMETHING ELSE
}

you can expand on this by using ELSEIF instead of the first ELSE statement as long as you finish the whole thing with an ELSE statement

hope this helps

[brown3313]

Thank you. I have been using the if, else statement. It seems to work in some of my stored procedures, but not the others. Here is a sample of what I have done. Any more suggestions?

Begin
If Exists (select 1 from table_name, table_name1
where table_name.field name = table name1.field_name)

Begin
Select .......
End
ELSE

begin
print ' no records found'
return
end
end