CREATE PROCEDURE [dbo].[msrTransformAsAccessDo]
	@TRANSFORM_Function nvarchar(max),
	@TRANSFORM_Field nvarchar(max),
	@SQL_SELECT nvarchar(max),
	@SQL_FROM_WHERE nvarchar(max),
	@SQL_GROUPBY_HAVING_ORDERBY nvarchar(max),
	@PIVOTBY nvarchar(max) 
AS
BEGIN
	SET NOCOUNT ON
	DECLARE @DynSQL nvarchar(max)
	SET @DynSQL = N' SELECT DISTINCT ' + @PIVOTBY + ' as key_value into ##pivoting ' + @SQL_FROM_WHERE + ' ORDER BY ' + @PIVOTBY
	DROP TABLE IF EXISTS ##pivoting
	EXEC (@DynSQL)
	DECLARE @Values nvarchar(max) = N''
	DECLARE @tmpStr nvarchar(max)
	DECLARE @rsk CURSOR         
	SET @rsk = CURSOR SCROLL
		FOR	
			select key_value from ##pivoting
	OPEN @rsk         
		FETCH NEXT FROM @rsk INTO @tmpStr
		WHILE @@FETCH_STATUS = 0
			BEGIN
				SET @Values = @Values + ', ' + @TRANSFORM_Function + '(Case When convert(nvarchar,' + @PIVOTBY + ')=convert(nvarchar,''' + @tmpStr + ''') Then ' + @TRANSFORM_Field + ' Else Null End) AS [' + @tmpStr + '] '
				FETCH NEXT FROM @rsk INTO @tmpStr
			END
	CLOSE @rsk
	DROP TABLE IF EXISTS ##pivoting
	SET @DynSQL = @SQL_SELECT + @Values + @SQL_FROM_WHERE + @SQL_GROUPBY_HAVING_ORDERBY
	EXEC (@DynSQL)
END

CREATE TABLE tbl_test
(
    SeenAt  date,
    stockid  int,
    shelfid  int,
    qty  float
);

INSERT INTO tbl_test
(
    SeenAt,
    stockid,
    shelfid,
    qty
) VALUES
('2018-03-01',1000,1,24.8),

('2018-03-02',1000,1,26.2),
('2018-03-02',1000,2,11.3),
('2018-03-02',1000,3,45.0),

('2018-03-03',1000,1,27.8),
('2018-03-03',1000,3,87.1),

('2018-03-04',1000,1,28.8),
('2018-03-04',1000,2,31.8),

('2018-03-05',1000,1,21.8),
('2018-03-06',1000,4,23.8),

('2018-03-01',2000,1,30.89),
('2018-03-02',2000,2,33.00),
('2018-03-03',2000,1,34.8),
('2018-03-04',2000,2,34.2),
('2018-03-05',2000,1,33.8),
('2018-03-06',2000,2,43.8);