Viewing 15 posts - 781 through 795 (of 3,480 total)
A little normalization is a beautiful thing. Your problem is that your table fails the 1NF test, so you have to use DelimitedSplit8K to break up that delimited string into...
February 24, 2020 at 10:41 pm
If you're adding one column to another, like [column A] + [column B], you can use
CASE WHEN [some column] = 0 THEN <true part> ELSE <false part> END
where the True...
February 24, 2020 at 8:59 pm
Oh, okay. I'll try it out. Thanks, Phil!
February 24, 2020 at 8:06 pm
Did you try using the old cardinality estimator?
Check out this article by Pinal Dave.
February 24, 2020 at 3:43 am
Drop a Tablix onto the report canvas, add the EmployeeID, group by it, and put a page break between instances. Then put the other report inside it as a subreport...
February 22, 2020 at 10:16 am
Seems like you should be able to join the (AdmitDate, DischargeDate) to a Calendar table to expand the date range to a set of dates, and then group by EHRClientFK....
February 22, 2020 at 9:14 am
Wow. I'm way to lazy to write all that.
Setup:
use tempdb;
go
Create Table Vendor (
VendorId BIGINT IDENTITY(1,1) NOT NULL
, VendorName varchar(256)
);
Create Table Visits (
VisitID BIGINT IDENTITY(1,1) NOT NULL
, VendorId...
February 22, 2020 at 1:31 am
What's the structure of tmpDeal01? And where does it get its data? There's not enough detail here to figure out the problem, I don't think. Got some sample data -...
February 21, 2020 at 10:21 pm
Could you clarify what this means "I have written a query, but its not working as desired."? What is the output you got and what was the output you expected?
How...
February 21, 2020 at 8:42 pm
Don't think you can use UNPIVOT then either. Not sure if this will work, because 2019 doesn't allow a compatibility level to 2005. Maybe this works?
SELECT AccountID
,...
February 20, 2020 at 3:52 pm
2019.
You can change the compatibility level if you want to, though.
February 20, 2020 at 7:33 am
Why not create a Total Sales measure, and then reuse it?
[Total Sales] := SUM(Sales[ExtendedAmount])
[PM Sales] := CALCULATE ( [Sales], DATEADD(DimDate[FullDateAlternateKey],-1,MONTH) )
Then growth is just
[Total...
February 19, 2020 at 8:34 am
Go into the Calendar/Dates table, and select the CalendarMonth column. Then in the ribbon, click on "Sort By Column" and select MonthNumber
February 18, 2020 at 10:35 pm
If you download the AdventureWorks database and the Data Warehouse version, you'll see the difference. They're very different. I'm sure there are tutorials all over the place, but the purpose...
February 18, 2020 at 9:05 pm
Grant Fritchey has a bunch of videos on YouTube where he shows you how to do a bunch of database backup & restore things. Definitely worth watching.
February 18, 2020 at 7:58 pm
Viewing 15 posts - 781 through 795 (of 3,480 total)