Falha na ligacao BD st query_produtos80 (QUERY =
declare @PageIndex int, @PageSize int;
set @PageSize = 20;
set @PageIndex = 1 1;
IF OBJECT_ID('tempdb..#tab21') IS NOT NULL DROP TABLE #tab21
CREATE TABLE #tab21(RowNumber int identity, stid numeric (12,0), ref char(18), u_desccat varchar(254), langdes1 char(60), u_imgg varchar(254), url varchar(254), epv1 numeric(19,6), tipodesc varchar(20), stock int, u_stockmax int, qttcat int, pbruto int, stmax int, stmin int, u_compativ varchar(4), usr1 varchar(20), epcpond int, familia varchar(18), ptoenc numeric (10,3), u_ccopia numeric(12,5), u_numero numeric(6,0), u_minvend int, u_unidcust varchar(20), u_marketin varchar(20), tabiva numeric(1,0), u_txequipn numeric(12,5), u_txnet numeric(12,5), u_txecovan numeric(12,5), u_statprod varchar(20), u_prazoent varchar(20), u_condent varchar(20));
insert into #tab21(stid, ref, u_desccat, langdes1, u_imgg, url, epv1, tipodesc, stock, u_stockmax, qttcat, pbruto, stmax, stmin, u_compativ, usr1, epcpond, familia, ptoenc, u_ccopia, u_numero, u_minvend, u_unidcust, u_marketin, tabiva, u_txequipn, u_txnet, u_txecovan, u_statprod, u_prazoent, u_condent)
SELECT stid, st.ref, u_desccat, langdes1, u_imgg, url, epv1, tipodesc, stock, stobs.u_stockmax, qttcat, pbruto, stmax, stmin, u_compativ, usr1, epcpond, familia, ptoenc, stobs.u_ccopia, stobs.u_numero, u_minvend, stobs.u_unidcust, stobs.u_marketin, tabiva, stobs.u_txequipn, stobs.u_txnet, stobs.u_txecovan, stobs.u_statprod, stobs.u_prazoent, stobs.u_condent
FROM st (nolock) inner join stobs (nolock) on st.ref=stobs.ref
WHERE (u_internet ='Sim' OR u_internet ='Sempre') AND familia = '10' AND usr3 = 'Toners e Drums' AND usr4 = 'KonicaMin Compativel' AND epv1 <>0
UNION
SELECT stid, st.ref, u_desccat, langdes1, u_imgg, url, epv1, tipodesc, stock, stobs.u_stockmax, qttcat, pbruto, stmax, stmin, u_compativ, usr1, epcpond, familia, ptoenc, stobs.u_ccopia, stobs.u_numero, u_minvend, stobs.u_unidcust, stobs.u_marketin, tabiva, stobs.u_txequipn, stobs.u_txnet, stobs.u_txecovan, stobs.u_statprod, stobs.u_prazoent, stobs.u_condent
FROM st (nolock) inner join stobs (nolock) on st.ref=stobs.ref
WHERE (u_internet ='Sim' OR u_internet ='Sempre') AND stobs.u_familia2 = '10' AND stobs.u_linha2 = 'Toners e Drums' AND stobs.u_tipo2 = 'KonicaMin Compativel' AND epv1 <>0
ORDER BY epv1, st.ref ASC;
INSERT INTO #tab21
SELECT stid, st.ref, u_desccat, langdes1, u_imgg, url, epv1, tipodesc, stock, stobs.u_stockmax, qttcat, pbruto, stmax, stmin, u_compativ, usr1, epcpond, familia, ptoenc, stobs.u_ccopia, stobs.u_numero, u_minvend, stobs.u_unidcust, stobs.u_marketin, tabiva, stobs.u_txequipn, stobs.u_txnet, stobs.u_txecovan, stobs.u_statprod, stobs.u_prazoent, stobs.u_condent
FROM st (nolock) inner join stobs (nolock) on st.ref=stobs.ref
WHERE (u_internet ='Sim' OR u_internet ='Sempre') AND familia = '10' AND usr3 = 'Toners e Drums' AND usr4 = 'KonicaMin Compativel' AND epv1 =0
UNION
SELECT stid, st.ref, u_desccat, langdes1, u_imgg, url, epv1, tipodesc, stock, stobs.u_stockmax, qttcat, pbruto, stmax, stmin, u_compativ, usr1, epcpond, familia, ptoenc, stobs.u_ccopia, stobs.u_numero, u_minvend, stobs.u_unidcust, stobs.u_marketin, tabiva, stobs.u_txequipn, stobs.u_txnet, stobs.u_txecovan, stobs.u_statprod, stobs.u_prazoent, stobs.u_condent
FROM st (nolock) inner join stobs (nolock) on st.ref=stobs.ref
WHERE (u_internet ='Sim' OR u_internet ='Sempre') AND stobs.u_familia2 = '10' AND stobs.u_linha2 = 'Toners e Drums' AND stobs.u_tipo2 = 'KonicaMin Compativel' AND epv1 =0
ORDER BY epv1, st.ref ASC;
select #tab21.* from #tab21
WHERE (COALESCE(@PageIndex, @PageSize) IS NULL)
OR (RowNumber BETWEEN (@PageIndex - 1) * @PageSize + 1
AND @PageIndex * @PageSize);
)
