Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: swiny
  • Order by date
  1. swiny

    Passing Multiple Parameters from Main report to subreport to proc

    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...
  2. swiny

    Excel to SQL

    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.
  3. swiny

    Excel to SQL

    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.
  4. swiny

    Listing detail based on a total and running sum

    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...
  5. swiny

    Running Sum Calculation

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

    Running Sum Calculation

    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...
  7. swiny

    Running Sum Calculation

    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...

Part and Inventory Search

Back
Top