2 Replies Latest reply: Nov 26, 2012 10:43 AM by STEVEN GIORDANO IMBROLL RSS

    SQL Stored Procedure - How to call current date parameter

    STEVEN GIORDANO IMBROLL

      Hi Guys

       

      I have a stored proc which I want to run for 2 specific dates... which date is a parameter.

       

      currently im doing something like

       

       

      Let date = today();

      Let prevDate = AddMonths(Today(),-1);

       

       

      Pendinginv:

      LOAD *;SQL EXEC (DWH.dbo.gb_FI_CustomersStarRating $('date'));

       

      for some reason it is not executing it...it just jumps it.

       

      Help will be appriciated

       

      Steve