TSQL Creating a Table using another User Defined Type?

Question

I have a stored procedure that receives a (n) list of filters stored as GUIDs. What I need is a stored procedure that will receive an (n) list of an (n) list of filters so that I can return comparisons each (n) list of filters. Is this possible, and how would you script it?

For reference, the current user type looks like the following:

CREATE TYPE [dbo].[GuidList] AS TABLE(
    [Value] [uniqueidentifier] NOT NULL,
    PRIMARY KEY CLUSTERED 
(
    [Value] ASC
)WITH (IGNORE_DUP_KEY = OFF)
)

No you can't use table types as column datatypes. Why not just add an additional column to the table type that acts as a grouping identifier? — Martin Smith
– Martin Smith, Commented Jun 6, 2013 at 13:56

tommy_o · Accepted Answer · 2013-06-06 17:32:01Z

1

If all you really want to do is have a list of lists (a 2-tier hierarchy, I think is what you're asking for), just use XML instead.

<guid_lists>
    <guid_list>
        <guid value = '' />
        <guid value = '' />
        <guid value = '' />
        <guid value = '' />
    </guid_list>
    <guid_list>
        <guid value = '' />
        <guid value = '' />
        <guid value = '' />
        <guid value = '' />
    </guid_list>
</guid_lists>

If that isn't usable, you may need to clarify the purpose for using a USER TYPE.

answered Jun 6, 2013 at 17:32

tommy_o

3,8233 gold badges32 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

TSQL Creating a Table using another User Defined Type?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related