Forum Home
Press F1
 
Thread ID: 56541 2005-04-08 03:50:00 SQL Server, Dynamic Array of Array loading question CreightonBrown (5692) Press F1
Post ID Timestamp Content User
342687 2005-04-08 03:50:00 SQL Server, Dynamic Array of Array loading question



--
--Question
--
-- How to load in array from @value
-- Or is there another way?
--

--@12 will be an array type, array of array
Declare @12 varchar(200)
Set @12='(1,2,3)'

if (@12<>null)
BEGIN
Select 12 from FlatArrayMetaType
inner join FlatArrMetaTypeDataUserData on FlatArrMetaTypeDataUserData.FlatArrayMetaTypeID=Fl atArrayMetaType.FlatArrayMetaTypeID
inner join Flat on FlatArrMetaTypeDataUserData.flatid =flat.flatid
--
-- (1,2,3) works
--
where FlatArrMetaTypeDataUserData in (1,2,3)
END


--@12 will be an array type, array of array
Declare @12 varchar(200)
Set @12='(1,2,3)'
if (@12<>null)
BEGIN
Select 12 from FlatArrayMetaType
inner join FlatArrMetaTypeDataUserData on FlatArrMetaTypeDataUserData.FlatArrayMetaTypeID=Fl atArrayMetaType.FlatArrayMetaTypeID
inner join Flat on FlatArrMetaTypeDataUserData.flatid =flat.flatid
--
-- @12 doesn't work
--
where FlatArrMetaTypeDataUserData in @12
END 		CreightonBrown (5692)
1