Hi create produre in that proc i declare cusor and that cursor i have call another procdure it not working.i will try LDAP data insert in my table using custor pass LDAP address as paramete.reply how can do it?
this My proc
ALTER procedure [dbo].[proc_inser_data]
@adspath varchar(400)
as
declare @streetAddress nvarchar(250),@mobile int,@mail nvarchar(256),
@department nvarchar(256),
@sn nvarchar(256),@givenName nvarchar(256),@sAMAccountName nvarchar(256),@objectGUID uniqueidentifier
declare cur_insert_data cursor for
declare @adsiquery as nvarchar(4000)
set
@adsiquery='(
SELECT
*
FROM openquery
(ADSI, ''SELECT STREETADDRESS,MOBILE,MAIL,DEPARTMENT,SN,GIVENNAME,SAMACCOUNTNAME
FROM '''''+@adspath+'''''
WHERE
objectClass=''''user''''
'')
)'
begin
open cur_insert_data
fetch next from cur_insert_data
into
@streetAddress,@mobile,@mail,@department,@sn,@givenName,@sAMAccountName,@objectGUID
while @@fetch_status=0
begin
insert into table1
(address,Mobile,Email,Department,LastName,FirstName,AccountName)
values
(@streetAddress,@mobile,@mail,@department,@sn,@givenName,@sAMAccountName)
fetch next from cur_insert_data
into
@streetAddress,@mobile,@mail,@department,@sn,@givenName,@sAMAccountName,@objectGUID
end
close cur_insert_data
deallocate cur_insert_data
end
-------------------------------
proc_inser_data LDAP://DC=xxxx,DC=com'
-------------------------
Thanks
sagar
Thanks
SagarP
http://www.emanonsolutions.net
http://emanonsolutions.blogspot.com/