Hi
I have 2 SP
ALTER procedure [dbo].[AdminSearchP]
AS
BEGIN
SELECT * FROM House_p WHERE ID IN( SELECT DISTINCT houseP.ID FROM House_p houseP,SearchTerm WHERE [Model] LIKE '%' + SearchTerm.Name + '%')
END
ALTER procedure [dbo].[AdminSearch]
AS
BEGIN
SELECT * FROM House_info WHERE ID IN( SELECT DISTINCT houseInfo.ID FROM House_info houseInfo,SearchTerm WHERE [DESCRIPTION] LIKE '%' + SearchTerm.Name + '%' or address LIKE '%'+ SearchTerm.Name +'%')
END
I want write these 2 SP in One SP I mean I want Merg them can I do It?
Best Regards
Neda