Viewing 15 posts - 1 through 15 (of 89 total)
It's very good questions, all assumptions are looks correct. one thing is there could be possible start and end date is same but next value one day gap is there,...
July 24, 2020 at 5:49 pm
There is a small glitch in data, please see attached screenshot. No 7 is not correct and 8,9 rows are dups if you take a look at split start and...
July 23, 2020 at 12:49 pm
One small update needed for this. sorry for updating requirement. While performing QA found it. Some member can have deceased populated , so loop should end based on deceased end....
July 23, 2020 at 8:45 am
Awesome! Thank you so much!
July 22, 2020 at 3:30 pm
Awesome! Thank you John! Much Appreciated for you're help.
January 29, 2020 at 12:25 pm
This query should work, please try it.
WITH CTE AS(SELECT *, DENSE_RANK() OVER(PARTITION BY Fl_Group Order by Bonus DESC) AS H_Bonus FROM Freelancer )SELECT * FROM CTE WHERE...
January 8, 2020 at 9:35 am
Hello, below is the data before filtering out, if you see A-06/11/2019 9:15 between A-06/11/2019 9:10 and A-06/11/2019 9:25, that's why it is not showing in end result. It means...
November 7, 2019 at 12:48 pm
Below query should works. Change LEAD to LAG if any change in requirement.
;WITH MyTable AS ( SELECT * FROM (VALUES ('A',...
November 7, 2019 at 10:11 am
Thanks for response, i have used function instead of table, trying to find out better version
CREATE FUNCTION DBO.Fn_spt_values(@StartDate DATE,@EndDate DATE)RETURNS TABLE AS RETURN (SELECT...
October 16, 2019 at 10:03 am
We can sum by using below formula
=SUM(Fields!InvoiceTotal.Value) - Before this you may need to right click on table add new row.
August 21, 2019 at 10:44 am
Thom, Thanks for response, Can u have look output once, it is contains both 2018 and 2019 years data- derived based on current month. Thanks!
May 17, 2019 at 3:13 pm
Member ID which is unique in system. Data type is BIG INT - Thanks!
May 13, 2019 at 7:18 am
Thanks Jeff for making it to clear, below is the answer to questions.
1. What is actually contained in the source data from the Oracle system? Is it truly ALL THE...
May 11, 2019 at 4:41 pm
Thanks for responses, here is the answers to questions.
Jeff - Destination is unknown, we just need to place file in network location in specific format requested by destination team
May 11, 2019 at 1:55 am
Thanks Thom, I have thought of LAG function to use, it will work for sure. the only worry is need use same function 200 times as 200 columns in a...
May 1, 2019 at 11:39 am