Viewing 12 posts - 1 through 12 (of 12 total)
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 =...
December 14, 2006 at 3:54 pm
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...
December 13, 2006 at 1:54 pm
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...
December 5, 2006 at 9:38 am
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...
November 30, 2006 at 11:05 am
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!
November 30, 2006 at 10:37 am
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...
November 28, 2006 at 1:27 pm
Thank you both of you for the explanation.
Regards,
Sankar
November 16, 2006 at 9:24 am
sorry to bump in..what is a calendar table..(ignore my ignorance)
Thanks,
Sankar
November 16, 2006 at 8:58 am
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
November 16, 2006 at 8:42 am
did u notice this, may be this will help.. you r missing the ' ' for all varchars
ex: SET CustomerReference = '@CustomerReference'
Thanks,
November 16, 2006 at 8:29 am
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...
November 9, 2006 at 8:09 am
never mind..figured it out..(used the visibility property) to do it.
November 2, 2006 at 3:00 pm
Viewing 12 posts - 1 through 12 (of 12 total)