I need some help. This is going to be confusing so bare with me please!
I have a linked server and from what I read you cannot bring over multi-valued items. And one of the items I need has up to three values for the same variable. So I have objectClass listed three times on the server I am linked to with three different
values for objectClass.
-objectClass | hi
In the linked server data store objectClass is a list of schemas and in my SQL(2008) DB I just made a table names objectClasses with the data type NAME which is a nvarchar(MAX). I have an LDAP query that grabs all the NAMES from the objectClass table
on the linked server I'm connected to. and then inserts them into that table which was 700 records.
I created another table called Groups, and it has a column named objectClass which I made an nvarchar(MAX). I need a stored procedure, (was looking at one that used the Comma delimited list) that loops through the linked server data store and put the
three objectClass values in a string of some sort and then I can insert that one set of values into the Groups table.
I must do this through SQL, not .NET.
Anyone have an idea to help me out! Thanks!
View Complete Post