"BeteNoir" <BeteNoir_2001@yahoo.com> wrote in message
news:So15c.3323$GQ3.3151@newsread3.news.atl.earthlink.net...
> Hi all,
>
> I've installed RAC4SQL2K all the way up to the 2.2.1 update.
>
> The first crosstab I produced using RAC4SQL2K works perfectly. It's called
> from the following stored procedure:
>
> ----------
> CREATE PROCEDURE [dbo].[spPageAccess] AS
> Execute rac
> @transform = 'COUNT([PageAccess].[PageAccessID]) as PageAccessCount'
> ,@rows = '[PageHW].[PageID] & [PageHW].[PageName]'
> ,@pvtcol = '[GroupHW].[GroupID]'
> ,@racheck = 'y'
> ,@from = '[PageHW], [PageAccess], [GroupHW]'
> ,@where = '([PageHW].[PageID] = [PageAccess].[PageID]) AND
> ([PageAccess].[GroupID] = [GroupHW].[GroupID])'
> ,@shell='n'
> ,@row_totals='n'
> ,@grand_totals='n'
> GO
> ----------
>
> The trouble is on my second crosstab, which I contructed identically to the
> first:
>
> ----------
> CREATE PROCEDURE [dbo].[spObjectAccess] AS
> Execute rac
> @transform = 'COUNT([ObjectAccess].[ObjectAccessID]) as ObjectAccessCount'
> ,@rows = '[ObjectHW].[ObjectID] & [ObjectHW].[ObjectName]'
> ,@pvtcol = '[GroupHW].[GroupID]'
> ,@racheck = 'y'
> ,@from = '[ObjectHW], [ObjectAccess], [GroupHW]'
> ,@where = '([ObjectHW].[ObjectID] = [ObjectAccess].[ObjectID]) AND
> ([ObjectAccess].[GroupID] = [GroupHW].[GroupID])'
> ,@shell='n'
> ,@row_totals='n'
> ,@grand_totals='n'
> GO
> ----------
>
> This second stored procedure gives the following error:
>
> "Server: Msg 1906, Level 11, State 1, Line 1
> Cannot create an index on '##rac54', because this table does not exist in
> database 'HWInv'."
>
> I can't figure out why the first procedure works great, and the 2nd one
> doesn't.
>
> Is there enough from what I've provided here for anyone to tell me what is
> causing this error, and how to fix?
>
> Any help at all would be really appreciated!
>
> TIA -
> Philippe
>
>