Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SHAPE using more than one stored procedures

Author  Topic 

uberbloke
Yak Posting Veteran

67 Posts

Posted - 2001-07-04 : 05:49:33
I have had a look through the forums and found some useful stuff on data shapeing (Hierarchical Rowsets) and have got SHAPE working with the first part of shape using a stored proc and the second using direct sql statements
 SHAPE { storedproc call} 
APPEND ({select this from tablename}
AS columnName RELATE this TO that)


has anyone got SHAPE to work with BOTH elements being stored proc calls

 SHAPE { storedproc1 } 
APPEND ({ storedproc2 }
AS columnName RELATE this TO that)


I realise this is more an oledb/data provider question, but I live in hope (got to, I go scuba diving )

   

- Advertisement -