Viewing 15 posts - 106 through 120 (of 152 total)
I'll come at theis from a more 'plain language' point of view.
SSAS is great for producing highly flexible information for reasonably technical users. Financial Analysts for example. These...
July 6, 2012 at 5:34 am
Effectively you are setting the default for P3 to be an empty string.
Now that's some good lateral thinking and will probably resolve my issue 😀
the report will go ahead...
July 6, 2012 at 2:13 am
It's still supported and probably always will be since it's made up of the most basic elements of sql (tables and where clauses). To stop supporting it would mean...
July 5, 2012 at 4:34 am
Right, Here you go. Here's a dummy report that exhibits the problem. (Why didn't I just do this in the first place:doze:)
I've had to change the file extension...
July 5, 2012 at 2:39 am
I'm using 2008 R2 and using Visual Studio 2008 as in IDE.
One thing that occurs to me, is it possible to upload rdl's as attachments? I don't see it...
July 5, 2012 at 2:12 am
To get data from T1 that's not in T2 try:-
Select *
From T1
Left Join T2
ON T1.C1 = T2.C1
AND T1.C2 = T2.C2
Where T2.C1 IS NULL
to go...
July 4, 2012 at 4:56 am
Hi Daviscollective and thanks for a useful reply
Just to respond to a couple of your suggestions up front:-
I'm wondering why this is a problem because you've already stumbled on the...
July 4, 2012 at 2:23 am
I think I'd agree with the above. Leaving the keys in place might make the migration a bit more of a pain because it'll thrw up any data integrity...
July 3, 2012 at 3:27 am
as it's a wrong syntax for EXISTS
Yep, that's why I said you couldn't do it.
Look, we're arguing semantics and really not helping the OP at all.
June 22, 2012 at 7:08 am
Well, that's a query within a query... so I'd call it a sub-query.
The point I was making making was that you couldn't do something like:-
Select * From MyTable...
June 21, 2012 at 12:56 pm
Whenever I've tried a comparison (which is admittedly only on half a dozen occasions and not in any particularly scientific way) I get an identical execution plan. I've never been...
June 21, 2012 at 4:07 am
In the other tablix where you only want to see specfic subtype, can you not change the grouping on that tablix to group by type and subtype1, then do a...
June 8, 2012 at 2:29 am
Sorry, I obviously wasn't very clear. The sql query is going to have to return me all the data, regardless of SubType1, because it is all used elsewhere in...
June 7, 2012 at 11:23 am
It's not the sub-query that's your problem, it's mixing variable assignment with returning a result set.
You can do this:-
Select MyField From MyTable
Or This:-
Select @MyVar = MyField From MyTable (as long...
June 7, 2012 at 6:32 am
Hmm, that might be worth a punt. I'm away from work until Wednesday but I'll definiely give this a try. Nice lateral thinking:cool:
June 1, 2012 at 8:20 am
Viewing 15 posts - 106 through 120 (of 152 total)