retrieving parent(ascendants)

i have a dimension named 'sdoc' which has 2 members
1) symptom word( first hierarchical level) and
2) doc id (second hierarchical level)

more than one 'symptom word' can have the same 'doc id'.
i want to know which all symptom words have a particular doc id (say 10.)
if i give [10].parent then it returns only the first parent whereas it actually has more than one parent.
how to retrieve all the parents.more than one 'symptom word' can have the same 'doc id'. So...there is a one-to-many relationship between 'doc id' and 'symptom word'?
if i give [10].parent then it returns only the first parent whereas it actually has more than one parent.So...there is a one-to-many relationship between 'symptom word' and 'doc id'?

Huh?

In database relationships, records normally have only one parent...

Please post the DDL code for the tables you are referencing, along with the SQL code you have tried.

Retrieving a saved MSSQL database from another hard drive after re-formatting

I had to re-format my main hard drive after a crash. How
can I restore the MSSQL database which I had saved in a
Backup on my second hatd drive? I had re-named my computer
the Operating System of which is Windows 2000
Professional. The CPU is an Intel Celeron 1.1 Ghz with 1.5
GB of RAM available.Install SQL Server again. Then use the RESTORE DATABASE command to restore your database backups.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"L. Dettering" <ldettering@.sympatico.ca> wrote in message news:15aa701c44711$534c6c30$a401280a@.phx.gbl...
> I had to re-format my main hard drive after a crash. How
> can I restore the MSSQL database which I had saved in a
> Backup on my second hatd drive? I had re-named my computer
> the Operating System of which is Windows 2000
> Professional. The CPU is an Intel Celeron 1.1 Ghz with 1.5
> GB of RAM available.
>

Retrieving a saved MSSQL database from another hard drive after re-formatting

I had to re-format my main hard drive after a crash. How
can I restore the MSSQL database which I had saved in a
Backup on my second hatd drive? I had re-named my computer
the Operating System of which is Windows 2000
Professional. The CPU is an Intel Celeron 1.1 Ghz with 1.5
GB of RAM available.Install SQL Server again. Then use the RESTORE DATABASE command to restore y
our database backups.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"L. Dettering" <ldettering@.sympatico.ca> wrote in message news:15aa701c44711$534c6c30$a40128
0a@.phx.gbl...
> I had to re-format my main hard drive after a crash. How
> can I restore the MSSQL database which I had saved in a
> Backup on my second hatd drive? I had re-named my computer
> the Operating System of which is Windows 2000
> Professional. The CPU is an Intel Celeron 1.1 Ghz with 1.5
> GB of RAM available.
>|||Install SQL Server again. Then use the RESTORE DATABASE command to
restore your
database backups.
I did that. Choosing Database, in Parameters, there's no 'First backup
to restore' shown and I'm required to select a backup to restore.
Choosing Filegroups of files instead of Database, I 'Select a subset of
backup sets' and for Selection Criteria, I select 'Only the backup sets
of the data files on drive F, and get this message: 'The current filter
excludes all existing backup sets. Change the filter to include at least
one backup set,' Checking, additionally, 'Only the backup sets completed
after 04/28/2004' (the last backup was on 04/29/2004), I get the same
message. Selecting 'Only backup sets of the following filegroups and
files', I can't enter the names of the filegroups and/or files.
If I select the F: drive where the files are saved in F:\Program
Files\Microsoft SQL Server\MSSQL\BACKUP\Data\DataFiles_Data.MDF, I'm
informed that it's not a valid Microsoft Tape Format backup set.
'RESTORE DATABASE is terminating abnormally'. '?
Could you help? I'm new at this!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Retrieving a saved MSSQL database from another hard drive after re-formatting

I had to re-format my main hard drive after a crash. How
can I restore the MSSQL database which I had saved in a
Backup on my second hatd drive? I had re-named my computer
the Operating System of which is Windows 2000
Professional. The CPU is an Intel Celeron 1.1 Ghz with 1.5
GB of RAM available.
Install SQL Server again. Then use the RESTORE DATABASE command to restore your database backups.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"L. Dettering" <ldettering@.sympatico.ca> wrote in message news:15aa701c44711$534c6c30$a401280a@.phx.gbl...
> I had to re-format my main hard drive after a crash. How
> can I restore the MSSQL database which I had saved in a
> Backup on my second hatd drive? I had re-named my computer
> the Operating System of which is Windows 2000
> Professional. The CPU is an Intel Celeron 1.1 Ghz with 1.5
> GB of RAM available.
>
|||Install SQL Server again. Then use the RESTORE DATABASE command to
restore your
database backups.
I did that. Choosing Database, in Parameters, there's no 'First backup
to restore' shown and I'm required to select a backup to restore.
Choosing Filegroups of files instead of Database, I 'Select a subset of
backup sets' and for Selection Criteria, I select 'Only the backup sets
of the data files on drive F, and get this message: 'The current filter
excludes all existing backup sets. Change the filter to include at least
one backup set,' Checking, additionally, 'Only the backup sets completed
after 04/28/2004' (the last backup was on 04/29/2004), I get the same
message. Selecting 'Only backup sets of the following filegroups and
files', I can't enter the names of the filegroups and/or files.
If I select the F: drive where the files are saved in F:\Program
Files\Microsoft SQL Server\MSSQL\BACKUP\Data\DataFiles_Data.MDF, I'm
informed that it's not a valid Microsoft Tape Format backup set.
'RESTORE DATABASE is terminating abnormally'. ??
Could you help? I'm new at this!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Retrieve data from second dataset

The stored procedure returns 2 datasets. Is there any way to use the second dataset in SSRS2005?

I believe only the first dataset gets retrieved. You would have to create a wrapper stored procedure that would toggle between datasets based on a parameter, and then create 2 separate calls in Reporting Services.

cheers,

Andrew