report builder and stored procedure

I am trying to build a report model. I have a stored procedure that return a
result set. I created a Named Query to exec the stored procedure. But when
I clicked OK, it gave me this error: Please help.
TITLE: Microsoft Visual Studio
--
Cannot create the named query using the specified query definition.
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
--
ADDITIONAL INFORMATION:
Incorrect syntax near the keyword 'EXEC'.
The following statement executed when creating named query:
SELECT [EBB].*
FROM
(
EXEC EDJUNK
)
AS [EBB] (Microsoft.AnalysisServices.Controls)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
--
Incorrect syntax near the keyword 'EXEC'. (Microsoft SQL Server, Error: 156)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=156&LinkId=20476
--
BUTTONS:
OK
--dear Ed when u use exec u can't use this format: SELECT * FROM (EXEC SP)
cause exec doesn't return resultset(look in BOL).
if u want 2 use SP just write the name of the sp and it work...
"Ed" wrote:
> I am trying to build a report model. I have a stored procedure that return a
> result set. I created a Named Query to exec the stored procedure. But when
> I clicked OK, it gave me this error: Please help.
> TITLE: Microsoft Visual Studio
> --
> Cannot create the named query using the specified query definition.
>
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> Incorrect syntax near the keyword 'EXEC'.
> The following statement executed when creating named query:
> SELECT [EBB].*
> FROM
> (
> EXEC EDJUNK
> )
> AS [EBB] (Microsoft.AnalysisServices.Controls)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
> --
> Incorrect syntax near the keyword 'EXEC'. (Microsoft SQL Server, Error: 156)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=156&LinkId=20476
> --
> BUTTONS:
> OK
> --
>|||Thanks...I will try
"ש×?×?×?" wrote:
> dear Ed when u use exec u can't use this format: SELECT * FROM (EXEC SP)
> cause exec doesn't return resultset(look in BOL).
> if u want 2 use SP just write the name of the sp and it work...
> "Ed" wrote:
> > I am trying to build a report model. I have a stored procedure that return a
> > result set. I created a Named Query to exec the stored procedure. But when
> > I clicked OK, it gave me this error: Please help.
> >
> > TITLE: Microsoft Visual Studio
> > --
> >
> > Cannot create the named query using the specified query definition.
> >
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
> >
> > --
> > ADDITIONAL INFORMATION:
> >
> > Incorrect syntax near the keyword 'EXEC'.
> > The following statement executed when creating named query:
> >
> > SELECT [EBB].*
> > FROM
> > (
> > EXEC EDJUNK
> > )
> > AS [EBB] (Microsoft.AnalysisServices.Controls)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
> >
> > --
> >
> > Incorrect syntax near the keyword 'EXEC'. (Microsoft SQL Server, Error: 156)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=156&LinkId=20476
> >
> > --
> > BUTTONS:
> >
> > OK
> > --
> >|||Aloha, I tried just put in the sp name and when I clicked ok, it gave me this
error:
TITLE: Microsoft Visual Studio
--
Cannot create the named query using the specified query definition.
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
--
ADDITIONAL INFORMATION:
Line 6: Incorrect syntax near ')'.
The following statement executed when creating named query:
SELECT [Retail Items Qty By Sites].*
FROM
(
RETAIL_ITEM_QTY
)
AS [Retail Items Qty By Sites] (Microsoft.AnalysisServices.Controls)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
--
Line 6: Incorrect syntax near ')'. (Microsoft SQL Server, Error: 170)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=170&LinkId=20476
--
BUTTONS:
OK
--
"ש×?×?×?" wrote:
> dear Ed when u use exec u can't use this format: SELECT * FROM (EXEC SP)
> cause exec doesn't return resultset(look in BOL).
> if u want 2 use SP just write the name of the sp and it work...
> "Ed" wrote:
> > I am trying to build a report model. I have a stored procedure that return a
> > result set. I created a Named Query to exec the stored procedure. But when
> > I clicked OK, it gave me this error: Please help.
> >
> > TITLE: Microsoft Visual Studio
> > --
> >
> > Cannot create the named query using the specified query definition.
> >
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
> >
> > --
> > ADDITIONAL INFORMATION:
> >
> > Incorrect syntax near the keyword 'EXEC'.
> > The following statement executed when creating named query:
> >
> > SELECT [EBB].*
> > FROM
> > (
> > EXEC EDJUNK
> > )
> > AS [EBB] (Microsoft.AnalysisServices.Controls)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
> >
> > --
> >
> > Incorrect syntax near the keyword 'EXEC'. (Microsoft SQL Server, Error: 156)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=156&LinkId=20476
> >
> > --
> > BUTTONS:
> >
> > OK
> > --
> >|||hi do u have already this sp?
is your datasource correct?
"Ed" wrote:
> Aloha, I tried just put in the sp name and when I clicked ok, it gave me this
> error:
> TITLE: Microsoft Visual Studio
> --
> Cannot create the named query using the specified query definition.
>
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> Line 6: Incorrect syntax near ')'.
> The following statement executed when creating named query:
> SELECT [Retail Items Qty By Sites].*
> FROM
> (
> RETAIL_ITEM_QTY
> )
> AS [Retail Items Qty By Sites] (Microsoft.AnalysisServices.Controls)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
> --
> Line 6: Incorrect syntax near ')'. (Microsoft SQL Server, Error: 170)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=170&LinkId=20476
> --
> BUTTONS:
> OK
> --
>
> "ש×?×?×?" wrote:
> > dear Ed when u use exec u can't use this format: SELECT * FROM (EXEC SP)
> > cause exec doesn't return resultset(look in BOL).
> > if u want 2 use SP just write the name of the sp and it work...
> >
> > "Ed" wrote:
> >
> > > I am trying to build a report model. I have a stored procedure that return a
> > > result set. I created a Named Query to exec the stored procedure. But when
> > > I clicked OK, it gave me this error: Please help.
> > >
> > > TITLE: Microsoft Visual Studio
> > > --
> > >
> > > Cannot create the named query using the specified query definition.
> > >
> > >
> > > For help, click:
> > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
> > >
> > > --
> > > ADDITIONAL INFORMATION:
> > >
> > > Incorrect syntax near the keyword 'EXEC'.
> > > The following statement executed when creating named query:
> > >
> > > SELECT [EBB].*
> > > FROM
> > > (
> > > EXEC EDJUNK
> > > )
> > > AS [EBB] (Microsoft.AnalysisServices.Controls)
> > >
> > > For help, click:
> > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
> > >
> > > --
> > >
> > > Incorrect syntax near the keyword 'EXEC'. (Microsoft SQL Server, Error: 156)
> > >
> > > For help, click:
> > > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=156&LinkId=20476
> > >
> > > --
> > > BUTTONS:
> > >
> > > OK
> > > --
> > >|||Yes...it even works when I clicked the run button in where I built the name
query.
"ש×?×?×?" wrote:
> hi do u have already this sp?
> is your datasource correct?
> "Ed" wrote:
> > Aloha, I tried just put in the sp name and when I clicked ok, it gave me this
> > error:
> >
> > TITLE: Microsoft Visual Studio
> > --
> >
> > Cannot create the named query using the specified query definition.
> >
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
> >
> > --
> > ADDITIONAL INFORMATION:
> >
> > Line 6: Incorrect syntax near ')'.
> > The following statement executed when creating named query:
> >
> > SELECT [Retail Items Qty By Sites].*
> > FROM
> > (
> > RETAIL_ITEM_QTY
> > )
> > AS [Retail Items Qty By Sites] (Microsoft.AnalysisServices.Controls)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
> >
> > --
> >
> > Line 6: Incorrect syntax near ')'. (Microsoft SQL Server, Error: 170)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=170&LinkId=20476
> >
> > --
> > BUTTONS:
> >
> > OK
> > --
> >
> >
> > "ש×?×?×?" wrote:
> >
> > > dear Ed when u use exec u can't use this format: SELECT * FROM (EXEC SP)
> > > cause exec doesn't return resultset(look in BOL).
> > > if u want 2 use SP just write the name of the sp and it work...
> > >
> > > "Ed" wrote:
> > >
> > > > I am trying to build a report model. I have a stored procedure that return a
> > > > result set. I created a Named Query to exec the stored procedure. But when
> > > > I clicked OK, it gave me this error: Please help.
> > > >
> > > > TITLE: Microsoft Visual Studio
> > > > --
> > > >
> > > > Cannot create the named query using the specified query definition.
> > > >
> > > >
> > > > For help, click:
> > > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
> > > >
> > > > --
> > > > ADDITIONAL INFORMATION:
> > > >
> > > > Incorrect syntax near the keyword 'EXEC'.
> > > > The following statement executed when creating named query:
> > > >
> > > > SELECT [EBB].*
> > > > FROM
> > > > (
> > > > EXEC EDJUNK
> > > > )
> > > > AS [EBB] (Microsoft.AnalysisServices.Controls)
> > > >
> > > > For help, click:
> > > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
> > > >
> > > > --
> > > >
> > > > Incorrect syntax near the keyword 'EXEC'. (Microsoft SQL Server, Error: 156)
> > > >
> > > > For help, click:
> > > > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=156&LinkId=20476
> > > >
> > > > --
> > > > BUTTONS:
> > > >
> > > > OK
> > > > --
> > > >|||Hi Ed
Make sure your command type is set to Stored Procedure and not Text.
"Ed" wrote:
> Yes...it even works when I clicked the run button in where I built the name
> query.
> "ש×?×?×?" wrote:
> > hi do u have already this sp?
> > is your datasource correct?
> >
> > "Ed" wrote:
> >
> > > Aloha, I tried just put in the sp name and when I clicked ok, it gave me this
> > > error:
> > >
> > > TITLE: Microsoft Visual Studio
> > > --
> > >
> > > Cannot create the named query using the specified query definition.
> > >
> > >
> > > For help, click:
> > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
> > >
> > > --
> > > ADDITIONAL INFORMATION:
> > >
> > > Line 6: Incorrect syntax near ')'.
> > > The following statement executed when creating named query:
> > >
> > > SELECT [Retail Items Qty By Sites].*
> > > FROM
> > > (
> > > RETAIL_ITEM_QTY
> > > )
> > > AS [Retail Items Qty By Sites] (Microsoft.AnalysisServices.Controls)
> > >
> > > For help, click:
> > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
> > >
> > > --
> > >
> > > Line 6: Incorrect syntax near ')'. (Microsoft SQL Server, Error: 170)
> > >
> > > For help, click:
> > > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=170&LinkId=20476
> > >
> > > --
> > > BUTTONS:
> > >
> > > OK
> > > --
> > >
> > >
> > > "ש×?×?×?" wrote:
> > >
> > > > dear Ed when u use exec u can't use this format: SELECT * FROM (EXEC SP)
> > > > cause exec doesn't return resultset(look in BOL).
> > > > if u want 2 use SP just write the name of the sp and it work...
> > > >
> > > > "Ed" wrote:
> > > >
> > > > > I am trying to build a report model. I have a stored procedure that return a
> > > > > result set. I created a Named Query to exec the stored procedure. But when
> > > > > I clicked OK, it gave me this error: Please help.
> > > > >
> > > > > TITLE: Microsoft Visual Studio
> > > > > --
> > > > >
> > > > > Cannot create the named query using the specified query definition.
> > > > >
> > > > >
> > > > > For help, click:
> > > > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
> > > > >
> > > > > --
> > > > > ADDITIONAL INFORMATION:
> > > > >
> > > > > Incorrect syntax near the keyword 'EXEC'.
> > > > > The following statement executed when creating named query:
> > > > >
> > > > > SELECT [EBB].*
> > > > > FROM
> > > > > (
> > > > > EXEC EDJUNK
> > > > > )
> > > > > AS [EBB] (Microsoft.AnalysisServices.Controls)
> > > > >
> > > > > For help, click:
> > > > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
> > > > >
> > > > > --
> > > > >
> > > > > Incorrect syntax near the keyword 'EXEC'. (Microsoft SQL Server, Error: 156)
> > > > >
> > > > > For help, click:
> > > > > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=156&LinkId=20476
> > > > >
> > > > > --
> > > > > BUTTONS:
> > > > >
> > > > > OK
> > > > > --
> > > > >|||I didn't see a place I can specify sp or text when I created the named query.
"Shawn Kralj" wrote:
> Hi Ed
> Make sure your command type is set to Stored Procedure and not Text.
> "Ed" wrote:
> > Yes...it even works when I clicked the run button in where I built the name
> > query.
> >
> > "ש×?×?×?" wrote:
> >
> > > hi do u have already this sp?
> > > is your datasource correct?
> > >
> > > "Ed" wrote:
> > >
> > > > Aloha, I tried just put in the sp name and when I clicked ok, it gave me this
> > > > error:
> > > >
> > > > TITLE: Microsoft Visual Studio
> > > > --
> > > >
> > > > Cannot create the named query using the specified query definition.
> > > >
> > > >
> > > > For help, click:
> > > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
> > > >
> > > > --
> > > > ADDITIONAL INFORMATION:
> > > >
> > > > Line 6: Incorrect syntax near ')'.
> > > > The following statement executed when creating named query:
> > > >
> > > > SELECT [Retail Items Qty By Sites].*
> > > > FROM
> > > > (
> > > > RETAIL_ITEM_QTY
> > > > )
> > > > AS [Retail Items Qty By Sites] (Microsoft.AnalysisServices.Controls)
> > > >
> > > > For help, click:
> > > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
> > > >
> > > > --
> > > >
> > > > Line 6: Incorrect syntax near ')'. (Microsoft SQL Server, Error: 170)
> > > >
> > > > For help, click:
> > > > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=170&LinkId=20476
> > > >
> > > > --
> > > > BUTTONS:
> > > >
> > > > OK
> > > > --
> > > >
> > > >
> > > > "ש×?×?×?" wrote:
> > > >
> > > > > dear Ed when u use exec u can't use this format: SELECT * FROM (EXEC SP)
> > > > > cause exec doesn't return resultset(look in BOL).
> > > > > if u want 2 use SP just write the name of the sp and it work...
> > > > >
> > > > > "Ed" wrote:
> > > > >
> > > > > > I am trying to build a report model. I have a stored procedure that return a
> > > > > > result set. I created a Named Query to exec the stored procedure. But when
> > > > > > I clicked OK, it gave me this error: Please help.
> > > > > >
> > > > > > TITLE: Microsoft Visual Studio
> > > > > > --
> > > > > >
> > > > > > Cannot create the named query using the specified query definition.
> > > > > >
> > > > > >
> > > > > > For help, click:
> > > > > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=CannotCreateNamedQuery&LinkId=20476
> > > > > >
> > > > > > --
> > > > > > ADDITIONAL INFORMATION:
> > > > > >
> > > > > > Incorrect syntax near the keyword 'EXEC'.
> > > > > > The following statement executed when creating named query:
> > > > > >
> > > > > > SELECT [EBB].*
> > > > > > FROM
> > > > > > (
> > > > > > EXEC EDJUNK
> > > > > > )
> > > > > > AS [EBB] (Microsoft.AnalysisServices.Controls)
> > > > > >
> > > > > > For help, click:
> > > > > > http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Controls.ControlsSR&EvtID=ShowSQL&LinkId=20476
> > > > > >
> > > > > > --
> > > > > >
> > > > > > Incorrect syntax near the keyword 'EXEC'. (Microsoft SQL Server, Error: 156)
> > > > > >
> > > > > > For help, click:
> > > > > > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=156&LinkId=20476
> > > > > >
> > > > > > --
> > > > > > BUTTONS:
> > > > > >
> > > > > > OK
> > > > > > --
> > > > > >