Sure,

SET ROWCOUNT 10

--Followed by SQL squery...the query execution will stop once 10 records are scanned

The in-memory representation will contain every record from the tabel and then display only TOP N records.This is how TOP works.

Still would advice to use @@ROWCOUNT to avoid un-necessary records...

Hi,

I have a question to ask.

Is MS-SQL certification required to qualify for MS-BI Certification as a prerequisite.

I wish to pursue a MS-BI certification.

Good question,

What I understand is as below:

I would have have created a linked server (Server Object) and use a fully qualified name to execute my dynamic SQL query.

Hi,

Can you please explain it in detail....

The idea is not clear.

Regards/Raunak

Yes it helped...trying to customize more...

Thanks a lot

it's done...changed the query and used IN function with allow multiple values in parameter options

hi

I'll surely try.

But when executing in BIDS the report shows relative error of syntax and not when deployed.