Thanks, Magoo

It's tablix, so I don't want to introduce any new structures.

I finished making format inside sp before returning it to rdl.

like

----- formatting e.g '12345.00'...

Thansk GilaMonster,

I meant that when you use Cache is running faster, and it will continue to use it even after repeatable run.

I just want to clock the time on my...

tx ,pietlinden

I got an idea, actually it work with subreport conept, so I'm fine now

After training in query tuning and getting all time and io statistics, I confirmed that it doesn't make any sense to do this anymore, starting from SQLSERver 2008.

It's just...

and the question is answered in Perfect manner !!!

Exactly what I wanted to learn.

Tx

Thansk, Luis and all

Yes, making separate Group By solves all problems, I'll check it , I have bunch of other fields in my select which could be max or min...

Hi,

I'm trying to optimize that selection, probably there is better way to do this with any SQL function,

so value for column in question should be = SumQ1. I put my...

Thanks, Eddie

So that not mine invention;-)

It's not possible, I need to run same thing 2 times

Tx, Sean and all

Yes, I use 1 as just a litteral, and could be anything.

I'm trying to get COUNT of (DISTINCT Countries), so this value will be the same...

Here is a piece of sample code to select most recent date for order for each customer:

Tx

mario

/*

DECLARE @dd DATETIME = '2014-2-2'

SELECT * INTO #td FROM (

SELECT 100 CustID, 'Mike'...

In my case looks like we want to pick most recent item from the list for given ID,

Thanks, Koen.

Now i'm relieved and can get back to my biz people who asked us to be all on 2012 software, feel like your avatar.

Best

Mario

Thanks, Koen.

So it's the same features re SSRS development, right ?

I did all installs and see that VS2012 works fine on any VS2010 projects, without any compatibility warnings or conversions, I also could not find any differences in functionality or...