I have the following example, which is reaching the max recursion.
Declare @example table (RowID varchar(20), RelID varchar(20))
Insert Into @example Select 'Rec1', 'Rec5'
Insert Into @example Select 'Rec1', 'Rec6'
Insert Into @example Select 'Rec5', 'Rec1'
Insert Into @example Select 'Rec5', 'Rec2'
Insert Into @example Select 'Rec6', 'Rec1'
Insert Into @example Select 'Rec6', 'Rec3'
...
Canes816
Last Activity: Jul 20 '21, 04:45 PM
Joined: Nov 17 '06
Location:
-
Recursive CTE Permutations Help
-
From the permutations example you posted, it looks like you are using the string length to exit the recursion. In the data that I'm using, I'm trying to get all possible related values, but the relationship could be 1 or 2 (or multiple) levels away.
For example, how could I get the output below, from the table defined here?
Declare @example table (RowID varchar(10), RelID varchar(10))
Insert Into @example Select... -
Pass client side javascript variable to server side asp
I have a form where users can enter text in a text box as well as providing several other pieces of information. When they click a button, it calls a javascript function that opens a window with the text of the textbox.
What I would like to do instead is open a window pointing to an asp file with code to modify/manipulate the data from the textbox. Is this possible?
No activity results to display
Leave a comment: