Viewing 15 posts - 706 through 720 (of 2,452 total)
Lynn Pettis (5/12/2016)
And Post Padder is still at it.
yeah....about 15 today
May 12, 2016 at 10:59 am
bit of a guess .....maybe something along these lines?
WITH CTE as (
SELECT activityCode, activityName, modifiedOn,
ROW_NUMBER() OVER (PARTITION BY
LEFT(activityCode, LEN(activityCode) - CHARINDEX('/', REVERSE(activityCode)))...
May 12, 2016 at 10:16 am
Hi there.....and welcome
just to be sure....your question title mentions "MySQL"...are you using MySQL or MS SQL?
for further posts
my suggestion is that you read this article please
https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
and then re post with...
May 12, 2016 at 9:36 am
my suggestion is that you read this article please
https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
and then re post with some sample set up scripts....will save any confusion for you and us.
thanks
May 12, 2016 at 9:26 am
ganapathy.arvindan (5/12/2016)
it is 100% correct it is working
"it is working".....you have solved your problem?
May 12, 2016 at 8:44 am
Create table ShiftScheduler(emp_code int,Enddate DATETIME,shift INT,shifttype INT)
INSERT INTO ShiftScheduler VALUES(635,'2014-05-03',2,1)
INSERT INTO ShiftScheduler VALUES(635,'2014-11-22',2,1)
INSERT INTO ShiftScheduler VALUES(635,'2015-10-28',1,1)
Create table emploee(empid INT,shift INT,shifttype INT)
INSERT INTO emploee VALUES(635,1,1)
well this looks different from what you...
May 12, 2016 at 8:39 am
ganapathy.arvindan (5/12/2016)
--DDL:Create table ShiftScheduler(emp_code int,Enddate DATETIME,shift INT,shifttype INT)
INSERT INTO ShiftScheduler VALUES(635,'2014-05-03',2,1)
INSERT INTO ShiftScheduler VALUES(635,'2014-11-22',2,1)
INSERT INTO ShiftScheduler VALUES(635,'2015-10-28',1,1)
Create table employee(empid INT,shift INT,shifttype INT)
INSERT INTO employee VALUES(635,1,1)
EXEC Emp_Shift1 1255,'2016-04-01','2016-04-24'
My Dear Friend.......please please...
May 12, 2016 at 8:07 am
jaggy99 (5/12/2016)
in that case wouldn't it be easier to do the vacancy rate calculation in Tableau/Excel as it will be easier to apply the forumla?
well if thats where the output...
May 12, 2016 at 7:52 am
sorry...but code wont parse.......cant help you until it does
May 12, 2016 at 7:50 am
.....use your code for vacant days and divide it by the code for total days......
May 12, 2016 at 7:29 am
please provide some sample set up and data scripts .....then provide the code that works with this sample and then provide the expeted results for this sample.
May 12, 2016 at 6:29 am
here is my thoughts on one way I would go about this....it uses PIVOT and takes the date spread as column headers. It concatenates Shift/Shift Type so that there is...
May 12, 2016 at 5:55 am
ganapathy.arvindan (5/11/2016)
May 12, 2016 at 4:15 am
well assuming its supposed to be Vacant Days / Total days * 100, then your calculation is wrong I think
May 12, 2016 at 3:30 am
ganapathy.arvindan (5/11/2016)
May 11, 2016 at 7:11 am
Viewing 15 posts - 706 through 720 (of 2,452 total)