Forum Discussion

redexecutive's avatar
redexecutive
New Member
8 years ago
Solved

Stored Procedure parameters with dates

Really I don´t know how to manage this, I am trying to use a simple stored procedure (for now) with 2-date parameters.   CREATE PROC usp_Sel_Reporte_Indicadores @dtFechaIni DATE = NULL, @dtFechaFin...
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi redexecutive,

     

    I have confirmed this issue from PG.  Actually, this is another limitation of DirectQuery that does not permit to use a store procedure.

    Only queries with the form Select … From … Where … are allowed.

     

    Best Regards,

    Jimmmy

Anonymous's avatar
Anonymous
Not applicable
8 years ago

What happens if you change the date format from "yyyyMMdd" to "yyyy-MM-dd" ?

  • redexecutive's avatar
    redexecutive
    New Member
    8 years ago

    Hi:

    Thanks for answer but throws this error

    "Expression.Error: This native database query isn't currently supported."