Viewing 15 posts - 3,661 through 3,675 (of 59,067 total)
Total agreement with all of you. Thanks for the comments.
Thanks for the article and your comments, as well.
April 3, 2022 at 5:37 pm
This does the trick for me.
WITH cteByDB AS
(--==== Preaggregate that data including a grand total using ROLLUP and marking that total row with GROUPING_ID.
...
April 3, 2022 at 4:21 am
All those NULLs and Blanks that you're joining on? Yeah... guess what they're doing? MASSIVE accidental CROSS JOIN which is more politely called "many-too-many" join just on those alone.
Second, are...
April 3, 2022 at 1:45 am
I love having a choice for all the reasons that both sides have stated both as a presenter and as an attendee. It's the best of both worlds.
April 3, 2022 at 12:46 am
Thank you. It appears that Full Text Indexes have been available on Azure since 2015 so that's not the issue. The probable issue is that all software on Azure is...
April 3, 2022 at 12:09 am
The use of the SUM(OVER) Windowing function should do it for you.
I also have to ask... why to you need a "running total" for this? Are you actually looking for...
April 2, 2022 at 10:23 pm
I don't know much about the language used in SSRS but why wouldn't you just find the position of the colon, add 1 to that, and use that as the...
April 2, 2022 at 10:19 pm
I don't know about your issue but I am interested in the "requirements". Which cloud are you moving to and are you having to remove full-text indexing because they don't...
April 2, 2022 at 10:15 pm
pietlinden wrote:Oh, okay, Gotcha. Something like this?
select backup_path
, LEFT(backup_path,CHARINDEX('\FULL\',backup_path,1) + LEN('FULL\'))
from #tbl_backup_path;Thank you working perfect.
Do you understand how and why it works?
April 2, 2022 at 5:16 pm
Sorry for the dumb question in advance. So I just bought a SQL 2014 standard license from a vendor, but noticed that the product key can be looked up...
April 2, 2022 at 5:07 pm
It would be helpful if you'd post the CREATE TABLE statement and a few rows of data in an INSERT/VALUES fashion. We also need to know what day of the...
April 2, 2022 at 4:28 pm
I'll remind you that 1) it's not my site and 2) it's not my site. 😉
It is, however, your contention this is easy...
'Nuff said and understood. My apologies.
April 2, 2022 at 4:20 pm
SPAM is a problem now, and it's not a simple one. I've filed a ticket to work with the third party on what is not...
April 1, 2022 at 4:34 pm
With the understanding that I don't use Analysis Services, can you use T-SQL in SSAS? There are some very fast methods for calculating MEDIAN in T-SQL.
You can query...
April 1, 2022 at 4:30 pm
Viewing 15 posts - 3,661 through 3,675 (of 59,067 total)