Hard to answer your question with no code to see or anything, but I suspect your ALL is causing you issues in your code if you use an IN clause....

Yep, good question, learned something today and I answered the question AFTER getting my coffee.

Well I have been in IT for more than 20+ years now, mostly C, C++ and Java. Only in past 5 years or so did I get a position where...

After a while now you'd think I would have learned! I guess not. I am sure like others that missed this question was the fact that I read...

http://technet.microsoft.com/en-us/library/aa337401(v=SQL.105).aspx

Our company is doing the exact same thing over the next week or 2. Converting from SSRS 2005 to 2012. So, I am curious if there are other...

Oracle code uses: "rownum < 100". It does not use TOP command.

Ex: Select * from 'table1' where rownum < 100;

Yep, you need to check your query:

WHERE

.

.

AND (Shop.ShopAddressID IN (@ShopID)

.

.

http://msdn.microsoft.com/en-us/library/dd220464.aspx

http://www.sql-server-performance.com/2007/report-parameters/

Hmm, that is interesting.... I will have to play with this myself..

Nope, I don't think you can do anything like this in SSRS (of course I am only using 2005 version). A report is just that a report, you will...

There is a FixedHeader property in the Layout. Select the 2 columns, select properties, set fixedHeader to True. Then those 2 coulmns will remain as the other columns...

Love having 2 monitors. However, in my case, my company only provides 14" laptop which stinks. But I have a 27" second monitor. So yes, I love 2...

I found the answer is 8 looking here: http://sqlmag.com/database-high-availability/changes-sql-server-2014-alwayson-availability-groups.

My company does not use Date Dimension or Calendar tables, our solution to this kind of thing is similar to aar.mba.

select