<div>
easiest ways are to create a csv string and parse it in the SP or to create a temp table in VB populate it and access it in the SP.
</div>


easiest ways are to create a csv string and parse it in the SP or to create a temp table in VB populate it and access it in the SP.

<div>
Check out the passing of a CSV to a stored procedure instead. I think you can then convert this csv into an array within the SP, but you won't be able to pass a variant type to an SP.
</div>


Check out the passing of a CSV to a stored procedure instead. I think you can then convert this csv into an array within the SP, but you won't be able to pass a variant type to an SP.

<div>
Thanks - I expected that a delimited string would the way to go but needed a quick confirmation with, ideally, some code. <br />
<br />
The link you provided did just the trick<br />
<br />
Regards<br />
GK
</div>


Thanks - I expected that a delimited string would the way to go but needed a quick confirmation with, ideally, some code.

The link you provided did just the trick

Regards
GK

<div>
<div class="content wysiwyg-content">
Anyone any code samples of how to pass a one dimensional array (70 elements) from VB into a SQL Server &amp;&nbsp;stored procedure.<br />
<br />
TIA<br />
<br />
Regards<br />
GK
</div>
</div>


Anyone any code samples of how to pass a one dimensional array (70 elements) from VB into a SQL Server & stored procedure.

TIA

Regards
GK

1 dimensional array as input parameter to stored procedure

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.