Posted by paddymullaney on 12/07/06 13:36

Hi

I have a query that is performing very strangely.

I f I put a top statement in it returns rows,

so

Select top 10 * from .......

returns 10 rows

but without it then no data is returned

Select * from ..........

returns 0 rows.

• Next in forum: Re: a simple question regarding AES
• Prev in forum: Re: FOR XML PATH + file structure
• Thread view: 'Select top 10 * ...' returns data but 'Select * ..' does not

[Reply to this message]