Viewing 15 posts - 2,476 through 2,490 (of 3,480 total)
Jason,
If you have a local SQL Server User Group, I would definitely talk to people there - both recruiters and other developers/DBAs. What usually happens to the groups i...
June 8, 2015 at 4:58 pm
That's not the kosher way of posting expected results, but anyway... here's the answer:
SELECT Component
, [Opening Balance]
, [M/O Qty Req,d (MWOMAT)]
, [Opening Balance] - ABS(SUM([M/O Qty Req,d (MWOMAT)]) OVER (PARTITION...
June 7, 2015 at 9:51 pm
Do you need to display all the subtypes at once? Otherwise, you could use add an action to each of the bars of the chart that would basically drill into...
June 4, 2015 at 9:54 pm
Looks like you're looking for REPLICATE.
June 3, 2015 at 12:06 pm
The table doesn't exist for the rest of us, though. That's why you post it. To get tested code.
What 5 records are you trying to return? You never...
June 3, 2015 at 12:04 pm
Welcome to SSC. Since you're new, I'll fix up your post to show you a way to do it that will make the job of those trying to help...
June 3, 2015 at 11:26 am
What I ideally want it to do is if I run the report today (May) it will only show me the last 12 months so May to May.
Why not add...
June 2, 2015 at 10:32 pm
Bummer!
PowerBI is kinda cool, but there are some things that are head scratchers for me. In SQL Server (and SSRS), parameterized stored procedures are your friend. In PowerBI,...
June 2, 2015 at 6:17 pm
Jason Selburg's article maybe?
http://www.sqlservercentral.com/scripts/Miscellaneous/31733/
June 2, 2015 at 9:33 am
the answer was here the whole time... all you had to do was search for it.
June 1, 2015 at 9:03 pm
Okay, you've been here a while... Do you REALLY need to crosspost?
June 1, 2015 at 4:41 pm
CTEs require that the statement before the CTE is terminated with a semi-colon, so one is generally added in front of the definition of the CTE. Kinda weird, but there...
June 1, 2015 at 11:55 am
That's what happens when you sleepcode... you do silly things. For some reason I totally forgot about ABS()...
June 1, 2015 at 11:51 am
Not a very helpful article. A really helpful article would have gone something like...
Here are some places where you might consider a cursor...
Here are places where you just...
June 1, 2015 at 11:20 am
Oh, if you're doing this as an HTML file, you can use the last-child pseudoclass to format the last row of a table.
May 31, 2015 at 10:43 pm
Viewing 15 posts - 2,476 through 2,490 (of 3,480 total)