So using SP makes me think of how to change the parameters, but thats the last step to perform. (Just click the link you 'Basic Sale Price')Īnd it returns a comma separated string and this is what the whole story about.Īnd the reason, i said, i cant use stored procedure is because i want to change the parameters of the procedure, as and when the group value is changed. Yet then again it would be better of that function returned a set of values and not a comma-separated lists.Įrland Sommarskog, SQL Server MVP, for SQL Server Books Online: You can find several list_to_table functions on my web site: Select CASE WHEN ParameterDescription LIKE '%RATE%' THEN ParameterValue END as ParameterDescription On the other hand, looking at your code, I can't see any need for dynamic SQL at all. Granted, we still use Crystal 8.5, but I don't think have removed such an essential feature. I know, we have Crystal in the system I work with, and it's stored procedure calls all over the place. On the other hand, you can use stored procedures in Crystal. ![]() ![]() Trying to work against that, is as constructive as banging your head to a wall. You cannot use dynamic SQL in functions in SQL Server. You cannot call stored procedures from functions in SQL Server. I can not use stored procedure as i have to use that function in crystal reports.
0 Comments
Leave a Reply. |