Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.sqlserver.programming > #31266

Re: Need to fetch data recursively from a table

Show all headers | View raw

On Wednesday, 5 August 2015 16:33:24 UTC+5:30, Erland Sommarskog  wrote:
> (siddhant171990@gmail.com) writes:
> >  - First, Find projects related to original set of features. Each
> >  feature can relate to only instance of a project. But, it can relate to
> >  many projects. 
> 
> So this is illegal?
> 
> INSERT tbl(feature, project, instance)
>   VALUES ('FTR1', 'A', 1),
>          ('FTR1', 'A', 2)
> 
> But this is legal?
> 
> INSERT tbl(feature, project, instance)
>   VALUES ('FTR1', 'A', 1),
>          ('FTR1', 'B', 1)
> 
> 
> That is, the instance relates to the project alone?
> 
> > - Secondly, since some other instance of the projects found above may be
> > related to some features, I need to identify those features as well and
> > any other projects which these features are also related too. This will
> > go on recursively. 
> > 
> > - Thirdly, every time we fetch features for the projects, we fetch only
> > those features that use the instance of the projects greater than the on
> > found already. 
> > 
> > - All in all, there should be some path starting for the initial feature
> > list to all records. 
> 
> Please supply a wider set of test data with the expected results. This 
> helps to clarify your description.
> 
> 
> 
> -- 
> Erland Sommarskog, Stockholm, esquel@sommarskog.se

Yes, you cannot have 2 instances of the same project related to same feature. 

Back to microsoft.public.sqlserver.programming | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Need to fetch data recursively from a table siddhant171990@gmail.com - 2015-08-04 23:20 -0700
  Re: Need to fetch data recursively from a table Erland Sommarskog <esquel@sommarskog.se> - 2015-08-05 10:26 +0200
    Re: Need to fetch data recursively from a table siddhant171990@gmail.com - 2015-08-05 01:57 -0700
      Re: Need to fetch data recursively from a table Erland Sommarskog <esquel@sommarskog.se> - 2015-08-05 13:03 +0200
        Re: Need to fetch data recursively from a table siddhant agarwal <siddhant171990@gmail.com> - 2015-08-05 04:06 -0700
    Re: Need to fetch data recursively from a table siddhant171990@gmail.com - 2015-08-05 02:38 -0700

csiph-web