How do I use the function that was created in the SQL server and use it in my SSRS SQL select statement when I am using text in SSRS Dataset properties as text from Query Type? I am getting errors and am not able to complete the process.
SELECT FunctionGetID(a.column,b.Column) AS ID
FROM TableA a
JOIN TableB b ON a.Column = b.Column