Subselect in sa_split_list

[#1]

When I try:

select line_num, row_value as cc_test FROM sa_split_list( (select top 1 start at 3 substr(cc_txt,12) FROM tblCategory), ';' ) where line_num = 1;

I get syntax error near ','. Why

[VolkerBarth]

Are you using version 12 or below?

In those versions a procedure does not accept subqueries as argument, such as your "(select top...)".

With v16, that was changed, and your query should work here.

In v12, you could use a derived query to get the top result and then use CROSS APPLY to provide the result as argument to the procedure. The forum does contain such samples, search for APPLY or LATERAL...

[Former Member]

I am using SA12. Can you show me how I use Cross Apply in this case? I have searched but do not understand how to do. I found an openstring solution, but it had its limitations as well.