conditions were right but syntax of like condition was wrong thats why it was showing wrong data...

but now it's working

if any problem then i'l let you know..

thanks for ur valuable...

Yes ,

It's working..

Thank you very much 🙂

I used or in to the storeprocedure,

It executed but not taking id's for all conditions,

I mean to say,

i have streamid in my transition table like

%,519%

%,519,%

%519,%

%519%'

so i gave the condition

where...