The total table count is for STIPS is under 1,000 It could grow to about 10,000 over 4 years

The output is a few hundred records. There are only about 10...

Thanks, I will take you up on that!

We are just finishing it this morning and our office closes at noon today.

I will be back on Monday:

Just attached both Execution Plans.

In...

OK Then, it requires an entire Select Statement for the Table in order to use the output of the table to add the next level.

Thanks

SELECT [ID_APD_Stips1], [Stip_Abv], STIP_WasaMatter +'You'...

Think I found the reason and wanted to run this up the flagpole for others to comment. Am I on the right track?

ESRI for Oracle, Shared Data:

http://support.esri.com/em/knowledgebase/techarticles/detail/35658

Cause...

Thank you for your comment.

I wanted to be sure before asking the Oracle DBA that.

Was just given a server to link to.

I found that many of the tables...

Used a script to create the Oracle Linked Server.

It provides about 8 views from the same server.

A few of the views with only numeric fields work just fine.

Can't...

SELECT * FROM OPENQUERY([PSDEC.City.CO.COM], 'Select [PrimoID_NB] from [Well.Den_Well_SHL_VW]')

Or

SELECT * FROM OPENQUERY([PSDEC.City.CO.COM], 'Select [PrimoID_NB] from [Well].[Den_Well_SHL_VW]')

Same error:

OLE DB provider "OraOLEDB.Oracle" for linked server "PSDEC.City.CO.COM"

returned message "ORA-00936:...

Beautiful!!:w00t:

Thank you so much! I read several articles on the subject. As a Newbie, this one was the most useful to me.

http://www.midnightdba.com/Jen/2010/10/tip-over-and-partition-by/#comments

This is posted for Newbies who search...

Will try that first thing Monday Morning

OVER( PARTITION BY

Would have never figured that out on my own! Thanks!

On the SQL Server View:

SELECT vWells_Standard.Area, vWells_Standard.PadNameFinal, vWells_Standard.[Well Name], ISNULL(vWells_Standard.PadNameFinal, N'zzz') AS PadNameNullSort

Thanks, that helped! This is my slight modification.

My MSAccess uses SQL Server Native Cleint 11.0 linked...

Quick followup to the random parens.

MSAccess is using the SQL Server Native Cleint 11.0 to provide linked tables.

On the MSAccess side the empty Date (that are really Characters to...

Wow, it looks so simple now! Thanks!

Sorry to take so long to get back. I inherited this table in MSAccess and migrated it to SQL Server.

Just realized that your ISNull...

Upon further Examination:

the code above calls the single records and concats them. The single record view is this:

ISNULL(dbo.APD_Stips1.Stip_Abv, N' ') + N' ' + N'(' + ISNULL(dbo.APD_Stips2.Dt_Start, N'...

Wendell is correct, take it from an Access vetern.

If you take an older copy of Access and just open it with the newer version of Access, things might apper to...

But of course!

I am still a Newbie using training wheels.

That was it, thanks!