parent child - get all children for a specific row

Hi,
I am trying to create a bulletinboard app. So I have a thread table
with parent/child relation.
How can I on a specific threadID get all its children ?
Any help/hints will be greatly appreciated :-)
Regards
SayaIf you have SQL Server 2005, check out "Common Table Expressions" in the
BOL.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Saya" <vaqas@.hotmail.com> wrote in message
news:1149257162.442872.321450@.i39g2000cwa.googlegroups.com...
Hi,
I am trying to create a bulletinboard app. So I have a thread table
with parent/child relation.
How can I on a specific threadID get all its children ?
Any help/hints will be greatly appreciated :-)
Regards
Saya

parent child - get all children for a specific row

Hi,
I am trying to create a bulletinboard app. So I have a thread table
with parent/child relation.
How can I on a specific threadID get all its children ?
Any help/hints will be greatly appreciated :-)
Regards
SayaIf you have SQL Server 2005, check out "Common Table Expressions" in the
BOL.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Saya" <vaqas@.hotmail.com> wrote in message
news:1149257162.442872.321450@.i39g2000cwa.googlegroups.com...
Hi,
I am trying to create a bulletinboard app. So I have a thread table
with parent/child relation.
How can I on a specific threadID get all its children ?
Any help/hints will be greatly appreciated :-)
Regards
Saya

Parameters Layers

Hi all!
I try to make a report with a that is releated to another parameter.
Eg:
Parents Parameters
- Month1
- Month2
- Year
Children Parameters
- USD_RATE
- EUR_RATE
This query is supposed to fill my @.USD_RATE and @.EUR_RATE:
SELECT AVG(USD) AS R_USD, AVG(EUR) AS R_EUR FROM ut_ChangeRate
WHERE (MM BETWEEN @.Month1 AND @.Month2) AND (YYYY = @.Year)
And when I pressed view report I get this error msg:
The USD_RATE parameter is missing a value.
It's the same for the other paramater but I don't get the message because it
stops at the first error encounter.
PLEASE HELP!!
Thanks
JulienOn Mar 22, 3:35 pm, "Julien Bonnier" <jul...@.m0851.com> wrote:
> Hi all!
> I try to make a report with a that is releated to another parameter.
> Eg:
> Parents Parameters
> - Month1
> - Month2
> - Year
> Children Parameters
> - USD_RATE
> - EUR_RATE
> This query is supposed to fill my @.USD_RATE and @.EUR_RATE:
> SELECT AVG(USD) AS R_USD, AVG(EUR) AS R_EUR FROM ut_ChangeRate
> WHERE (MM BETWEEN @.Month1 AND @.Month2) AND (YYYY = @.Year)
> And when I pressed view report I get this error msg:
> The USD_RATE parameter is missing a value.
> It's the same for the other paramater but I don't get the message because it
> stops at the first error encounter.
> PLEASE HELP!!
> Thanks
> Julien
Did you set Default and Available values (from Query) for USD_RATE and
EUR_RATE parameters? Also, make sure that @.Month1 and @.Month2 are set
in the datasets (select 'Edit Selected Dataset' [...] button on the
Data tab and select the Parameters tab and make sure that the Value
fields (for @.Month1 and @.Month2) are set to the correct parameters).
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Check for "Hidden" checkbox as well, then you get this msg.
Amarnath, MCTS
"Julien Bonnier" wrote:
> Hi all!
> I try to make a report with a that is releated to another parameter.
> Eg:
> Parents Parameters
> - Month1
> - Month2
> - Year
> Children Parameters
> - USD_RATE
> - EUR_RATE
>
> This query is supposed to fill my @.USD_RATE and @.EUR_RATE:
> SELECT AVG(USD) AS R_USD, AVG(EUR) AS R_EUR FROM ut_ChangeRate
> WHERE (MM BETWEEN @.Month1 AND @.Month2) AND (YYYY = @.Year)
> And when I pressed view report I get this error msg:
> The USD_RATE parameter is missing a value.
> It's the same for the other paramater but I don't get the message because it
> stops at the first error encounter.
> PLEASE HELP!!
> Thanks
> Julien
>
>