Finally I created a store procedure that I call it with a string parameter "1,1,1,2,3,3,4" and creates what I need. I think is only way to get what I need.
Thank you all for your time. --- In [email protected], "raistware" <raul.ferriz@...> wrote: > > Hi > > Im trying a bit difficult select: > > select id, value > from MyTable > where id in (1, 1, 1, 2, 3, 3, 4) > > I want that fore every value inside IN a row is output, so for example this > would result something like: > 1 | 40 > 1 | 40 > 1 | 40 > 2 | 21 > 3 | 23 > 3 | 23 > 4 | 87 > > But now I don't take duplicates, result is > 1 | 40 > 2 | 21 > 3 | 23 > 4 | 87 > > Can someone help me to create that tricky select? > > Many thanks in advance >
