Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Issue with SQL query. Token Eof expected.

Hi, 

 

I cannot get this to work:

= Sql.Database("10.136.20.144", "MetechSupport", [Query="EXECUTE [DBO].[q_nn_get_serviceorder_v2] @c_status='"& status &"', @c_foretagkod='"& foretagkod &"', @c_startDate='"& startDate &"', @c_stopDate='"& endDate &"'", CreateNavigationProperties=false, CommandTimeout=#duration(0, 0, 10, 0)]),

 

I have parameters for the query. 

Any ideas?

 

Need Help

2 Replies

  • Mahesh0016's avatar
    Mahesh0016
    Super User
    3 years ago

    Anonymous  Please Copy Below Code and Use in your Query.

     

    let
    Source = "let#(cr)#(lf)Source = Sql.Database(""10.136.20.144"", ""MetechSupport"", [Query=""EXECUTE [DBO].[q_nn_get_serviceorder_v2] @c_status='""& status &""', @c_foretagkod='""& foretagkod &""', @c_startDate='""& startDate &""', @c_stopDate='""& endDate &""'"", CreateNavigationProperties=false, CommandTimeout=#duration(0, 0, 10, 0)])"
    in
    Source

    Anonymous If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thanks, but that just returned the code: