Yes, I am getting the following error:

(2533 row(s) affected)

Msg 121, Level 15, State 1, Procedure GEARSAnalysisReportsGIS2, Line 545

The select list for the INSERT statement contains more items than the insert...

Only one column which is Year

Also, when I compile the proc , it takes long time. Is it pretty normal; I haven't seen this

before.

I am curious about the following logical reads being high ; is this considered high ...??

#carsdata___________________________________________________________________________________________________________000000001AE6'. Scan count 1, logical reads 9313, physical reads 0, read-ahead reads 0, lob logical...

wow!!significant difference...cut down to 1/3 of the original time; here is the statistics

Table 'GEARSRouteList'. Scan count 1, logical reads 2, physical reads 0, read-ahead reads 0, lob logical reads...

Bingo...it worked like this: EDWGEARS..FRED_SCH.VW_FRED_AADT_HIST ; I used schema instead of user

Thanks so much!

I am getting the following error when using with oracle user :

The object name 'EDWGEARS...ORAUSER.VW_FRED_AADT_HIST' contains more than the maximum number of prefixes. The maximum is 3

I am getting the error "does not contain the table or user doesn't have permission on that table or view when I am querying like this: EDWGEARS...VW_FRED_AADT_HIST.

But its is...

Thanks Lowell; I am redesigning the proc with the set based query; I will let you guys know how the performance is working out.

Thanks

Aj

Yes, I did run SET STATISTICS IO ON

which read should I look for, logical reads vs physical reads , I know more logical reads are better;

attached is my statistics....

Hi Lowell,

I am not sure I was able to make any sense in earlier post about how to get the BeginMeasure

and EndMeasure in the set based operation without using cursors....

Yes, you are absolutely right, I will take out the cursor. But my dilemma is the BeginMeasure and EndMeasure are storing in the #RptParms table which are not coming from...

But in the following query the @BegMeasure and @EndMeasure is in #RptParms tables; in this case if I dont use the cursor loop,then don't I have to retrieve this...

Hi Lowell,

This VW_FRED_AADT_HIST is in oracle connecting thru linkserver edwgears; this view has about

146,000 rows

Thanks

Hey I just realized that in my execution plan XML Reader XPath filter is showing 99% cost which value I am passing the procs as the years as an...