hi
this is my store procedure
ALTER procedure [dbo].[electricmenu]
as
begin
select distinct Classification,H_name
from House_p
where H_name='Electric'
end
it worked correctly but now i need id column that is primary key when i change sP to this
ALTER procedure [dbo].[electricmenu]
as
begin
select distinct Classification,H_name,ID
from House_p
where H_name='Electric'
end
distinct didn't worked it show all data from classification column. i need both id & calssification column data what should i do?
best regards