<div>
Declare @tbl_x table(typename uniqueidentifier primary key) --might as well be pk, unless you need to insert dup values to this table??<br />
<br />
&nbsp;While len(@rpt_parameter) &gt;0<br />
&nbsp;Begin<br />
&nbsp;Insert into @tbl_x<br />
&nbsp;.....<br />
&nbsp;)
</div>


Declare @tbl_x table(typename uniqueidentifier primary key) --might as well be pk, unless you need to insert dup values to this table??

 While len(@rpt_parameter) >0
 Begin
 Insert into @tbl_x
 .....
 )

<div>
There are no user-defined data types in the code fragment you provided. Perhaps you would like to provide the full SProc (or at least the part that gets data into the table variable (@tbl_x)) for us to see ? Otherwise what HainKurt says.<br />
<br />
Mike
</div>


There are no user-defined data types in the code fragment you provided. Perhaps you would like to provide the full SProc (or at least the part that gets data into the table variable (@tbl_x)) for us to see ? Otherwise what HainKurt says.

Mike

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have a pre existing code in an stored pro that receives multi valued &nbsp;parameter from SSRS 2008.<br />
<br />
Declare @tbl_x table(typename nvarchar(100))<br />
While len(@rpt_parameter) &gt;0<br />
Begin<br />
Insert into @tbl_x<br />
.....<br />
)<br />
<br />
I'm not familiar with user defined data types and need to do same thing for a parameter of type unique identifier.<br />
Are the variables ( in the example above: typename) defined here in the code? Do I need to do the same for unique identifier data type?<br />
Thanks
</div>
</div>


Hi

I have a pre existing code in an stored pro that receives multi valued  parameter from SSRS 2008.

Declare @tbl_x table(typename nvarchar(100))
While len(@rpt_parameter) >0
Begin
Insert into @tbl_x
.....
)

I'm not familiar with user defined data types and need to do same thing for a parameter of type unique identifier.
Are the variables ( in the example above: typename) defined here in the code? Do I need to do the same for unique identifier data type?
Thanks

User defined datatype

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.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.