Also note that the input parameter to the function should be declared as NVARCHAR

You can create a batch file that will merge them for you.

Create a file called SomeName.BAT
Add the following content, and then simply Double-Click the .BAT file

However ....
When comparing varchars
'100' < '99'

This will unpivot the data, but the column names may need some tweaking

declare @test-2 as table (
  ID   int
, Title  varchar(7)
...

declare @t as table (
initial_date_time smalldatetime
);

insert into @t values('2017-01-30 15:05:00'), ('2017-01-30 15:22:00'), ('2017-01-30 15:37:00'), ('2017-01-30 15:54:00')

select
case
when RIGHT('0'+cast(DATEPART(mi,initial_date_time)...

This should do the trick

CREATE TABLE #LotInfo (
  [Date]  DATE NOT NULL
, Lot   INT NOT NULL
, QtyBalance...

SELECT course_id = ISNULL(p.course_id, 0), pscd.sub_category_details_id
FROM #products_sub_category_details AS pscd
LEFT JOIN #points AS p
 ON pscd.sub_category_details_id = p.course_id
GROUP BY pscd.sub_category_details_id, p.course_id
/***/ ...

Deleted