Monday

return table from stored procedure

To return table from stored procedure:
declare value as table in sql and fill it from stored procedure by insert..execute like in this code below:

DECLARE @Accounts1 AS TABLE
(
customer NUMERIC(9, 0),
sub TINYINT,
tp1 VARCHAR(100)
)


insert into @Accounts1
execute usp_AccountDifferentialReportSelector @Did,@CycID

No comments:

here is powershell script on how to get list of files from changesets associated with one tfs task

$dllPath = "C:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\Common7\IDE\CommonExtensions\Microsoft\TeamFoundation\...