Viewing 14 posts - 16 through 29 (of 29 total)
Sorry, my bad, sample table updated slightly.
January 8, 2020 at 5:00 am
December 13, 2018 at 7:58 am
December 12, 2018 at 7:37 pm
December 12, 2018 at 7:25 am
Your q states"How can I combine the three queries to one". We write...
December 11, 2018 at 6:06 pm
December 11, 2018 at 5:53 pm
OK, thank you guys but I doubt none of the replies catched it.
As indicated in my reply to the first reply:
December 11, 2018 at 12:57 pm
Thank you but it doesn't address the question, key point here is to shrink down the original size...
December 11, 2018 at 8:18 am
August 31, 2018 at 12:51 pm
select convert(decimal(10,2), replace(replace('"6,789.01"', '"', ''), ',','')) August 31, 2018 at 12:48 pm
Thank you both very much for the replies, both work!
August 24, 2018 at 4:49 pm
I fixed it, thank you very much.
Can you explain how to do this using the PIVOT function?
October 20, 2016 at 1:48 pm
My code again here:
Select CutoffMonth,
ROW_NUMBER() OVER(ORDER BY [ProjectName] ASC) AS ProjectID, [Employee Number],
'Nov 2015',
'Dec 2015',
'Jan 2016',
TotalHRSWORKED, HourlyRate
From (Select distinct
CutoffMonth,
[ProjectName],
[Employee Number],
SUM(CASE WHEN [Mois Imputé:Cutoff Month]='Nov 2015' THEN [Nombre d'Heures...
October 20, 2016 at 1:32 pm
Thank you very much for your quick reply, for unknown reason, the sum produces only CutoffMonth itself like 'Jan 2016', 'Feb 2016' instead of actually summed numbers.
October 20, 2016 at 1:29 pm
Viewing 14 posts - 16 through 29 (of 29 total)