Hi,
I have a Query that has the instruction ORDER BY inside the SELECT, for example:
SELECT
dbo.Query_Base.Cuentas_Maestro_Numero_cuenta,
dbo.Query_Base.Cuentas_Maestro_Profit_Center,
dbo.Query_Base.Trading_Partner,
dbo.Query_Base.Partner_Profit_Ctr,
dbo.Query_Base.Cuentas_MaestroTransType,
dbo.Query_Base.profit_center_local_currency,
,sum(dbo.Query_Base.profit_center_local_currency)
OVER (PARTITION BY Query_Base.Cuentas_Maestro_Numero_cuenta,Query_Base.Fiscal_Year-Query_Base.Cuentas_Maestro_Numero_cuenta,Query_Base.Fiscal_Year,Query_Base.Period
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS Change_SAP,
ETC ETC ,
and a FINAL ORDER BY clause too..so i can not to convert this Query in a VIEW because this one it not allows this clause on it..and i need this View to create a .CSV file from it.
Any suggestion??
Thanks..