We have a table with columns Id (GUID), Title (nvarchar(50)), PubDate (DateTime). After several tests there were inserted a lot of records and many of them have been inserted more than 1 time. The task is to ‘seek and destroy’ all the duplicate elements and to leave only unique rows. Read more»
I downloaded a repository from github and decided to install the packages. I entered ‘npm install’ but as a result I’ve got a lot of messages that packages are deprecated and some errors. As I could see in the log files, the problem was connected with old packages. So I wanted to update all the […] Read more»
Many times I told myself not to work with SharePoint, but it’s forever with me 🙂My colleague asked to help him with a problem with modern lists. There some simple fields, without lookups. But there’s an error in displaying items. I spent about an hour to determine the problem – created a copy of the […] Read more»
Once I tried to make the application to migrate a custom data source from SharePoint 2010 to SharePoint 2019 on-premise. To make it easier, I decided to make to separate solutions – the first one to export the data from SharePoint 2010 from the list to JSON and attachments to local folder(CSOM for SharePoint 2010 […] Read more»
The task is. You have an array of numbers, you should find the max sum of the digits. The numbers are natural. Constraints: you can not use arrays. Read more»
Once again I decided to make a new task from LeetCode and finally my process had been stopped. I could not convert Char to Int. I even spent some time for research, but I could not find any solution. Then I open the documentation and started to read. Read more»
I spent a lot of time to understand how to get async data from web-services and to set it to vars in React I need to try to change ‘fetch’ to ‘axios’ Read more»
It’s not for production, but for developer environments Add the block below to Program.cs. I talk about Net Core 5 or Net Core 6 application. Read more»
There are 5 buttons on a page. If you click 1, 3 or 4 there must be one action, for 2 and 4 another one. You don’t have to write the same action for each control, like this: Read more»
The task is to build a tree in a table with parentID from bottom to top. It’s useful for generating hierarchy strings, lists or any other types. You can also create a storage procedure of this and it will make it easy to use in queries. Read more»
