Ya like for a homepage... if you were to count out the owner's visit, there would be very little need for the counter .

Agreed. I also support this site, but I don't see much of the money that comes in every month .

Yeah right nothing's changed, I swear .

That's what I said.  You can't do that without running it.  Maybe you can do a general table with 100 varchar columns and insert into that... but that won't come...

We can't really help unless you provide some sample data and the required output.  Once we have that we can get started on a solution.

Do you guys have extacly the same databses on both servers?

Did you try dropping the executions plans and rerunning.

Does it do that on every execution or is is bad only...

Select Main.* FROM dbo.Tbl Main INNER JOIN (SELECT SSN, MAX(Date) AS Date from dbo.Tbl GROUP BY SSN) dtLast ON Main.SSN = dtLast.SSN AND Main.Date = dtLast.Date

No you can't do that... because the sp can have more than 1 result set at the same time, also it can have different results set at each run.

The only...

Tried the old compact/repair?

What happens if you copy those tables to a new access DB and rerun the query?

Last resort.... tried recompiling the application?

Yes, different OS use different row delimiter.  IIRC unix use char(10).  While windows uses Char(10) + Char(13).  Some other might use Char(13) only.

Just paste the char(10) from the clipboard and...

Search the articles on this site.. you'll find quite a few.

There's your answer...

(rptPXA2.DCode) = 1

==

Char(9) = int

===

see rest of my previous explanation for the error.

Once you try with '1' it'll work.

Good afternoon.

I guess that if you build the whole string in dynamic sql, it'll work then using something like this.

...

'rowdelimiter = ''' + char(10 + '\n'''

Maybe there's another way but I...

I see at least 10 converts in your execution plan.  So the server obviously thinks otherwise.

BTW varchar(9) <> nvarchar(9) <> [n]char(9).

Is there any collations differences between the tables or between...

You'd be better off to use IF EXISTS.  It'll return true or false instead of the row count.  On small table it's not a big problem but those things add...