Ask Ben First

If you are in Australia looking for mobile prepaid plan this would be  a good deal to consider. I've signed up with $10/month (no contract) Belong Mobile (Telstra network) small plan with the following benefits: 1. Unlimited data (1GB 4G speed and the rest shaped to 64kbps). 2. Unlimited call and text within Australia. 3. Unused high speed data quota (1GB) will be rolled over to the following months. How good is that? If you use the following link to subcribe, you and I each will get $20 free credit (two months free): https://www.belong.com.au/iaf?promo=IAFNB7XVQ Happy days

Problem I need to populate SQL table to store permanent and temporary address changes from SPList item version history. I need to store the first version and subsequent versions only if the address is updated. All will be stored as CSV file with latest address (version) first. Since the following script will be run as Windows Scheduled Task, it will also rename $csvFileName with original date/time stamp before creating a new one. Solution # Import list item version history of RP content type to CSV file / SQL table # Created by Ben - 7 March 2019 clear start-transcript if ((gsnp '*sharepoint*' -ErrorAction SilentlyContinue) -eq $null ){asnp *sharepoint*} $currentPs1Filename = $MyInvocation .MyCommand.Name $currentPs1FilePath = $MyInvocation .MyCommand.Definition $currentPs1Folder = $currentPs1FilePath .SubString(0, $currentPs1FilePath .indexOf( $currentPs1Filename )) $siteUrl = 'http://your-target-site-url' $csvFileName = 'RPAddressHistory.csv...

Problem  I need to concatenate the following EventDate (latest to oldest) into a single row grouped by ParentWebGuid on Microsoft SQL 2008 R2 database view: SELECT TOP ( 100 ) PERCENT ParentWebGuid , TypeOfEvent , CONVERT ( VARCHAR ( 10 ) , EventDate , 103 ) AS EventDateString FROM dbo . SupervisionEvent WHERE ( TypeOfEvent = 'Visit [P]RP' ) ORDER BY ParentWebGuid , EventDate DESC Solution SELECT DISTINCT TOP ( 100 ) PERCENT ParentWebGuid , REPLACE ( ( SELECT TOP ( 100 ) PERCENT CONVERT ( VARCHAR ( 10 ) , EventDate , 103 ) AS 'data()' FROM dbo . SupervisionEvent WHERE ( TypeOfEvent = 'Visit [P]RP' ) AND ( ParentWebGuid = mainTable . ParentWebGuid ) ORDER BY EventDate DESC FOR XML PATH ( '' ) ) , ' ' , ', ' ) AS VisitPrpEventDates FROM dbo . SupervisionEvent AS mainTable WHERE ( TypeOfEvent = 'Visit [P]RP' ) Explanation AS   'data()...

I've just connected my home to Belong NBN and mobile servicec and I'm very happy with the speed and price. If you click the following link to join, you can get $20 discount on your first bill. https://www.belong.com.au/iaf?promo=IAFNB7XVQ

I've been trying to find out the problem on my refrigerator since last year when it stopped cooling and there was a layer of ice built up on the lower panel near the vegetable drawer. I tried to unplug the refrigerator and waited for a couple of days or more (in winter) to let the ice melt and it would be back to normal for a few months before the problem reoccurred. After researching on YouTube, I found out ways to test the refrigerator components as follows: Unplug the refrigerator power. Remove two screws from the bottom panel (on top of vegetable/fruit drawer). Remove a round plastic plug on the panel with a flat screw driver in order to enable you to pull the whole panel out using a finger. Unplug three plastic connectors (fan, thermostat defrost termination, defrost heating element). While the refrigerator is still cold, use ohm meter to check the resistance of the three components while unplug and all should show the following normal resistance: Fan: around...

A few weeks ago I was researching for ways to extract Management Log | View Details on Infinity Intelledox Version 9 and Version 10 to analyse failed actions (CRM, BPOINT, REST) and finally found the following SQL statement that saved my day. Hopefully it will save yours too... Cheers... SELECT datetime_start as 'Start Date', iu.Username as 'User', t.Name as 'Project', messages.value('(Messages/Message/@Description)[1]','varchar(max)') as Message FROM dbo.template_log tl join dbo.Intelledox_User iu on tl.User_ID = iu.User_ID join dbo.Template_Group tg on tl.Template_Group_ID = tg.Template_Group_ID join dbo.Template t on tg.Template_Guid=t.Template_Guid WHERE messages.value('(Messages/Message/@Description)[1]','varchar(max)') is not null UNION SELECT  datetime_start as 'Start Date', iu.Username as 'User', t.Name as 'Project', messages.value('(Messages/Message/@Description)[2]','varchar(m...

When I clicked Edit or Remove links on my Google Bookmarks, nothing happened. I realised there's an error on the browser console when loading https://www.google. com.au /bookmarks To work around the problem, I changed the address to https://www.google. com /bookmarks and the problem went away. In case you encounter similar problem, I hope this article will help you. Have a good day everyone!