on 06-20-2022 9:20 PM
Boa Tarde a todos, essa query funciona bem, o problema é que quando eu tento executar no visual studio da erro, alguem sabe se exixte algum padrão de inner join de banco de dados diferentes no visual studio?
var consulta = $"SELECT DISTINCT '' as [Sel.], PV.[BillingStatus] as [Status do Faturamento], T0.[DocEntry] as [Pedido sap]," +
$" T0.[CardCode] as [COD. PN], T0.[CardName] as [CLIENTE], T0.[BPLId] as [Filial], T1.[TaxId0] as [Cnpj], T2.[OcrCode2] as [Planta]," +
$" PV.[vendor] as [Vendor Cliente], PV.[Project] as [Fase do Projeto], T0.[DocDate] as [Data Lançamento],T0.[DocDueDate] as [Dia do vencimento]," +
$" T2.[ItemCode] as [Item SAP], T2.[Dscription] as [Descrição Item SAP], T2.[Quantity] as [qtd], T2.[Price] as [Valor unitário],T2.[Usage] as [UTILIZAÇÃO SAP], " +
$" T2.[TaxCode] as [Código de imposto], T2.[CFOPCode] as [CFOP], T2.[OcrCode] as [Regra de distribuição], PV.[Opportunity] as [Contrato/oportunidade], PV.[PoNumber] as [Numero da PO]," +
$" PV.[MonthlyFeeUSD] as [Mensalidade em USD], PV.[PtaxUSD] as [Dolar PTAX], PV.[MonthlyFeeBRL] as [Mensalidade em BRL], PV.[SendUntil] as [Enviar eté:], PV.[CircuitVelocity] as [Velovidade do Circuito], PV.[Kw] as [Kw]," +
$" PV.[ProRataValue] as [Valor PRO RATA], pv.[Adjustments] as [Outros Ajustes], T0.[Email] as [Enviar Cobrança Para:], T2.[FreeTxt] as [Obs. de Abertura],T2.[FreeTxt] as [Obs. de Encerramento], PV.[InvoiceType] as [Tipo da NF]," +
$" T0.[DocTotal] as [Valor Total a Faturar] FROM SBO_DATACENT.dbo.ORDR T0 INNER JOIN SBO_DATACENT.dbo.RDR12 T1 ON T0.[DocEntry] = T1.[DocEntry] INNER JOIN SBO_DATACENT.dbo.RDR1 T2 ON T0.[DocEntry] = T2.[DocEntry] LEFT JOIN SBOApiSFDb.dbo.DCBilling as PV on PV.[OrderKey] = T0.[DocEntry] WHERE T0.[DocStatus] = 'O'";
User | Count |
---|---|
95 | |
11 | |
9 | |
5 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.