Viewing 7 posts - 1 through 7 (of 7 total)
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.. 🙂
October 8, 2012 at 4:48 am
#1546636
I want to have that table with a relational id to the row where the jason string belongs
October 6, 2012 at 5:06 am
#1546402
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...
October 5, 2012 at 7:26 am
#1546065
u got a point there
August 10, 2011 at 8:22 am
#1366589
Buuuut.. if u r working with a looong sp.. u might want to avoid writting try catch.. bla .. 1 million times 🙂
August 10, 2011 at 7:47 am
#1366555
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
from Table 1 KO
INNER JOIN Table 2 KU
ON KO.NR =...
August 10, 2011 at 7:17 am
#1366530
I so very agree
August 30, 2010 at 3:45 am
#1213641