Click here to Skip to main content
15,867,934 members

Comments by HarisJayadev (Top 16 by date)

HarisJayadev 3-Mar-14 4:08am View    
Product ID will repeat for combination of dimension like
Product Dimension
1 1
1 3
1 5

For Example i'm passing comma separated values as 1,3,5 then it shoulod return value available
if is end values as 1,5,4 it should return value not available
if i send value as 5,1,3 or 1,5,3 or 3,5,1 like this it should return values as value available
HarisJayadev 3-Mar-14 3:05am View    
ya i have converted my table as us mentioned in above answer. I need to compare as no matter of order of numbers. for example if i pass stored procedure parameter as '1,3,5' or '1,5,3' or any 3*3=9 combination. it should tell as dimension combination exist for a product.
HarisJayadev 3-Mar-14 2:57am View    
I want to compare dimension with comma separated values
HarisJayadev 3-Mar-14 2:55am View    
i don know how to compare comma separated values using loop in sql server stored procedure. is it good idea to use loop or do i have any other option
HarisJayadev 3-Mar-14 2:55am View    
I want to compare dimension with comma separated values