- 06:33, 5 July 2017 Convert CSV to TXT (hist) [2,188 bytes] Andr3w (Created page with "==Identifying the problem rows== You can look at the data with a text editor or use powershell. We load all the raw text into $ge1 - we plan to fix the data stage by stage. $...")
- 11:21, 16 June 2017 2015 UK General Election using SQL Server (hist) [4,303 bytes] Andr3w (Created page with "This tutorial assumes you have access to powershell and sqlcmd or Microsoft SQL Server Management Studio ==Get to the powershell prompt and download the csv== (new-object sy...") originally created as "2015 UK General Election using mssql"
- 11:41, 10 May 2017 Help Desk (hist) [7,783 bytes] Andr3w (Created page with "<div class='qu'> <p class=imper'>There are three issues that include the words "index" and "Oracle". Find the call_date for each of them</p> <source lang='sql' class='def'> </...")
- 06:51, 4 May 2017 Guest House Assessment Easy/zh (hist) [3,117 bytes] Kenlyl (Created page with "Database Description | Easy Problems | Medium Problems | Guest House Assessment Hard|Hard P...")
- 06:04, 4 May 2017 Guest House/zh (hist) [3,529 bytes] Kenlyl (Created page with "*旅客住在一間小旅店。Guests stay at a small hotel. *Each booking is recorded in the table '''booking''', the date of the first night of the booking is stored here (w...")