Viewing 15 posts - 4,816 through 4,830 (of 18,926 total)
What about the other 2 columns I asked for?
July 19, 2011 at 10:10 am
add 3 columns and put those values as the source :
PREVIOUS(Fields!new_name.Value)
Fields!new_name.Value
RUNNINGVALUE(1, SUM, NOTHING)
July 19, 2011 at 9:54 am
Why don't you add 3-4 columns in there and put all the previous,current, runningcount info so I can see what's going on?
July 19, 2011 at 9:49 am
Well it's the 3rd or 4th question about this query already so I guess full optimisation is the next one in the pipe!
July 19, 2011 at 9:44 am
Why don't you simply put a page break at the end of each group? That would solve your issue.
July 19, 2011 at 9:34 am
GilaMonster (7/19/2011)
Ninja's_RGR'us (7/19/2011)
Also the estimated # of rows returned must be really low (% of whole table) for the seek to be used as the plan.
Unless the index is covering....
July 19, 2011 at 9:32 am
SSH (7/19/2011)
Did you use a ADP? I've read conflicting sources around using them.
Also, the reason of not impementing the whole...
July 19, 2011 at 9:31 am
Send them the link I sent you a minutes ago. It's all CLEARLY explained.
July 19, 2011 at 9:19 am
That's why I said to DISPLAY the values on the reports to even see if it was possible to do it using those functions.
A simple report run will give you...
July 19, 2011 at 9:18 am
Jules Bonnot (7/19/2011)
Does anyone how unique this is? How many times I would have to run it before I found a duplicate.
select ABS(CAST(CAST((newid()) AS VARBINARY(5)) AS Bigint))
Create a table with...
July 19, 2011 at 9:17 am
This does the job for me in the visibily / hidden option ;
=IIF(1=1, False,True) (hidden = false => visible)
July 19, 2011 at 9:08 am
This is a decent setup. The only limits you'll have is the 10 GB database max size 1 CPU and 1 GB of ram (used by the server).
I've had...
July 19, 2011 at 9:03 am
keyun (7/19/2011)
Interesting,,Never thought about that way shrinking log and mdf.Let me work around and see what i can accomplish by going into that direction....
Ya but keep in mind that restore...
July 19, 2011 at 8:41 am
A seek cannot be done without a where clause. It's just the way ot has to be.
Once that's decided, the server starts counting once it finds the rows that...
July 19, 2011 at 8:40 am
It's not the same query.
The first one filters out more rows. While doing the seek, it can also count.
Also the estimated # of rows returned must be really low...
July 19, 2011 at 8:24 am
Viewing 15 posts - 4,816 through 4,830 (of 18,926 total)