<div>
<div class="content wysiwyg-content">
I am creating a Stored Procedure to insert records into a table using SQL Server 2005.<br />
<br />
I have a table titled tblA with the following 3 fields and the last field titled<br />
<br />
ELEMENT_TYPE_VALUE_PAIRS can have mulitple values in it's field:<br />
<br />
ID_TYPE &nbsp; &nbsp; PRIN_NAME &nbsp; ELEMENT_TYPE_VALUE_PAIRS<br />
<br />
K &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;smithj &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {(User_Type, Master Access)} &nbsp; <br />
K &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;smithj &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {{(Holder,holder-1),(Actio<wbr />n,All)}} &nbsp; <br />
K &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;smithj &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {{(Holder,holder-2),(Actio<wbr />n,Update)}<wbr />} &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
K &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;cliffr &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;{{(Holder,holder-1),(Actio<wbr />n,Browse)}<wbr />} &nbsp;<br />
K &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;cliffr &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;{(User_Type,Security Officer Access)} &nbsp;<br />
<br />
How would you create a stored procedure to populate table tblA with the values listed above?
</div>
</div>


I am creating a Stored Procedure to insert records into a table using SQL Server 2005.

I have a table titled tblA with the following 3 fields and the last field titled

ELEMENT_TYPE_VALUE_PAIRS can have mulitple values in it's field:

ID_TYPE     PRIN_NAME   ELEMENT_TYPE_VALUE_PAIRS

K                          smithj           {(User_Type, Master Access)}   
K                          smithj           {{(Holder,holder-1),(Action,All)}}   
K                          smithj           {{(Holder,holder-2),(Action,Update)}}                
K                          cliffr              {{(Holder,holder-1),(Action,Browse)}}  
K                          cliffr              {(User_Type,Security Officer Access)}  

How would you create a stored procedure to populate table tblA with the values listed above?

How would you create a stored procedure to insert records containing a field that has mulitple values using SQL Server 2005?

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.