hii have 1 table code item1a pena pencilb item3b item4i need to select any item based on code in just 1 column.now item3 contains pen and pencil.so i supply @item3 it gives me a pena pencil,what i need is ,if @sign is there,it should return b item3
@works for grouphow to do that?
The way I would do it is to change the structure. I would add another table with the component elements for your item3 and item4 and then do a join to that table to return the proper components.
I M creating 1 temp table.but as this all in sp ,i need to retun in 1 single slect stm.
hwo to do that and what query should i write to get desire result,its only 1 table
my prob is i m passing value as @param
but in table it stored like param.
so i am not getting exact match