Recent content by swiny

Hi I have a main report, that is passing a multiple value parameter to a subreport. When I run the subreport individually, I entered customer number as 902,904 Ran perfectly and brought me the data I need. However, when I pass the parameter from the main report. Nothing shows up on the main...

Thanks for all the reply. I have never used VBA in excel prior to this. Do you have a sample on how to open ado conn and calling a proc? Thanks.

Hi is there a way that a user can export excel file to sql monthly without using ssis/dts? (This could be manual... doesn't have to be automated.) User doesn't have acces to SQL Management studio. Thanks.

Hi I have the 2 tables below: TableA ReceiptNo ItemNumber Quantity 111 A 100 222 A 200 333 A 300 333 B 400 444 A 250 555 B 300 666 A 100 666 B 350 777 A...

Thanks for your reply.. If I want to do this in t-sql, can you create an easier script? Thanks...

Well, I need to backtrack an inventory on hand, meaning.. I need to start from the latest receipt number I had.. So, I need get the total of 900 on hand quantity, but, had to start from the latest receipt.. Example for A: I had to go to 777, and pick up 450, since 450 is still less than 900,I...

Hi I have the 2 tables below: TableA ReceiptNo ItemNumber Quantity 111 A 100 222 A 200 333 A 300 333 B 400 444 A 250 555 B 300 666 A 100 666 B 350 777...