I have been tasked to rewrite an old stored proc to work with a new DB schema and going though the old proc to try to understand what it does I ran across an insert statement I had not seen before.
select cast(text as int)
from fn_spr_parse_string(@LocaleMulti, ',')
I know it is inserting into the varable @LocaleList (which is a temp table with a single coluimn called LocalID of INT). What I can't figure out is why there is only a cast statement in the select and what the fn_spr_parse_string is (hidden proc maybe?) @LocaleMulti is a comma sperated list that is feed into the extisting proc.
I am kind of thinking by some maject it is just splitting the @LocaleMulti based off ',' but I am not 100% on that or how it would be doing so if it is.
If I get used to envying others...
Those things about my self I pride will slowly fade away.