What i’m trying to accomplish here is pull in all the rows where there is a break of less than lets say 40 days between the next row.
So in the first example there is an uninterrupted break every month or roughly so is accounted for, so I would like the query to pull in all records here.
ID DATE(INT) 190402 20200205 190401 20200103 177904 20191205 177903 20191108 177902 20191001 177901 20190905 147512 20190802 147511 20190703 147510 20190603 147509 20190529 147508 20190429 147507 20190402 147506 20190306 147505 20190205 147504 20190110 147503 20181211 147502 20181115 147501 20181022
In example two there is a gap greater than 40 days between Sep 25 2019 and January 29 2020. So I would like the query to just pull in the most recent subsequent block. In this case it would just be the top record.
ID DATE 189101 20200129 164705 20190925 164704 20190904 164703 20190802 164702 20190703 164701 20190605
I have started down this road, and was looking at using LEAD to calculate the number of days between the current and previous rows. I realize I probably need to break the years out to account for the case when moving to a new year or convert it to a real date so that I can use some sql functions to calculate the difference in days for me.
After that I wasn’t sure how to go about only returning the most recent consecutive block. Thought I would ask here to see if anyone had any insight on how I to accomplish this.
I was having trouble pushing a batch file to a local users machine, when it ran just fine on another person. It turns out I was having the file run as the Current Logged in User.
So the problem is the user is able to run any batch files without being prompted by UAC, they have the highest level of UAC set and they are a local Administrator. Other users with the same level of Access and UAC do get prompted when attempting to run any batch files.
Is there something I am missing here? Any ideas would be great!
Thanks! Eatery of Ramen
How does Pathfinder 2e consumables batch crafting work in Pathfinder Society play? For example: After an adventure, an alchemist wants to use 8 downtime days to craft a batch of four lesser alchemist’s fire flasks.
How does this process work in game, and how much does it cost the character? I understand that consumables are produced in batches, and that these consumables are separate from the alchemist’s daily infusions.
Does the alchemist pay the consumable cost per consumable unit (i.e. 1.5gp materials cost per flask + crafting time), or per batch (1.5gp materials per batch + crafting time)? And if the former, can the alchemist make a smaller batch, or individual consumable?
In a data table, each row represents a user. Each user has a status. The status can be different based on the users actions within the organization. It is shown in the data table on a dashboard for monitoring purposes. The status of the user can also be changed from this dashboard.
Some rows are also logically grouped together because the users share some commonalities.
I want to know the best way to implement a batch action mode where each row can have different action associated with it depending on the current status of the user.
In the screenshot below, G is for grouped entries. Groups can have a expanded view (Purple) or a Collapsed View (Pink).
The colored tabs are different statuses which can change from one to the next. Yellow > Green > Dark Gray.
How to deal with a person clicking on the select all checkbox (row header) which results in him selecting entries that have no common actions.
Also as groups are also a part of this, is there a way to show the user that the group selected will also be acted upon even if it is collapsed? Or should I disable the batch selection mode from Group altogether but I still need to keep an option to select all the entries of one single group at the same time as well (which will also pose the same problem with different statuses and different actions available on each status).
I want to execute a BAT file to create folder(s) on the shared drive over the network. Is this possible in sharepoint?
I have many videos in a folder, and I want to compress them all with one command.
To compress one video I use:
sudo apt-get install ffmpeg ffmpeg -i input.mp4 output.mp4
But what if I have many videos I want to compress? I’ve tried the following:
ffmpeg -i ./videos ./compressed-videos
But then I get this error:
./videos: Is a directory
I have a requirement to move just attachments from list A to list B. It’s a large list with multiple attachments in each item. I know REST batching is one option, but I was wondering if CSOM, PowerShell had batching options as well. Please advise.
Ubunto 16.04LTS INND UUCP
I have what appears to be a mostly configured INND.. Its sitting their spooling news quite happily, and creating an outgoing list of messages however I can’t convince it to actually batch the messages for sending.
What am I missing?
PCManFM 1.2.5 in Lubuntu 18.04 here.
want to add a custom command to right click menu to batch rename all files in the selected dir, including all files in all subdirs, to subdir001, subdir002, …
For example, if a directory x has subdirs abc and def containing files a1.mp3, a2.mp3, a3.mp3 each, I want the files in abc to be renamed abc001.mp3, abc002.mp3, abc003.mp3, in the same order. Same for the def dir, except to def001.mp3, etc…
How do I do this? I was searching for solutions, but they all seem to be PCManFM version dependent.
I have a bunch of file like this in a folder. ghyu_qwnm_lpo_117962956385902_20180125121100_446.xml I want to remove the older sequence “446” and add a new sequence like below: ghyu_qwnm_1_lpo_117962956385902_20180125121100.xml.
How can i achieve it with bash script ?