Topic
  • No replies
pennahb
pennahb
20 Posts

Pinned topic How to resolve broken query subjects when importing a stored procedure in FWM?

‏2013-04-16T21:00:32Z |

Hi,

I have imported a Stored procedure in to FWM, it has broken the query subjects.

My Requirement is to through Report studio user will enter some amount that has to store in Database (Sql server 2008 R2) table to show in a Report.

Here is the Stored Procedure i have written. Let me know is there any syntax issues are there to broken the query subjects. or any suggestions are appreciated.

CREATE PROCEDURE OrgUpdate
 
 @BIENNIUM_ID int,
 @FSCL_MNTH_ID int,
 @FSCL_REGION_ID int,
 @FSCL_ORG_INDX_ID int,
 @FSCL_ORG_INDX_CD char(4),
 @FSCL_ORG_INDX_DESC varchar(50),
 @Allotment_Amt decimal(13, 2)
AS
BEGIN
 Update dbo.Organization_Level_Allotment
 SET Allotment_Amt=@Allotment_Amt
 where
    BIENNIUM_ID=@BIENNIUM_ID And
    FSCL_MNTH_ID=@FSCL_MNTH_ID And
    FSCL_REGION_ID=@FSCL_REGION_ID And
    FSCL_ORG_INDX_ID=@FSCL_ORG_INDX_ID
   
END
GO