Viewing 15 posts - 1 through 15 (of 88 total)
This was the query I made if that is what you meant.
case when (DATEDIFF(MONTH,0,c.DateKey)/3 - DATEDIFF(MONTH,0,@TodaysDate)/3 = DATEPART(QUARTER,@TodaysDate)) THEN 1 ELSE 0 END
May 23, 2019 at 9:31 am
Actually I think I've got it now, I have done the following
case when DATEPART(QUARTER,c.DateKey)+1 = DATEPART(QUARTER,@TodaysDate) AND YEAR(c.DateKey) = YEAR(@TodaysDate) THEN 1 ELSE 0 END
May 23, 2019 at 8:14 am
Thanks Nigel, This seems to work. What would need to be done for Previous Qtr, so the dates between 01/01/2019 to 31/03/2019 they would be set to 1 for this...
May 23, 2019 at 8:12 am
Thanks for the reply, so when I deploy to the server and then go back to the Analysis Services section on Azure, I can now see under "Models on Analysis...
November 22, 2018 at 4:05 pm
Paulo de Jesus - Friday, October 27, 2017 5:11 AMHave a look at some of the suggestions in this link:
https://qa.sqlservercentral.com/Forums/Topic1556669-148-1.aspx
Thanks...
October 27, 2017 at 6:30 am
Yes the first "Analysis Services Process Task" Processes the Dimensions, after that task has completed the second
June 27, 2017 at 3:11 pm
The body of...
April 21, 2017 at 7:48 am
CREATE FUNCTION tvf_HighestIncreased (@Refno int)April 21, 2017 at 7:46 am
Thanks Chris for your reply, it looks like it has done the job! But I did notice that when I inserted another row into the table hrd_audit
insert into hrd_Audit values...
November 1, 2016 at 4:06 pm
I think I have seen it somewhere but I'm not sure how to use the PRINT to displace the sublimate values on the BODY of the email?
October 27, 2016 at 11:15 pm
Hi,
Okay thanks, but how do I fixed the date to be '01-APR' and then the relevant year?
Thanks
July 21, 2016 at 3:48 am
So with my current script that I have found what actually needs to be changed for it to work as not sure now?
Thanks
September 25, 2015 at 3:55 pm
Viewing 15 posts - 1 through 15 (of 88 total)