Month: July 2024
Sub query
I want to use a query to pick out the latest record for a user. A user may have 5 records in the database and I want to pick the latest one. The latest one can be determined by the user Id and max mod id as there is a new id created every time a user registers for one.
Is this the most efficient query to pick the latest record
SELECT
MC.USERID
,OG.OrganisationID
, MC.Id AS ModID
, MC.TYPE AS ResID
,CAST(MC.EndDateTime AS DATETIME2) AS EndDate
,CAST(MC.ExpiryDate AS DATETIME2) ExpiryDate
,CASE
WHEN ExpiryDate >= GETDATE() AND
IsDeleted = 0 THEN 1
ELSE 0
END AS Compliance
FROM
MC
LEFT JOIN OG
ON MC.USERID = OG. USERID
INNER JOIN
(
SELECT
MC.USERID
,MAX(MC.Id) AS Max_Record
FROM MC
GROUP BY MC.USERID) Latest
ON MC.USERID = Latest.USERID
AND MC.Id = Latest.Max_Record
I want to use a query to pick out the latest record for a user. A user may have 5 records in the database and I want to pick the latest one. The latest one can be determined by the user Id and max mod id as there is a new id created every time a user registers for one. Is this the most efficient query to pick the latest record SELECT MC.USERID ,OG.OrganisationID , MC.Id AS ModID , MC.TYPE AS ResID ,CAST(MC.EndDateTime AS DATETIME2) AS EndDate ,CAST(MC.ExpiryDate AS DATETIME2) ExpiryDate ,CASE WHEN ExpiryDate >= GETDATE() AND IsDeleted = 0 THEN 1 ELSE 0 END AS Compliance FROMMCLEFT JOIN OG ON MC.USERID = OG. USERID INNER JOIN ( SELECT MC.USERID ,MAX(MC.Id) AS Max_Record FROM MC GROUP BY MC.USERID) Latest ON MC.USERID = Latest.USERID AND MC.Id = Latest.Max_Record Read More
For loop on .txt serie
I have a time serie mySerie.txt (1000×1).
I need to evaluate a function on consecutive subseries with increase in length, from 350 points up to 750 points.
Example: starting from latest 350 points (from 651 : 1000, first serie) I have to apply myFunction and get a result,then do the same but this time on data from 650:1000, and again from 649 : 1000 and so on up to the last iteration on 251:1000.These are 750 iterations and I will get 750 result from myFunction, saved in an array or vector in order to be plotted.Thanks for any help.I have a time serie mySerie.txt (1000×1).
I need to evaluate a function on consecutive subseries with increase in length, from 350 points up to 750 points.
Example: starting from latest 350 points (from 651 : 1000, first serie) I have to apply myFunction and get a result,then do the same but this time on data from 650:1000, and again from 649 : 1000 and so on up to the last iteration on 251:1000.These are 750 iterations and I will get 750 result from myFunction, saved in an array or vector in order to be plotted.Thanks for any help. I have a time serie mySerie.txt (1000×1).
I need to evaluate a function on consecutive subseries with increase in length, from 350 points up to 750 points.
Example: starting from latest 350 points (from 651 : 1000, first serie) I have to apply myFunction and get a result,then do the same but this time on data from 650:1000, and again from 649 : 1000 and so on up to the last iteration on 251:1000.These are 750 iterations and I will get 750 result from myFunction, saved in an array or vector in order to be plotted.Thanks for any help. for loop MATLAB Answers — New Questions
model settings- dialog box is not opening
i want to change certain settings in model – matlab- stateflow,
but i am facing errors
error:- issue while creating model configuration parameters dialog box, i have attached snipi want to change certain settings in model – matlab- stateflow,
but i am facing errors
error:- issue while creating model configuration parameters dialog box, i have attached snip i want to change certain settings in model – matlab- stateflow,
but i am facing errors
error:- issue while creating model configuration parameters dialog box, i have attached snip stateflow, matlab2022b MATLAB Answers — New Questions
how to merge tables without any common keywords?
I have a 20*20,a 20*1 and a 1*20 tables. I would like add the last two tables into the first one and become a 21*21 table. However all of the three tables are exactly numeric and do not have name for rows and columns and no common keywords.I have a 20*20,a 20*1 and a 1*20 tables. I would like add the last two tables into the first one and become a 21*21 table. However all of the three tables are exactly numeric and do not have name for rows and columns and no common keywords. I have a 20*20,a 20*1 and a 1*20 tables. I would like add the last two tables into the first one and become a 21*21 table. However all of the three tables are exactly numeric and do not have name for rows and columns and no common keywords. merge tables, add row in table, add column in table MATLAB Answers — New Questions
How to create configurable number of inputs/outputs channel.
We are working creating generic model which will have upto 10 input/output bus channels. But based on project we may need anything between 1 to 10 channels. How can we make configurable model which can select the inputs/outputs required.We are working creating generic model which will have upto 10 input/output bus channels. But based on project we may need anything between 1 to 10 channels. How can we make configurable model which can select the inputs/outputs required. We are working creating generic model which will have upto 10 input/output bus channels. But based on project we may need anything between 1 to 10 channels. How can we make configurable model which can select the inputs/outputs required. simulink, variant subsystem MATLAB Answers — New Questions
Monitor keeps waking up from standby mode
I have been facing a persistent issue for an extended period (possibly even longer than a few months). I can’t pinpoint exactly when it began, but here’s what typically occurs:
At random intervals ranging from 3 to 7 minutes, my monitor will enter standby mode. It then unexpectedly reactivates, briefly displaying a black screen before shutting off again. Following this, the screen briefly shows “DisplayPort” in the top right corner before returning to standby mode.
After switching out my DisplayPort cable, I observed a peculiar pattern where the monitor would only perform this wake sequence every other time it went to sleep. It seemed to be consistently alternating—meaning, every second time the monitor entered standby mode, it would either stay in standby or go through the wake cycle.
I would greatly appreciate any assistance or insights to resolve this frustrating issue that has been plaguing me for an extensive period!
I have been facing a persistent issue for an extended period (possibly even longer than a few months). I can’t pinpoint exactly when it began, but here’s what typically occurs: At random intervals ranging from 3 to 7 minutes, my monitor will enter standby mode. It then unexpectedly reactivates, briefly displaying a black screen before shutting off again. Following this, the screen briefly shows “DisplayPort” in the top right corner before returning to standby mode. After switching out my DisplayPort cable, I observed a peculiar pattern where the monitor would only perform this wake sequence every other time it went to sleep. It seemed to be consistently alternating—meaning, every second time the monitor entered standby mode, it would either stay in standby or go through the wake cycle. I would greatly appreciate any assistance or insights to resolve this frustrating issue that has been plaguing me for an extensive period! Read More
Exploring Windows 11: A Guide to Windows Explorer
Hello everyone,
I recently made a major upgrade from Win 10 Pro to Win 11 Pro and I’ve encountered a significant issue.
Unlike in Windows 10 where I could easily open File Explorer in full screen mode by selecting “run maximized” on the shortcut, I am struggling to achieve the same in Windows 11.
I’ve attempted various methods – choosing “run maximize,” opening File Explorer in full screen, then closing and reopening it – but to no avail.
Despite trying suggestions that have worked for Windows 8 and 10, none seem to work for Windows 11.
If anyone has successfully managed to open File Explorer in full screen mode in Windows 11, please share your solution with me. Your help would be greatly appreciated. Thank you.
Hello everyone, I recently made a major upgrade from Win 10 Pro to Win 11 Pro and I’ve encountered a significant issue. Unlike in Windows 10 where I could easily open File Explorer in full screen mode by selecting “run maximized” on the shortcut, I am struggling to achieve the same in Windows 11. I’ve attempted various methods – choosing “run maximize,” opening File Explorer in full screen, then closing and reopening it – but to no avail. Despite trying suggestions that have worked for Windows 8 and 10, none seem to work for Windows 11. If anyone has successfully managed to open File Explorer in full screen mode in Windows 11, please share your solution with me. Your help would be greatly appreciated. Thank you. Read More
How To Restore System Permissions to Default After Accidentally Locking Yourself Out
I attempted to remove a file by assuming ownership, which ended up affecting all the configurations. As a result, I am currently blocked from accessing my drive and experiencing malfunctions on my system. I am unable to adjust screen brightness, install or uninstall apps, and only a few settings are functional at the moment. Despite numerous restart attempts, the situation remains unchanged. How can I reset the system permissions and ownership settings to resolve this issue?
I attempted to remove a file by assuming ownership, which ended up affecting all the configurations. As a result, I am currently blocked from accessing my drive and experiencing malfunctions on my system. I am unable to adjust screen brightness, install or uninstall apps, and only a few settings are functional at the moment. Despite numerous restart attempts, the situation remains unchanged. How can I reset the system permissions and ownership settings to resolve this issue? Read More
System Center Service Manager Request Offering populate fields from a SQL database
Hey
I am working on a automation project in System Center Service Manager 2019. I have a Request Offering which have fields I would like to populate from an sql database server. So when user access the form, the drop down would pull data in from an database vs mainly importing it.
HeyI am working on a automation project in System Center Service Manager 2019. I have a Request Offering which have fields I would like to populate from an sql database server. So when user access the form, the drop down would pull data in from an database vs mainly importing it. Read More
Surface Laptop 5 SSD Upgrade issues
Hi all,
I recently upgraded the SSD from 256gb to 1tb in my Surface Laptop 5. I cloned the original SSD since I had a bunch of files and installed software already. It works great, but when I turn on the device, the initial Windows logo restarts around four to five times before it shows the spinning wheel loading Windows. Before the ssd upgrade, this wasn’t happening so I’m pretty sure it’s something talked to the new ssd and the booting. Any thoughts on how to solve this?
Hi all, I recently upgraded the SSD from 256gb to 1tb in my Surface Laptop 5. I cloned the original SSD since I had a bunch of files and installed software already. It works great, but when I turn on the device, the initial Windows logo restarts around four to five times before it shows the spinning wheel loading Windows. Before the ssd upgrade, this wasn’t happening so I’m pretty sure it’s something talked to the new ssd and the booting. Any thoughts on how to solve this? Read More
I get the illegal instruction error while running Matlab code with GPU
I get the illegal instruction error while running Matlab code with GPU.
when using matlab train networks and calculate big matrix with GPU, this error will happen.I get the illegal instruction error while running Matlab code with GPU.
when using matlab train networks and calculate big matrix with GPU, this error will happen. I get the illegal instruction error while running Matlab code with GPU.
when using matlab train networks and calculate big matrix with GPU, this error will happen. gpu MATLAB Answers — New Questions
Exchange Server Vulnerability – Vulnerable Schema Class (CVE-2021-34470)
Howdy ! Exchange Brain Trust,
Working with a customer who’s fully on 365 with no Exchange servers left on-prem but the Vulnerable Schema Class exists from a previous implementation of Exchange.
Even after uninstallation of all Exchange servers, the schema extensions made by Exchange to the Active Directory are not removed. Therefore, customer is currently vulnerable to CVE-2021-34470 and should execute this script to address this vulnerability.
If anyone have dealt with this before or can help me clarifying what implications this change can have to the normal operations and future objects provisioning (or any risk at all to the environment), that’d be really appreciated!.
Changes: Schema Modification
If the -ApplyFix parameter is used, the script modifies the schema by clearing the possSuperiors propertyof the ms-Exch-Storage-Group entry.
Thank you!
Howdy ! Exchange Brain Trust,Working with a customer who’s fully on 365 with no Exchange servers left on-prem but the Vulnerable Schema Class exists from a previous implementation of Exchange. Even after uninstallation of all Exchange servers, the schema extensions made by Exchange to the Active Directory are not removed. Therefore, customer is currently vulnerable to CVE-2021-34470 and should execute this script to address this vulnerability. If anyone have dealt with this before or can help me clarifying what implications this change can have to the normal operations and future objects provisioning (or any risk at all to the environment), that’d be really appreciated!. Changes: Schema ModificationIf the -ApplyFix parameter is used, the script modifies the schema by clearing the possSuperiors propertyof the ms-Exch-Storage-Group entry. Thank you! Read More
Want to go out from insider dev without usb😭😭😭
Hello,
I joined insider on release preview and updated win. 11 24h2 but mistakely i clicked then on Dev channel and now i want to come out from it!
I also restarted my PC / clicked on leave programme but it don’t works and suggesting to reinstall windows……
I don’t have USB so please help me to tell how can i reinstall windows without USB:loudly_crying_face::loudly_crying_face:plzzz help suggesting other method in which usb is not needed i don’t care of wipe data plzzzzzzz:loudly_crying_face::loudly_crying_face:
Hello,I joined insider on release preview and updated win. 11 24h2 but mistakely i clicked then on Dev channel and now i want to come out from it!I also restarted my PC / clicked on leave programme but it don’t works and suggesting to reinstall windows……I don’t have USB so please help me to tell how can i reinstall windows without USB:loudly_crying_face::loudly_crying_face:plzzz help suggesting other method in which usb is not needed i don’t care of wipe data plzzzzzzz:loudly_crying_face::loudly_crying_face: Read More
“Troubleshooting Issue with File Explorer on Windows 10”
When I attempt to open a folder in the file explorer by right-clicking, I encounter the same issue twice before it finally shows the contents:
Error Message: Folder is corrupted and unreadable.
Is there anyone who has faced this issue before or can suggest a solution?
Device: Windows 10 Version 22H2 Build 19045.4651
When I attempt to open a folder in the file explorer by right-clicking, I encounter the same issue twice before it finally shows the contents: Error Message: Folder is corrupted and unreadable. Is there anyone who has faced this issue before or can suggest a solution? Device: Windows 10 Version 22H2 Build 19045.4651 Read More
Can you rephrase this laptop problem for me?
Hello,
When you receive a new laptop, what steps do you take after unboxing it to ensure everything is in working order?
Have you considered creating a full backup using Macrium immediately after unboxing to safeguard against any potential issues in the future? Would you keep this initial backup indefinitely or delete it once it’s no longer needed?
Thank you.
Hello, When you receive a new laptop, what steps do you take after unboxing it to ensure everything is in working order? Have you considered creating a full backup using Macrium immediately after unboxing to safeguard against any potential issues in the future? Would you keep this initial backup indefinitely or delete it once it’s no longer needed? Thank you. Read More
Nightly Restart of Windows Computers
There is no Group Policy Object (GPO) in place to handle this issue. I observed this in my event viewer. This is occurring on both Windows 10 and 11 systems.
Automatic updates are disabled, and the “Do not automatically restart” setting is activated for Windows Update. To investigate further, I have paused the updates for a week, even though no recent updates have been installed. I have not identified any tasks in the Task Scheduler that I personally set up.
Microsoft Windows [Version 10.0.22621.2861]
(c) Microsoft Corporation. All rights reserved.
The system boot time is recorded as July 22, 2024, at 3:03:14 AM.
A restart of the computer was initiated by the process C:Windowssystem32wbemwmiprvse.exe (*******-LT), executed by the user NT AUTHORITYSYSTEM. The reason given for the restart is unknown, with the reason code noted as 0x80070015.
Shutdown Type: Restart.
There is no Group Policy Object (GPO) in place to handle this issue. I observed this in my event viewer. This is occurring on both Windows 10 and 11 systems. Automatic updates are disabled, and the “Do not automatically restart” setting is activated for Windows Update. To investigate further, I have paused the updates for a week, even though no recent updates have been installed. I have not identified any tasks in the Task Scheduler that I personally set up. Microsoft Windows [Version 10.0.22621.2861](c) Microsoft Corporation. All rights reserved. The system boot time is recorded as July 22, 2024, at 3:03:14 AM. A restart of the computer was initiated by the process C:Windowssystem32wbemwmiprvse.exe (*******-LT), executed by the user NT AUTHORITYSYSTEM. The reason given for the restart is unknown, with the reason code noted as 0x80070015. Shutdown Type: Restart. Read More
Error Encountered Upon Launching Explorer?
Greetings everyone,
I’m facing an unusual issue during startup that is interrupting my usual routine. A small blank explorer.exe dialogue box appears, and until I manually click OK using either the mouse or the keyboard, my startup programs such as Logitech G-hub and Sandboxie do not launch. Once I acknowledge the dialogue, I hear a notification sound, and everything proceeds as usual.
This problem surfaced only recently, coinciding with my decision to tidy up my system by deleting old empty folders and some unidentified recently created folders, including a few within the ProgramData directory (an oversight on my part!). I even cleared out the Recycle Bin during this cleanup process.
I attempted to resolve the issue by running SFC/Scannow, which did detect and repair some corrupted files, although none of them seemed related to the areas I was exploring. To further troubleshoot, I uninstalled Windowblinds 11 and Start11 following recommendations from another source.
Although the reliability history doesn’t indicate any specific errors, this issue persists every time I log in, despite using a local account rather than a Microsoft one.
Do any of you have suggestions for addressing this startup hitch?
Other than this inconvenience, my computer appears to be functioning normally.
I appreciate any insights or advice on this matter.
Greetings everyone, I’m facing an unusual issue during startup that is interrupting my usual routine. A small blank explorer.exe dialogue box appears, and until I manually click OK using either the mouse or the keyboard, my startup programs such as Logitech G-hub and Sandboxie do not launch. Once I acknowledge the dialogue, I hear a notification sound, and everything proceeds as usual. This problem surfaced only recently, coinciding with my decision to tidy up my system by deleting old empty folders and some unidentified recently created folders, including a few within the ProgramData directory (an oversight on my part!). I even cleared out the Recycle Bin during this cleanup process. I attempted to resolve the issue by running SFC/Scannow, which did detect and repair some corrupted files, although none of them seemed related to the areas I was exploring. To further troubleshoot, I uninstalled Windowblinds 11 and Start11 following recommendations from another source. Although the reliability history doesn’t indicate any specific errors, this issue persists every time I log in, despite using a local account rather than a Microsoft one. Do any of you have suggestions for addressing this startup hitch? Other than this inconvenience, my computer appears to be functioning normally. I appreciate any insights or advice on this matter. Read More
How to Turn Off the Windows Key Shortcut Guide
Hello everyone! I’m looking for advice on how to enhance the Windows Key Shortcut Guide. This feature appears when you press and hold the Windows key for a few seconds – check out the screenshot below. I’m interested in customizing this guide without affecting any other Windows Shortcut Keys. Any suggestions would be greatly appreciated.
Hello everyone! I’m looking for advice on how to enhance the Windows Key Shortcut Guide. This feature appears when you press and hold the Windows key for a few seconds – check out the screenshot below. I’m interested in customizing this guide without affecting any other Windows Shortcut Keys. Any suggestions would be greatly appreciated. Read More
How to uninstall Copilot Preview?
After upgrading my operating system to 23H2, I noticed a new persistent presence on my taskbar – Copilot Preview. Despite my attempts to remove the icon, it keeps reappearing. Although Copilot does not seem to be actively running, it is located in the Program FilesWindowsApps directory, where I am unable to access or modify its permissions. I am now considering whether it is safe to delete all Copilot files, as the application does not appear in any of my uninstallers. I located all the related files using Everything. Here is a snapshot of some of the files.
After upgrading my operating system to 23H2, I noticed a new persistent presence on my taskbar – Copilot Preview. Despite my attempts to remove the icon, it keeps reappearing. Although Copilot does not seem to be actively running, it is located in the Program FilesWindowsApps directory, where I am unable to access or modify its permissions. I am now considering whether it is safe to delete all Copilot files, as the application does not appear in any of my uninstallers. I located all the related files using Everything. Here is a snapshot of some of the files. Read More
Prevent Microsoft from Accessing My Computer
Undergoing a sudden transition to Windows 11 left me feeling overwhelmed. Despite having disabled all updates and backups, the installation resulted in a catastrophic failure that rendered my computer barely functional. I sought assistance from various Microsoft Support platforms, only to be met with unhelpful responses. The chat option was equally unproductive. Frustrated, I took matters into my own hands by backing up essential files onto a flash drive and initiating a factory reset.
Following the reset, I encountered persistent issues with installing the Office 2019 software that I had purchased. Repeated error messages stating “Something went wrong” plagued my attempts. In the aftermath of the Windows 11 installation, I struggled to locate the product key required for activation, further complicating the situation.
Utilizing a Microsoft tool, I managed to remove the failed Office installations, paving the way for a subsequent reset on 06/19/2024. This time, I resorted to using the Edge browser to successfully download and install Office, raising questions about the browser’s compatibility that had eluded me before.
Reflecting on my experience, I found myself increasingly concerned about the integration of my original Office software with the subscription-based Office 365. This unwelcome tethering of applications, such as OneDrive, infringed upon my sense of control over my computing environment. Despite my efforts to disconnect and disable certain features, unwanted changes continued to manifest themselves, ranging from unexpected desktop backgrounds to intrusive online synchronization of data.
Feeling besieged by the pervasive influence of Microsoft on my device, I contemplated drastic measures like switching to a Mac or seeking support through crowdfunding platforms. The unsettling realization that my autonomy was being eroded prompted me to question the feasibility of reclaiming my standalone Office application and severing ties with Office 365 and OneDrive.
The persistent disruptions and encroachments on my digital space left me fatigued and yearning for a return to a state of stability and privacy. I reached out for assistance in restoring my familiar software and regaining control over my computing experience, recognizing the fine line between legitimate concerns and the perceived indulgence of complaints.
Undergoing a sudden transition to Windows 11 left me feeling overwhelmed. Despite having disabled all updates and backups, the installation resulted in a catastrophic failure that rendered my computer barely functional. I sought assistance from various Microsoft Support platforms, only to be met with unhelpful responses. The chat option was equally unproductive. Frustrated, I took matters into my own hands by backing up essential files onto a flash drive and initiating a factory reset. Following the reset, I encountered persistent issues with installing the Office 2019 software that I had purchased. Repeated error messages stating “Something went wrong” plagued my attempts. In the aftermath of the Windows 11 installation, I struggled to locate the product key required for activation, further complicating the situation. Utilizing a Microsoft tool, I managed to remove the failed Office installations, paving the way for a subsequent reset on 06/19/2024. This time, I resorted to using the Edge browser to successfully download and install Office, raising questions about the browser’s compatibility that had eluded me before. Reflecting on my experience, I found myself increasingly concerned about the integration of my original Office software with the subscription-based Office 365. This unwelcome tethering of applications, such as OneDrive, infringed upon my sense of control over my computing environment. Despite my efforts to disconnect and disable certain features, unwanted changes continued to manifest themselves, ranging from unexpected desktop backgrounds to intrusive online synchronization of data. Feeling besieged by the pervasive influence of Microsoft on my device, I contemplated drastic measures like switching to a Mac or seeking support through crowdfunding platforms. The unsettling realization that my autonomy was being eroded prompted me to question the feasibility of reclaiming my standalone Office application and severing ties with Office 365 and OneDrive. The persistent disruptions and encroachments on my digital space left me fatigued and yearning for a return to a state of stability and privacy. I reached out for assistance in restoring my familiar software and regaining control over my computing experience, recognizing the fine line between legitimate concerns and the perceived indulgence of complaints. Read More
