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_s...
Need Help
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: