I found it.

I just overwrote parameter on Report Server, in the parameters section

But then I realized it's not good enough.

What if the user searches for a keyword, runs the report...

Thanks SSCrazy.

The other contributor didn't get my point, no problem.

Maybe I wasn't clear enough.

User wants to search account descriptions by keyword

but if the result range is still large (50-60 accounts)

he...

Ignore please.

Report Manager shows local time for Seattle cos it is located at Seattle.

I'm in Toronto.

Thank you all.

Great!!

I assume this is the correct file - "SQLEXPRADV_x64_ENU.exe"

Problem solved...

This was the most complicated matter I ever dealt with.

The solution is ...

Forget about this ugly complicated Java code that builds SQL dynamically in multiple loops.

This is a very...

Thanks Lowell !

How can I do it without looping through years?

They dynamically generate column names ('Nov 2012', 'Dec 2012')

in the loop.

'Nov 2012' = Isnull((SELECT Sum(comm)

...

Thanks for response Sean.

I included all Java code.

All the logic is there.

I don't know what else I can provide.

I know it's hard to read Java code.

Basically here is how it...

I tried this

select * from IndustryMap

WHERE 1 =1

AND id_cusip = COALESCE(@cusip,id_cusip)

AND ticker = COALESCE(@ticker,ticker)

AND exch_code = COALESCE(@exchangeCode,exch_code)

and was ready to scream Hurray but realized that

when any of the columns have...

;-)Thanks a lot for your response.

I always feel a very friendly supportive environment here.

I will definetly compare performance of regular vs dynamic SQL procedures.

But later.

My goal now is to come...

My boss is a professional. He was a developer recently.

I saw some of his stored procedures - good code.

I think he has a point. A few years ago at one...

Thanks all for your response.

Gail's blog recommends using dynamic SQL

but our boss doesn't like it at all.

I have to learn how to handle it either with CASE

or IF. My problem...

Thanks for response guys !

Some more clarification.

Looks like it's a problem with this particular table.

I did [SELECT TOP 30,000 * FROM ism_secmaster_price] which is located in the same database, it...

Apparently we have a big Oops.

Out Infrustructure team (Network Admins, Hardware people)

don't know how to configure Cluster environment on Windows 2008 server...

Apparently you need to have extra IP's and...

Crazy4SQL - THANKS A LOT!

http://jmkehayias.blogspot.in is a very good source.

Straight to the point, works perfectly.

I like this kind if technical websites.