Viewing 15 posts - 1 through 15 (of 70 total)
Yes it was a bit soul destroying and so many people copy in a lot of extra staff and I think this is often as a way to make their...
March 24, 2024 at 2:57 pm
This has caught me out a few times where the same code in YYYY-MM-DD format ends up being interpreted as either DD/MM/YYYY or MM/DD/YYYY depending on the server so it...
March 15, 2024 at 8:01 am
I was offered the help of a secretary once when I was getting around 350 emails per day so it was very hard to find the important emails mixed in...
March 7, 2024 at 4:07 pm
I think standards are really important across all aspects of a database and the code written to access and update it.
I do find it annoying when I have created a...
December 3, 2023 at 11:39 pm
I'm going to go for 14/11/2025 with it being a Friday
August 20, 2023 at 4:47 pm
I have used this approach to insert lists of records that were deleted or updated and it is also a good way to write scripts that insert into multiple tables...
April 1, 2023 at 9:54 pm
Ok thanks. I do enjoy challenging myself with the daily technical question and also pass it onto others in the technical teams I work in.
Thanks for keeping them coming!
February 3, 2023 at 10:16 pm
There is also one from a few weeks ago but that one still has no body so no-one could answer it.
For this one the body has returned but where has...
February 3, 2023 at 10:10 pm
SharePoint online currently requires you to enable IE mode or use IE in order for the open in Explorer option to work on the toolbar as I needed it in...
December 26, 2022 at 2:06 pm
A popular college MIS system uses CHAR for many fields and this often leads to issues, not in the software, as that is built to account for this. However data...
February 12, 2022 at 7:10 pm
Once I had a less serious Roomba issue when I had put a plate of wet cat food down and then gone shopping and when I came home the food...
October 5, 2021 at 9:54 pm
Another thing that is strange is that in SSMS 18 (17 was the same from memory) if you want to import Excel files you need to save the file into...
July 15, 2021 at 6:58 pm
It's ok I have solved it now.
I needed to create a wrapper stored procedure where I define the Result Set and then can remove this from the view and call...
May 19, 2020 at 11:22 pm
Viewing 15 posts - 1 through 15 (of 70 total)