Post reply

Date error

  • December 29, 2010 at 1:33 pm

    #229992

    dataset1:

    SELECT A.CODE, A."ACCOUNT"

    FROM CIRC.SUBS_TAG A, DSIPROC.TRB_VW_SUBS_INFO B, CIRC.TAG C

    WHERE A."ACCOUNT" = B."ACCOUNT" AND A.CODE = C.CODE and a.ENTRY_DATE between @startdate and @Enddate

    In the parameters i have startdate and Enddate defined with a new dataset.

    I get "query failed for dataset "dataset1" ". Where did i go wrong. Please help me thank you.

  • December 29, 2010 at 2:03 pm

    #1267427

    Oracle or SQL Server backend for the report? Your earlier post (http://www.sqlservercentral.com/Forums/Topic1040466-392-1.aspx) was for Oracle.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 29, 2010 at 2:11 pm

    #1267430

    GilaMonster (12/29/2010)

    Oracle or SQL Server backend for the report? Your earlier post (http://www.sqlservercentral.com/Forums/Topic1040466-392-1.aspx) was for Oracle.

    It's Oracle. Thanks for your response.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply