Openquery with a sub-sql referening sqlserver table.

Hello.
I need to do a openquery to a linked server, and get record with id no in a sub select pointing to a table stored in SQLServer.
I have something like this:

select * into tmptable
from openquery (select * from linkedserverTable where id not in (select distinct(id) from sqlserverTable))

How to make sqserverTable not pointing to linked server, but sqlserver ?

Rgds

JCselect *
into tmptable
from openquery (linkedserver,'select * from linkedserverTable')
where id not in (select distinct id from sqlserverTable)

open the uploaded documents

Hi,

I have the requirements to add the attachment, so i am saving the documents in sqlserver.

now i am facing the problem with openning the document.

can any body suggest me how to open the documents which are stored in sql server

Try this:

byte[] file = table.row.fileField;

Response.AddHeader(

"Content-Disposition","inline; filename=\"nameOfTheFile");

Response.BinaryWrite(file);

Response.End

|||

Try this:

byte[] file = table.row.fileField;

Response.AddHeader(

"Content-Disposition","inline; filename=\"nameOfTheFile");

Response.BinaryWrite(file);

Response.End

|||

Try this:

byte[] file = table.row.fileField;

Response.AddHeader(

"Content-Disposition","inline; filename=\"nameOfTheFile");

Response.BinaryWrite(file);

Response.End

|||

Try this:

byte[] file = table.row.fileField;

Response.AddHeader(

"Content-Disposition","inline; filename=\"nameOfTheFile");

Response.BinaryWrite(file);

Response.End