Issue with SQL query. Token Eof expected.

[Anonymous]

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?

[Mahesh0016]

@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]

Thanks, but that just returned the code: