Forum Replies Created

Viewing 12 posts - 1 through 12 (of 12 total)

  • RE: help on query..

    Thanks John..the update for date worked perfect..the one for quantity failed..but made a small change to ur query and it worked fine too..

    i modified it as

    update @table

    set Qty =...

  • RE: error 401

    i think the error is due to not supplying credentials..when you work in your test machine, does your machine account is associated with SQL Server RS?. if so, putting on...

  • RE: Query help

    Thanks Ninja's it worked well.! There is no product info table. This is the only table with all the information. this database gets populated on a daily basis from another...

  • RE: Date question

    i have another question now..dont know if this is a right place to post..

    How would one do a parameter validation in sql reporting services. For ex: If I have a...

  • RE: Date question

    Thanks dave. worked like a charm. I am also thinking about the second option you mentioned...Both the options work.I dont know how they need it..anyways,Thanks a lot!

  • RE: select top 10 and more.

    thanks both for the reply.

    The query is used for generating a report using sql reporting services. I am using 2 databases to generate one report.

    I have a query tht is...

  • RE: T-SQL Help

    Thank you both of you for the explanation.

    Regards,

    Sankar

  • RE: T-SQL Help

    sorry to bump in..what is a calendar table..(ignore my ignorance)

    Thanks,

    Sankar

  • RE: Procedure ''''xyz'''' expects parameter ''''@abc'''', which was not supplied

    oh ok..! noted that..i dont see any problem why the code fails..just thought it could be with the SP's ''...thanks for letting me know

  • RE: Procedure ''''xyz'''' expects parameter ''''@abc'''', which was not supplied

    did u notice this, may be this will help.. you r missing the ' ' for all varchars

    ex: SET CustomerReference = '@CustomerReference'

    Thanks,

  • RE: Unable to connect to remote server

    Thanks for your reply. The server is located in a different location. I see a page under construction message and i dont think i have permissions to check what you...

  • RE: Enable drilldown

    never mind..figured it out..(used the visibility property) to do it.

Viewing 12 posts - 1 through 12 (of 12 total)