Hi doug,

[edit]Alright, take 2

I did not find a way to take advantage of the Duration column.

Please be warned that this query will most probably not perform very well on bigger...

A MIN() and a GROUP BY should do the work, something like

Select DISTINCT

MIN(pur.InPurchaseId)

pur.StNotes,

...

It's probably faster for SQL to scan the entire table than scanning the index + bookmark lookup...

Is it a big table?

Have you tried creating a covering index?

select column from table where len(column) > 6

That should do it!

Hi dbate,

Would it be possible to create a stored procedure on the Pervasive server and call that through your linked server?

Hi again!

I read over again and I'm not why I made that assumption... :hehe:

Now that I finally understand the specifications...

In the DTS wouldn't you just need two OLE connection and...

Different execution plan

Hi samartel,

- no linked server

- no modification to existing DTS

- no new package (DTS, SSIS)...

- process must be run prior to sending data from STAGING to DW

To...

Hello arun,

Are you familiar with the CTE (common table expression) syntax as well as the Row_Number() function? Used together they work very well from requirements like yours:

;WITH tblRowNumbered

as

(

Select

Row_number() Over...

Hi Arun,

For the SP_OA procedure you first need to see if that even applies to you. Chances are you don't even have any in your code, at least let's hope...

Did they ever fix the memory leak with sp_OA? It seems even if you...

Hi Mike,

I don't mean to be mr Obvious here but does your domain/login have permission to PA_Rev.dbo.Joblist ?

You never know it's friday and ... 😛

[edit] grammar...

Hi Colin

Thanks for responding 🙂

Very good work around! :w00t:

It's now more of a challenged to find an explanation (known bug or BOL article or...) why it throws an error in...

To run a distributed query on 2000 and/or 2005 I am fairly sure using a linked server is your only option.

I could be wrong, maybe someone more knowledgeable could help...

Alright now that I understand what is being done let's see what we are trying to do. Bear with me I need very clear specifications before I can compute anything!...