Viewing 15 posts - 1 through 15 (of 109 total)
Couldn't it be as straightforward as this??
SELECT t.[pick your columns]
FROM SomeTable t
INNER JOIN (SELECT [ID#]
FROM...
April 3, 2024 at 3:00 pm
This is the output I get. (In fact I did a copy/paste from my post).
March 9, 2024 at 12:15 am
It's Friday afternoon and this was a nice small example. Here's my offering:
-- Create sample data
DROP TABLE IF EXISTS #Example
CREATE TABLE #Example
(DayNum INT,
...
March 8, 2024 at 11:51 pm
I've been a member of this forum for 17 years, mostly a lurker with very occasional posting or replying. I am the baby Jeff at my company. My scope isn't...
February 9, 2024 at 4:45 pm
jcelko212 32090 wrote:Have you ever read a book on RDBMS?
You can explain things without being such an absolute condescending asshole, Joe!
Actually no, no he cannot. I blocked him years ago...
February 6, 2024 at 3:49 pm
You may have already found your solution, but here's how I have it configured in one of my reports. I've obfuscated some names. In my case, the report is under...
December 21, 2023 at 5:14 pm
This might be a long shot, but see if this query gives you any insight. If the subscription is complaining about the parameters, then it's possible it won't even get...
December 1, 2023 at 8:15 pm
Old post... but wanted to add my screenshot with similar behavior. Job has 2 steps. Each were 1 second in duration, but Step 2 started 20 seconds after Step 1. ...
October 24, 2023 at 5:50 pm
I can help you with the new window. You just need _blank:
="javascript:void(window.open('http://east-rpdb01/reports/report/Testing/Profitability%20Report%20All%20Clients&FiscalYear=" & Fields!FiscalYear.Value & "','_blank'))"
Per this link:
They show this format for multiple parameters:
https://myrshost/ReportServer?/AdventureWorks 2008R2/Employee_Sales_Summary_2008R2&ReportMonth=3&ReportYear=2008
But based on...
April 19, 2023 at 4:38 pm
Hmmm... I'd say "new normal". Our CEO thought we should come back 5 days a week in mid 2021. Needless to say, didn't go over well. We now have a...
March 10, 2023 at 11:32 pm
Yes, I like that Drew! Thank you!
March 9, 2023 at 3:47 pm
Argh! Yes! I knew I need to group (grp_cte) but couldn't figure it out for the life of me.
Thanks!
March 8, 2023 at 11:47 pm
I do this kind of thing all the time using a crosstab. There is a range of date differences so I put it into buckets. This is merely a jumping...
July 29, 2022 at 3:58 pm
I just had to do this for the first time myself and had a little trouble but got it working this morning. Here's a high level:
I'm assuming you have a...
March 23, 2022 at 5:41 pm
Thanks for following up with how you solved this!
February 2, 2022 at 9:48 pm
Viewing 15 posts - 1 through 15 (of 109 total)