Post reply

Please help WHERE CLAUSE

  • June 11, 2010 at 8:18 am

    #1179214

    Thanks Sir

  • June 11, 2010 at 8:21 am

    #1179216

    davidshephard (6/11/2010)

    Thanks Sir

    :w00t:

    That avatar photo is a bit misleading... Gail is well, more of the female type 😉

  • June 11, 2010 at 8:24 am

    #1179218

    OK thanks MY LADY..:-):-)

  • June 16, 2010 at 2:08 pm

    #1181274

    This works fine in SQL 2005 QUERY TOOL but in SQL 2005 REPORTING SERVICE I GET THIS PROMPT:

    Please see attachment..

  • June 16, 2010 at 2:42 pm

    #1181283

    A 5 MB word document? Save the image as a jpg or png and attach that.

    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

  • June 17, 2010 at 8:37 am

    #1181606

    Here's the screen shot in a zip file...

  • June 17, 2010 at 9:00 am

    #1181625

    Try query type : procedure

    then put

    dbo.stp_deliverystatus

    as the datasource

    then you should get the promt to manually enter the 2 parameters once so that BIDS can download the dataset properties and set the parameters.

Viewing 7 posts - 16 through 21 (of 21 total)

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