Hi
Cant seem to figure this out.. In my table i have a range of finishes which all have different finish types (Paint, Lacquer, Clear, Mill). There are also 3 other finishes that need to be in the list no matter what finish_id is selected. These are finish_id = 1
in a single stored procedure, how can i return data based on both types?
Here is what i have tried
WHERE (dbo.TBL_FinishList.TypeID = 1 AND TypeID = @TypeID OR @TypeID IS NULL AND (dbo.TBL_FinishList.active = '1'))
I need to return 2 finish types-
TypeID = 1 which is to be shown with all returns
TypeID = 15 which returns the required Finish Type (15 is the example)
Thanks