How To Declare Use Arrays in Stored Procedures?
-
Actually, i have to iterate through the table records to find the childs of a given parent id. a table has three columns.. userid---username----parentid 1 munawar null 2 hussain null 3 ali 1 4 Wajid 3 5 waheed 2 6 asif 4 7 hafeez 6 if i give id 1..it mean its parent and i want to find all its childs.....and subchilds at all levels.... All this have to do inside a stored procedure... can u solve it.. thanks:rose:
-
Actually, i have to iterate through the table records to find the childs of a given parent id. a table has three columns.. userid---username----parentid 1 munawar null 2 hussain null 3 ali 1 4 Wajid 3 5 waheed 2 6 asif 4 7 hafeez 6 if i give id 1..it mean its parent and i want to find all its childs.....and subchilds at all levels.... All this have to do inside a stored procedure... can u solve it.. thanks:rose:
-
Dear, thanks for Query...im using Microsoft SQL Server 2000 stored procedures are in TSQL. let me know if u know... munawar