Parallel SqlDataReader and reader.Read()

Using the query "and m.c_codigo_alm IN ('01')" in sql server I got this output

Using "m.c_codigo_alm IN ('01','02','03','04','13','15','16')" this is the knowing values but got to be an array because the values could change, this result is the SUM from the 7 c_codigo_alm, but I need separate them.

I expect this output:

If you got it, the first red square is the m.c_codigo_alm IN ('01'), and the second square is the SUM from the 7 consults.

All this in the SQL query.

But in C#:

I tried using "DataSet ds = new DataSet("Name");" with SqlDataAdapter to read the 7 consults in mode parallel with "Parallel.ForEach" or "Thread", and then bind the 7 results, but al the consults spend 3 minutes, so its the same problem, 30 seconds everyone x 7 = 3 minutes.

I think that SQL Server dont make parallel consults because everyone wait for his turn, so the query have to have modifiqued, to show this output, that is what I need with urgently after several days struggling.

I have tried with sqlfiddle but say this error Request content too large (>8000), the schema esported from sql have 16409 characters :(

PD: I uploated the scheme script.sql exported from sql server with the tables necesaries

 

The result with IN and the array if same like "Suma K" and "Suma P"

but I need the other columns too... I wanna cry haha

 

 http://www.c-sharpcorner.com/forums/uploadfile/9137a9/09102015122259PM/titulo.png

I really apreciate you help, this is the whole query

 

and the result gotta be this:

 

 

 

select
pro,
invproducto.v_nombre_pro,
sum(pieza) as pieza,
Sum(kilos) as kilos,
COSPZA= min(iSnULL(invproducto.n_costolabbdg_pro,0) ),
IsNull(invproducto.c_validarpeso_pro,'') as c_validarpeso_pro,
invproducto.c_unidadcosteo_uni,
c_codigo_uni = invproducto.c_codigo_uni,invproducto.c_unidadvtainv_uni
From invproducto (NOLOCK),
(
SELECT
'M' AS ORD,
fecha,mov,
TIPO,REPAR,
'' AS EMP,
PRO,
'' AS SERIE,
'' AS CODFACREM,
'' AS FACREM,


PIEZA= (cASE when IsNull(c_ajustexuni_mov,'') ='S' and IsNull(c_validarpeso_pro,'') ='S' and C_CODIGO_UNI = '02'
Then n_cantidadxuni_mov
when IsNull(c_ajustexuni_mov,'') ='S' and IsNull(c_validarpeso_pro,'')<>'S' and C_CODIGO_UNI = c_unidadcosteo_uni
Then n_cantidad_mov
when IsNull(c_ajustexuni_mov,'') ='S' and IsNull(c_validarpeso_pro,'')<>'S' and C_CODIGO_UNI <> c_unidadcosteo_uni
Then 0
wHEN IsNull(c_validarpeso_pro,'') <>'S'
THEN n_cantidad_mov
wHEN IsNull(c_validarpeso_pro,'') ='S' and C_CODIGO_UNI='02'
THEN n_cantidadxuni_mov
ELSE
(SELECT parte1.n_cantidadxuni_mov * (S2.N_CANTIDAD_EQU / S2.N_CANTIDADEQUIVALENTE_EQU)
FROM SOIEQUIVALENCIA S2 (NOLOCK)
wHERE S2.C_CODIGO_EQU=
(SELECT mAX(S1.C_CODIGO_EQU) FROM SOIEQUIVALENCIA S1 (NOLOCK)
wHERE parte1.C_CODIGO_UNI = S1.C_CODIGO_UNI
aND S1.C_CODIGOCONV_UNI = '02'
AND S1.C_CODIGO_PRO = parte1.c_codigo_pro
)
)
END),

KILOS = (cASE when IsNull(c_ajustexuni_mov,'') ='S' and C_CODIGO_UNI= '03' and c_unidadcosteo_uni <> '03'
Then n_cantidadxuni_mov
wHEN (c_unidadcosteo_uni='03' or IsNull(c_validarpeso_pro,'') ='S')
THEN n_cantidad_mov
ELSE
(SELECT parte1.n_cantidad_mov * (S2.N_PESO_EQU / S2.N_CANTIDADEQUIVALENTE_EQU )
FROM SOIEQUIVALENCIA S2 (NOLOCK)
wHERE S2.C_CODIGO_EQU=
(SELECT mAX(S1.C_CODIGO_EQU) FROM SOIEQUIVALENCIA S1 (NOLOCK)
wHERE parte1.c_unidadcosteo_uni = S1.C_CODIGO_UNI
aND S1.C_CODIGOCONV_UNI = '03'
AND S1.C_CODIGO_PRO = parte1.c_codigo_pro
)
)
END)

FROM
(
Select
m.c_codigo_mov as mov,
c_tipodoc_mov as tipo,
e.c_codigo_tmv as des,
e.d_documento_ent as fecha,
m.c_codigo_pro AS PRO,
m.n_exiant_mov as exis,
pro.c_unidadcosteo_uni as unicos,
iSnULL(M.C_REPARTOACTIVO_EMP,'') AS REPAR,
M.C_CODIGO_UNI AS UNI,
m.n_cantidadxuni_mov AS CAN,
m.n_cantidad_mov as peso,
IsNull(pro.c_validarpeso_pro,'') as tp,
/* variables nuevas para nuevo calculo */
c_validarpeso_pro = IsNull(pro.c_validarpeso_pro,''),
m.c_ajustexuni_mov,
m.c_codigo_uni,
pro.c_unidadCosteo_uni,
m.n_cantidadxuni_mov,
m.c_codigo_pro,
m.n_cantidad_mov
From invmovimiento m (NOLOCK),
invproducto pro (NOLOCK),
inventrada e (NOLOCK)

Where m.c_codigo_pro=pro.c_codigo_pro
and m.c_tipodoc_mov='E'
and e.c_codigo_ent=m.c_codigo_ent
and m.c_codigo_alm IN ('01','02','03','04','13','15','16') -- HERE WOULD BE THE 7 almacen variable
and (m.c_codigo_pro >= '00000000'
and m.c_codigo_pro <= '99999999')
and e.d_documento_ent < ={ts '2015-09-10 00:00:00.000'}
and e.c_activo_ent = '1'
and pro.c_codigo_prv = '0010'

UNION ALL

Select
m.c_codigo_mov as mov,
c_tipodoc_mov as tipo,
l.c_codigo_tmv as des,
l.d_documento_sal as fecha,
m.c_codigo_pro AS PRO,
m.n_exiant_mov as exis,
pro.c_unidadcosteo_uni as unicos,
iSnULL(M.C_REPARTOACTIVO_EMP,'') AS REPAR,
M.C_CODIGO_UNI AS UNI,
m.n_cantidadxuni_mov AS CAN,
m.n_cantidad_mov as peso,
IsNull(pro.c_validarpeso_pro,'') as tp,
c_validarpeso_pro = IsNull(pro.c_validarpeso_pro,''),
m.c_ajustexuni_mov,
m.c_codigo_uni,
pro.c_unidadCosteo_uni,
m.n_cantidadxuni_mov,
m.c_codigo_pro,
m.n_cantidad_mov
From invmovimiento m (NOLOCK),
invsalida l (NOLOCK),
invproducto pro (NOLOCK)

Where m.c_codigo_pro=pro.c_codigo_pro
and m.c_tipodoc_mov='S'
and l.c_codigo_sal=m.c_codigo_sal
and m.c_codigo_alm IN ('01','02','03','04','13','15','16') -- HERE WOULD BE THE 7 almacen variable
and (m.c_codigo_pro >= '00000000'
and m.c_codigo_pro <= '99999999')
and l.d_documento_sal < ={ts '2015-09-10 00:00:00.000'}
and pro.c_codigo_prv = '0010'

) AS PARTE1
)two
where two.pro=invproducto.c_codigo_pro and invproducto.c_activo_pro='1'
group by pro,invproducto.v_nombre_pro,invproducto.c_validarpeso_pro,invproducto.c_unidadcosteo_uni,c_codigo_uni,invproducto.c_unidadvtainv_uni
ORDER BY PRO