Login/Registar

Falha na ligao Base de Dados st (QUERY = ' IF OBJECT_ID('tempdb..#tab3') IS NOT NULL DROP TABLE #tab3 CREATE TABLE #tab3(RowNumber int identity, familia varchar(90), faminome varchar(254), usr3 varchar(254), usr4 varchar(254), u_ordem varchar (15), produtos varchar (50)); INSERT INTO #tab3(familia, faminome, usr3, usr4, u_ordem, produtos) SELECT DISTINCT stfami.ref, nome, st.usr3, st.usr4, u_ordem, st.ref FROM stfami INNER JOIN st ON stfami.ref=st.familia WHERE (u_internet='Sim' OR u_internet='Sempre') AND familia='90' AND st.usr3 = 'Casa e Jardim' AND st.usr4<>'' AND st.ref<>'' AND u_www=1 AND st.stns=0 ORDER BY st.ref, nome, usr3, usr4 ASC; INSERT INTO #tab3(familia, faminome, usr3, usr4, u_ordem, produtos) SELECT DISTINCT stfami.ref, nome, u_linha2, u_tipo2, u_ordem, st.ref FROM stfami INNER JOIN stobs ON stfami.ref=stobs.u_familia2 INNER JOIN st (nolock) on stobs.ref=st.ref WHERE (u_internet ='Sim' OR u_internet ='Sempre') AND u_familia2='90' AND u_linha2 = 'Casa e Jardim' AND u_tipo2 <>'' AND st.ref<>'' AND u_www=1 AND st.stns=0 ORDER BY st.ref, nome, u_linha2, u_tipo2 ASC; SELECT DISTINCT usr4 FROM #tab3 ORDER BY usr4 ASC')