N
news
I have to join datasets, what is the quickest way?
eg
ds1 = [1,2,3,4,5]
ds2=[4,5,8,9,20]
jds = [4,5];
ie the data common to ds1 and ds2 is inserted into jds..
I know I can loop ds1 and test but this will be slow, and I am wondering if
it is better to create a stored procedure which checks, or insert into temp
tables and then check with an SQL query, eg a join
I am using two datasets as an example but it can be several.
eg
ds1 = [1,2,3,4,5]
ds2=[4,5,8,9,20]
jds = [4,5];
ie the data common to ds1 and ds2 is inserted into jds..
I know I can loop ds1 and test but this will be slow, and I am wondering if
it is better to create a stored procedure which checks, or insert into temp
tables and then check with an SQL query, eg a join
I am using two datasets as an example but it can be several.