Hi there!
Questions
1. Does anyone find an error in the real code (check buttom)?
2. How can I reference a query with a given name in order to simplify my code, like this:
use ventas
go
select * into bds_temp1
from (named_query)
Error:
Msg 102, Level 15, State 1, Line 29
Incorrect syntax near ')'.
Real code:
use ventas
go
select * into bds_temp1
from
(
select Country_account, Country_feature, Location, Startdeal, Enddeal, Coupon_date, Deal_ID, Merchant, Contract, Titulo, Oferta, CDA, LoB, Tipo_deal, Precio_Compra, Precio_Original, Precio_Groupon, Comision, Coupons, cash_in_USD , gross_revenue_USD, gross_bookings_USD, Vendedor_MG, Comercial, Primera_categoria_planners, Segunda_categoria_planners, Tercera_categoria_planners, SEMANA, Quarter, Deal_de_inventario, SO, Website_Slot, ...
Go to the complete details ...