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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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)))...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 12, 2016 at 7:52 am
sorry...but code wont parse.......cant help you until it does
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 12, 2016 at 7:50 am
.....use your code for vacant days and divide it by the code for total days......
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 12, 2016 at 5:55 am
ganapathy.arvindan (5/11/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 12, 2016 at 3:30 am
ganapathy.arvindan (5/11/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 11, 2016 at 7:11 am
Viewing 15 posts - 706 through 720 (of 2,452 total)