User defined datatype

shmz
shmz used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Sr. System Analyst
Commented:
that looks a column name to me...

a table var names @tbl_x which has one column named "typename" with nvarchar(100) datatype

above code, creates a (temporary) table with one column and dumps all parameters into it, so maybe it will use it in some queries/views etc...
Scott PletcherSenior DBA
Most Valuable Expert 2018
Top Expert 2014

Commented:
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
 .....
 )

Commented:
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

Author

Commented:
thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial