AartBluestoke

   0.007 2020-12-21 13:48:30; Factorio 1.1.6 (build 57355, win64, steam)
   0.007 Operating system: Windows 10 (version 2004) 
   0.009 Program arguments: "C:\Program Files (x86)\Steam\steamapps\common\Factorio\bin\x64\Factorio.exe" 
   0.009 Read data path: C:/Program Files (x86)/Steam/steamapps/common/Factorio/data
   0.009 Write data path: C:/Users/Andrew/AppData/Roaming/Factorio [24666/487034MB]
   0.009 Binaries path: C:/Program Files (x86)/Steam/steamapps/common/Factorio/bin
   0.138 System info: [CPU: Intel(R) Core(TM) i7-6700HQ CPU @ 2.60GHz, 8 cores, RAM: 10696/32651 MB, page: 15110/55322 MB, virtual: 4329/134217727 MB, extended virtual: 0 MB]
   0.139 Display options: [FullScreen: 1] [VSync: 0] [UIScale: custom (100.0%)] [Native DPI: 1] [Screen: 1] [Special: lmw] [Lang: en]
   0.183 Available displays: 1
   0.184  [0]: \\.\DISPLAY1 - Intel(R) HD Graphics 530 {0x05, [0,0], 1920x1080, 32bit, 60Hz}

AartBluestoke

123313.668 Info AppManager.cpp:306: Saving to _autosave1 (blocking).
123313.759 Verbose Scenario.cpp:861: Saving game as C:\Users\Andrew\AppData\Roaming\Factorio\saves/_autosave1
123322.122 Time travel logging:
42157.341 Deleting surface Traxex index 18.
123322.122 Error CrashHandler.cpp:480: Exception Code: c0000005, Address: 0x00007ff684d435d3
ModuleBase: 0x00007ff684370000, ImageSize: 01cdb000, RelativeAddress: 009d35d3
123322.122 Error CrashHandler.cpp:486: Access Violation: Read at address FFFFFFFFFFFFFFFF
123322.122 Error CrashHandler.cpp:500: Exception Context:
rax=ff7fd2b8ff7fd2b8, rbx=000000f20e5fecb0, rcx=0000022117eff150,
rdx=000000f20e5feb90, rsi=ff7fd2b8ff7fd2b8, rdi=00000220fdb022b0,

AartBluestoke

reciever blueprint:
0eNrFWF2PqzYQ/S9+rOAKCJBdVPVH9LVaIUOGxLrGprZJu13x3zuGJBDEZ24/XnblxT6cOTNzxuwXyXgNlWLCkOSLsFwKTZLfvohmZ0G5/Zv5rIAkhBkoiUMELe1Kg6tk/h2My2kt8otb0RNpHMLECf4kid84qxCUMrfb4irIgV1BDRCC5sMhIAwzDDpG7eIzFXWZ4c7EX+bikEpqPCyFJWApxaFDPkniHj18C8YpILePtX3u2x8KTsMXMVyFNo7BOhqt49HajxCaqbxmpls3H00z2HMnHzzIF1QblwkNyuCDCdbet6jjHYff8PXkxFRHHNlNx3FWAGIcyXGGyWE7k2CByQRy+EBeAg3XwjNK8jSDC70yqeyxu7747PTAKpjSJl0v2pyqs7yXi+7ehPWCy7Z8bfkbansh8OyqrKiixr6X/Eya7XUzl/dokybRf6uJxvitMpWuOTyr4P8bIsSbRIj//8IYaeH9eEk4RKLNKXaCFFHz70jsL7jZ5Uil44Mdl2emDcvd/ALYogp+r/H3mlscWtWWdCol0pBFKivAiFoUv9lhKcHY/N5mEv72UijBKJTb5rRgHE90M+E+bvpMSs5OblEDJzaS2iYu8iyn+1zpi0/Z1ufUQL8VczzY23tjLisUaXl3PCyna81zKrDK3IxjTT2f+ZjQ6L0/bQB4J9CyYVpZJpB8b6fxBlvc3PdfSmL0UhLHntSrN6mdH+x0lGBGucNcjFldFGug+wKc9JtBlUwH2s/UEk6sLl3geFQhz0q2Oo35RT0//24I27p761XG72caVcxcSmhlk2XGROuTUy51o+SNKy+YdqweuDd3veDuV6ZMTfnA4Lt7JtD8Yk0d9UaYtPd2F3MzsEHyEx6Vtanq3eC7JsLIP2N7551ORmjrgQTz2TpuzFY88LQu+uVcRe+jAlrP1rD0Vwbvk682j/J3A88O2x0fEwMzn4MJNsAgQtv1GVWzOIcNOF1bSmE7ocvKLFy4AW5ioAzgoiF

AartBluestoke

        public static async Task<bool> CrazyWriter(CloudBlobContainer container)
        {
            while (true)
            {
                blobIndex+=100;
                if(blobIndex>1000000)
                    blobIndex=0;

                var itemBatch = Enumerable.Repeat(1, 100); // just a batch to do things in parallel.

AartBluestoke

there are issues like #696 which suggest runtime support for a void type. this is not one of them.

I propose compile time support for one class to declare that it is a void based specialisation of another classes generic.

The prototype problem here could be expressed as 

Func<TP1,TP2,TReturn>{
}

Action:Func<T1,T2,void>

AartBluestoke

CREATE FUNCTION [dbo].[fn_GenerateAddressHash]
(
@Addr1 nvarchar(500),
@Addr2 nvarchar(500),
@Addr3 nvarchar(500),
@Addr4 nvarchar(500),
@State nvarchar(500),
@City nvarchar(500),
@Postal nvarchar(200),
@Country nvarchar(200)

AartBluestoke

select name,column_id,user_type_id from sys.columns c1 WHERE c1.object_id = interfaceTableID) inputColumns 
			full outer JOIN 
				(select name,column_id,user_type_id from sys.columns c2 WHERE c2.object_id = destinationTableid) outputColumns on inputColumns.name = outputColumns.name
		ORDER BY (	case 
						when inputColumns.[column_id] is NULL then 1  
						when outputColumns.[column_id] IS NULL then 1 else 0 end),
					inputColumns.[column_id],outputColumns.[column_id]

AartBluestoke

select *  
FROM q
JOIN t ON q.id = t.qID 
;

select *  
FROM q
JOIN t ON q.id = t.qID 
where tID in (select min(tID) from t group by qID)
;

AartBluestoke

SELECT various_columns,
                 ss.SGMNT_STT_CD
            FROM tables rs,
                 STATUS SS
                 join (select max(SS2.STTS_ID) STTS_ID
                    from STATUS SS2
                    group by RSRVTN_SGMNT_ID
                 ) ss2 on ss2.sgmnt_stts_id = SS.sgmnt_stts_id
           WHERE SA.RSRVTN_SGMNT_ID = RS.RSRVTN_SGMNT_ID

AartBluestoke

select variousColumns,(
select S.ST_CD
FROM STATUS s
where STTS_ID in
(select max(STTS_ID) from STATUS where S.SGMNT_ID = M.SGMNT_ID)
) segment_status 
from mainTable m