HI
I have create one store procedure and that proc i have declare cursor for fetch one bye one record and insert in another table ,i have passmeter as ldap path i m trying ldap inforation insert in my table.check below proc tell what i do
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)
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
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
end
close cur_insert_data
deallocate cur_insert_data
end
---------------------------------------------
exec proc_inser_data LDAP://DC=xxx,DC=com
Thanks
SagarP
http://www.emanonsolutions.net
http://emanonsolutions.blogspot.com/