Viewing 15 posts - 2,011 through 2,025 (of 3,507 total)
Sounds like you need a Calendar table. Then you can link that to your data table and then group by the Calendar columns. There's a handy Calendar table...
March 29, 2016 at 8:37 pm
Sounds like you can get the answer by using a cross join and then an EXCEPT or an outer join... but one question first...
Do your tables have primary (unique) keys?...
March 29, 2016 at 6:12 pm
In an ssrs 2008 report, I would like to add logic that looks the following for determining if a row is visible or not.
If you want rows to now show...
March 29, 2016 at 4:44 pm
Can't you just use Interactive Sorting? (I am pretty sure it's in SSRS 2008, but I haven't used 2008 in a long time, esp. R1)
Right-click on column header row (with...
March 29, 2016 at 3:53 pm
If you can, buy a copy of SQL Server Developer. It costs about $60 US, which is an absolute steal. While there is a cap on the size of...
March 29, 2016 at 2:35 pm
I would start by reading Kendra Little's article, which is here[/url].
You might use the WITH RECOMPILE hint to force the generation of a new execution plan, but read her article...
March 29, 2016 at 2:05 pm
"I have a model with two fact tables. There's a one to many relationship between them."
Begging your pardon, but shouldn't the two fact tables just share common dimensions? I don't...
March 29, 2016 at 11:25 am
So what was your question?
From the looks of it, you have a typo... or several. You can use joins, but your SQL has some typos.
customers <> custimers
orders <> order
SELECT...
March 28, 2016 at 5:18 pm
Apologies if I'm repeating myself. Here's one way of exploring what your best options are...
Since your target users are already Excel folks, either PowerPivot or PowerBI sounds like the...
March 28, 2016 at 4:51 pm
... that way I can tell my boss that second monitor really is required!
March 24, 2016 at 3:01 pm
You could always restore a read-only copy of your database and let your users connect to that... then at least the two databases would be separate... if you ran a...
March 23, 2016 at 3:40 pm
What if you change the formatting to some kind of decimal? If SSRS is rounding behind the scenes and the numbers are less than .5, then they may be rounding...
March 23, 2016 at 1:06 pm
Young Jedi,
A LEFT/RIGHT/OUTER join is "lossless". In other words, you'll get NULLs propagated on the "outside" table if you use an outer join. It's the way outer joins are...
March 23, 2016 at 12:38 pm
There are several options...
If they're already good at Excel, you might try either PowerPivot or PowerBI Desktop. I would lean toward PowerBI Desktop. If you have something like...
March 23, 2016 at 9:23 am
Viewing 15 posts - 2,011 through 2,025 (of 3,507 total)