Viewing 5 posts - 1 through 5 (of 5 total)
This is good Lynn!
Is there a way to have WORKER_TYPE not show if [emp1].[WORKER_TYPE] <> [emp2].[WORKER_TYPE] and EMP_STATUS if [emp1].[EMP_STATUS] <> [emp2].[EMP_STATUS]not show? The Period_FTE columns are all different so...
June 19, 2018 at 1:41 pm
I started to go about the self join differently, here is a snippet that works until you add the WORKER_TYPE which is the same in both sets so it then unfortunately...
June 19, 2018 at 12:35 pm
Just out of curiosity does the following work?
DECLARE @Date1 DATE = '2018-06-04'
...
June 19, 2018 at 11:36 am
Thank you Steve. I'm rather new to this, prior using BI apps to report write. I apologize about the formatting. I am using an existing table derived from many other...
June 19, 2018 at 8:36 am
small sample of data. period fte column difference is what should show.
June 18, 2018 at 1:00 pm
Viewing 5 posts - 1 through 5 (of 5 total)