Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Is it possible to solve this Issue using SQL
It works, I believe recursion is the only feasible solution for this. Thanks a TON Mr. Terry L broadbent. alter proc tmp_GetAllChildrenFromParent @iPrmShowCaseCategoryID int as declare @iFirstTimeFlag int select @iFirstTimeFlag = 0 set nocount on DECLARE Product_Cursor CURSOR LOCAL...- Shreyas
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Is it possible to solve this Issue using SQL
Hi All, Here is the description of the problem : Child Parent 16 9 17 9 18 16 19 17 Now the deal is I'll get on parent key from which I need to pull out all its children and obviously I do not know many children one parent can have. Can somebody tell me a...- Shreyas
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
