Hi,
My stored procedure receives a value of an equipment ID (optional; that is, an empty string could be passed).
In the SP I want to find if such ID exists and if so, set the value of the equipment PK.
How do I test if the value of @EquipPk is NULL (record not found) on one line with the SELECT?
IF @EquipmentID <> '' and @EquipPk = (SELECT EQUIP_PK FROM EQ_FILE where ID_NUMBER = @EquipmentID)
BEGIN
END
TIA
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham