Something like this?

SELECT Table1ID1.targetInformation AS  target1,Table1ID2.targetInformation AS target2

FROM Table2 LEFT JOIN Table1 Table1ID1 ON table2.ID1=Table1ID1.ID /*fill with NULL if not present in table1*/

LEFT JOIN Table1 Table1ID2 ON table2.ID2=Table1ID2.ID

ORDER BY Table2.ID

At the linked server properties

you can set how your account will be "transferred" across the network to the linked server.

Perhaps you can try with using the current login security context...

some in the role db_securityadmin can assign execute permission.

Welcome

the syntax is

EXECUTE mylinkedserver.myremotedatabase.myremoteobjectowner.USP_MYREMOTESTOREDPROCEDURE @param1=....

CREATE STORED PROCEDURE dbo.USP_CLASSTRACK_PIVOT_QUARTER

AS

SET NOCOUNT ON

SELECT classcode,

    SUM(CASE Quarter WHEN 'winter' THEN Amount ELSE 0 END) AS 'Count Winter',

    SUM(CASE Quarter WHEN 'spring' THEN Amount ELSE 0 END) AS 'Count...

where did you declare  rstStoredProc ?

you can test if rstStoredProc exist with

if not(rstStoredProc is nothing)

*move

' Spit out our data which I pull out of the recordset.

'Response.Write Trim(rstStoredProc("Supervisors"))

'Response.Write " "

'Response.Write...

for update you need to specify the update command also

see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatacommondataadapterclassupdatetopic.asp

for the microsoft help on dataadapter.update

Perhaps to save on the amount of I/O that has to be done to reclaim the unused space.

New records will be probably created using the new size.

what level of severity does the error have?