document Function - RowToColumn

RowToColumn

This functions transpose a row in a column.

example:

select *
from [dbo].[RowToColumn]('path','file','|',1,-1)

paramenters:

@path:
it's the path of file

@file:
the file to open

@delimitator:
it's the delimitator of the text columns;
in case of excel this will be ignored.

@xls:
-if <0 that means it's a text file, else it's the sheet of the excel