Chad, If i read this right, You have table A from the server, Table B Locally, you want to join the both.
Why not try something like this :
Create Table C, of what the Join would be i.e. column TableA.Column1, column TableB.Columnx
then Start in Table A, record the Value in a VAR
then Loop through each record in Table B, insertting the data into Table C
then go to next record in Table A
Or
Send the Table B as an XML, to a storeed proc, then convert to a Table, the do the cartesian join and return the final result set.
OPENXML
Microsoft SQL Server 2000 introduced a new Transact SQL function named OPENXML, a function that could be used to build a relational rowset from an XML stream. The rowset that is generated then can be used in other SQL statements. The most common application of OPENXML is inserting data from an XML document into tables in a database.
Also check out just posted not to long ago.
Thread ID:
1054507 Category: Message ID:
1054521 Title: Re: XML files
HTH
Shawn
>Kevin,
>
>I really don't think it will be possible. I'm trying to do a cartesian join (I think that's what it's called). The one where you list the table multiple times in the FROM clause without a WHERE clause so you can get the various permutations of the rows.
>
>Thanks,
>Chad
>
>>Hey, Chad,
>>
>>While it's true that ADO.NET doesn't offer full-blown SQL statements, there are filtering capabilities that *can* span multiple datatables, if a relation is set between the tables and the tables are part of the same dataset.
>>
>>You may have to write a few lines of code to do so (or if it's too complex, you may have to do it in the back-end database.
>>
>>If you're still interested in at least trying this out, can you provide some details on what you're trying to do?
>>
>>Thanks,
>>Kevin