I got it now.

I wanted to join a table with a function - the one that consumes jSon

I did it with a cross apply.. 🙂

I want to have that table with a relational id to the row where the jason string belongs

If I have a table with many fields and only one has Json format..

I could use the function in order to consume the Json format- I would need...

u got a point there

Buuuut.. if u r working with a looong sp.. u might want to avoid writting try catch.. bla .. 1 million times 🙂

Why creating the tables.. sometimes you just do your temptable like this:

select distinct CONVERT(nvarchar(30), (KO.a)) AS a,

CONVERT(nvarchar(30), (KO.b)) AS b,

Navn AS Name

into#MyTempTable

fromTable 1KO

INNER JOINTable 2KU

ONKO.NR =...

I so very agree