CI3 error with query SQLSERVER

@Y6700B,

Thx for the reformat.  I have one suggestion and 1 question.

Suggestion: If you are not expecting a dynamic variable to be a part of the query then why not make your query a database VIEW within MSSQL Server and then call the view.

Question: what error message are you seeing when you run it in CI?

Suggestion: The function is dinamyc only for the example I didnot set variables.
Question: There´s no error message the only think is the function from de model doesnt return all info and return an empty array.