i am writing a SP and want to do the next thing:
1. check whether a row exists by key field.
2. if not - raiserror
3. if does exist - return it.
the thing is that i dont want to scan the table twice with 2 select statements, and dont know how to do it....
any sugestions ??
thanks a lot, Ran.