Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.sqlserver.programming > #31266
| X-Received | by 10.182.39.138 with SMTP id p10mr7554782obk.5.1438772792552; Wed, 05 Aug 2015 04:06:32 -0700 (PDT) |
|---|---|
| X-Received | by 10.182.209.6 with SMTP id mi6mr43412obc.27.1438772792499; Wed, 05 Aug 2015 04:06:32 -0700 (PDT) |
| Path | csiph.com!optima2.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!pg9no7233483igb.0!news-out.google.com!nt1ni154igb.0!nntp.google.com!f3no7809053igg.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail |
| Newsgroups | microsoft.public.sqlserver.programming |
| Date | Wed, 5 Aug 2015 04:06:32 -0700 (PDT) |
| In-Reply-To | <XnsA4ED84D0A42D5Yazorman@127.0.0.1> |
| Complaints-To | groups-abuse@google.com |
| Injection-Info | glegroupsg2000goo.googlegroups.com; posting-host=115.248.211.41; posting-account=UdCuKwoAAAB0-uLpIoFcSSp1N3kkQ94p |
| NNTP-Posting-Host | 115.248.211.41 |
| References | <ee908b1e-167e-466e-9c16-9d1482d15e6e@googlegroups.com> <XnsA4ED6A4C86392Yazorman@127.0.0.1> <be26cc37-5b4d-495a-a274-4b1bd7043293@googlegroups.com> <XnsA4ED84D0A42D5Yazorman@127.0.0.1> |
| User-Agent | G2/1.0 |
| MIME-Version | 1.0 |
| Message-ID | <96f2781c-306a-4c7e-99a5-6cdc416a3bc0@googlegroups.com> (permalink) |
| Subject | Re: Need to fetch data recursively from a table |
| From | siddhant agarwal <siddhant171990@gmail.com> |
| Injection-Date | Wed, 05 Aug 2015 11:06:32 +0000 |
| Content-Type | text/plain; charset=ISO-8859-1 |
| Xref | csiph.com microsoft.public.sqlserver.programming:31266 |
Show key headers only | 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 | Unroll 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