How to manipulate large data without creating temp table or using array

[veekoul]

Hi All,

I have a sql which fetches large number of records and then i use the one column value and do a select on other table in other DB. I want to do it on the fly as i dont want to use any temp file or array. Any help will be appreciatable.

Thanks,
Veekoul

[Christian Binder]

Is there anything which has to do with C#?
If not, you can use a JOIN of tables.
I don't know which SQL-engine you're using,
but in SQL-Server you can qualify tables which are in differnt databases this way:
SELECT * FROM databaseXY.dbo. Table1, databaseAB.dbo. Table2

[veekoul]

@ChBinder - I have two different DB. One is Sybase and other is SQL. So dont think Join is gonna work here.And yes the whole code is in C#.

Thanks,
Veekoul

[Christian Binder]

Okay, I understand what you wanna do.
Maybe it helps if you take a look at

http://msdn.microsoft.com/en-us/library/ms188721.aspx

and

http://msdn.microsoft.com/en-us/library/ms188427.aspx

With OpenQuery you can do queries over different database-servers.

[jkmyoung]

When you say manipulate, what are you trying to do exactly?

[veekoul]

By Manipulation i mean insert/update other table by using the data coming from the mentioned table