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: Ty1
  • Order by date
  1. Ty1

    Newbie- How do I use request.form in asp

    I am trying to check and see if a checkbox has been selected. The checkbox is an array, there are multiple checkbox' for each transaction line. The checkbox is out to the side and they select it if the transaction was a returned check. The following is my code: dim nsfCheck(100) dim nsfChecked...
  2. Ty1

    How do I use a checkbox in ASP

    I am attempting to see if a user has selected a checkbox and if they did, update two database tables and gray out the checkbox so that it remained checked and cannot be changed on another screen. Here is my code so far: 'Declare variable dim nsfCheck 'Initialize variable nsfCheck = False...
  3. Ty1

    CASE statement to increment trhough record and add to balance

    Thanks AlexCuse, Rac2, CatAdmin, and ESquared for all of your help. I agree, that this will probably be better done with a stored procedure, however, I have not written a stored procedure in SQL before, so forgive me for thinking that this is what I was doing. Any suggestions? Also, to answer...
  4. Ty1

    CASE statement to increment trhough record and add to balance

    Running it with: END as RunningBalance END as Running_Balance gives me this message: "Incorrect syntax near the keyword AS
  5. Ty1

    CASE statement to increment trhough record and add to balance

    Alex, When I run it this way: @C_RunningBal = CASE WHEN j.description = 'Bad Check Fee' THEN -j.amount + @C_RunningBal WHEN j.Description = 'NSF (Bad Check)' THEN -j.amount + @C_RunningBal WHEN j.Description = 'NSF Check' THEN -j.amount + @C_RunningBal ELSE...
  6. Ty1

    CASE statement to increment trhough record and add to balance

    I have tried three ways: @C_RunningBal = CASE WHEN (select j.description from journal WHERE j.description = 'Bad Check Fee' THEN select sum(-j.amount) + @C_RunningBal AS "Running Balance" WHERE j.Description = 'NSF (Bad Check)' THEN (sum(-j.amount) + @C_RunningBal) AS...
  7. Ty1

    CASE statement to increment trhough record and add to balance

    Yes, I would like to have running sum to be calculated by all records in the table.
  8. Ty1

    CASE statement to increment trhough record and add to balance

    Thanks AlexCuse, I am having a problem with calculation of the running balance in that it doesn't change with each record it just total's all records and gives the result at the end of each row. Also, I am placing it in a Temp table. How can I implement the while loop? Also, I'm not ordering it...
  9. Ty1

    CASE statement to increment trhough record and add to balance

    I am new to SQL Server. I am trying to increment through my journal records and keep a 'Running Balance' while incrementing through each record. I also need a CASE statement to re-add a transaction if it had a 'NSF' fee. My code is below. So far I have attempted the CASE statement, but it isn't...

Part and Inventory Search

Back
Top