Search:

Type: Posts; User: szlamany

Page 1 of 13 1 2 3 4

Search: Search took 2.44 seconds.

  1. Thread: Post Race!

    by szlamany
    Replies
    65,067
    Views
    6,520,419

    Re: Post Race!

    Shaggy after an all night bender!
  2. Thread: Post Race!

    by szlamany
    Replies
    65,067
    Views
    6,520,419

    Re: Post Race!

    I'm starting to understand the phrase "back in the day" much better!
  3. Replies
    6
    Views
    165

    Re: jQuery .each() on a regular array

    Could you please move it? Thanks!
  4. Thread: Lupin ?

    by szlamany
    Replies
    14
    Views
    271

    Re: Lupin ?

    "We burn lupins, we even wear the bloody things!"

    https://getyarn.io/yarn-clip/059c29a9-452a-44cc-accc-0454314611a3
  5. Replies
    6
    Views
    165

    Re: jQuery .each() on a regular array

    Do we have a code bank for jQuery?
  6. Thread: Post Race!

    by szlamany
    Replies
    65,067
    Views
    6,520,419

    Re: Post Race!

    Yes - my back yard - thanks! About an hour out of NYC, if you can believe that! My father purchased this house 50 years ago, and I am keeping it in the family!

    About a mile upstream is a dam...
  7. Thread: Post Race!

    by szlamany
    Replies
    65,067
    Views
    6,520,419

    Re: Post Race!

    I've always wanted to put a Davinci bridge across this brook. Moved here from NYC in 72. Was a shock to say the least!
  8. Thread: Post Race!

    by szlamany
    Replies
    65,067
    Views
    6,520,419

    Re: Post Race!

    @funky lately I've found value in FB groups for things that interest me. I have a Camaro - so I'm in a Camaro group. We post pics of our cars, pick on Mustangs - really mature stuff!

    I live in...
  9. Replies
    6
    Views
    165

    Re: jQuery .each() on a regular array

    And here is what that "report writer syntax" produces for output, for those interested. Lots of text redacted...
  10. Replies
    6
    Views
    165

    Re: jQuery .each() on a regular array

    Here is the result string in that errorMessage() popup function.
  11. Replies
    6
    Views
    165

    [jQuery] .each() on a regular array

    jQuery is so powerful when you work the DOM - the methods available do so much, once you get fully versed in them.

    The .each() method is meant to work an array of "wrapped-elements" - DOM elements...
  12. Re: Need help with this complicated query

    I had that exact same post and then deleted it because it appears he wants to delete one at a time from the client (is that ADO?)
  13. Replies
    7
    Views
    209

    Re: Stored Procedure Stepping on Itself

    Create a log table in your DB and write to that with an IDENTITY value key and a GETDATE() transaction date. You can log several of these in one call of the SPROC - get a GUID at the top of the...
  14. Replies
    31
    Views
    750

    Re: Getting a new machine

    @jmc- I'm going to get one from a client for kind of work in trade.
  15. Replies
    31
    Views
    750

    Re: Getting a new machine

    Thanks for the link.

    The 7+ is a nice machine - I think this one has all that I need

    11th Gen Intel Core i7, 16 GB RAM, 256 GB, Platinum/Black

    I'm going to explore options for getting my...
  16. Replies
    31
    Views
    750

    Re: Getting a new machine

    @dil - yup, there is a 6 that the 7 did not rise much above. And as JMC mentioned there is a 7+.

    As far as 6, 7 and 7+, it's all about the chip. I might not care so much about that, it might...
  17. Thread: Post Race!

    by szlamany
    Replies
    65,067
    Views
    6,520,419

    Re: Post Race!

    The actual worse part is when I found out that the insurance carrier was able to negotiate it down to just $1 million. What is the real cost of care?
  18. Replies
    31
    Views
    750

    Re: Getting a new machine

    I had an actual server - that's been turned off for years.

    I had a desktop for doing video editing with specialized board and all. That machine died a slow death.

    I have a Windows 7 big old...
  19. Thread: Post Race!

    by szlamany
    Replies
    65,067
    Views
    6,520,419

    Re: Post Race!

    One of my clients is a health insurance provider. They recently got a $20 million dollar claim on a patient.
  20. Replies
    31
    Views
    750

    Re: Getting a new machine

    @dil - thanks for the counter points. Always makes it easier to plot a course when all options brought up. The MS SP series has nice docking stations to make lots of those issues go away. One of...
  21. Replies
    31
    Views
    750

    Re: Getting a new machine

    @lord orwell

    Not the Surface Pro X (which is ARM). Looking at a Surface Pro 7...
  22. Replies
    31
    Views
    750

    Getting a new machine

    I'm thinking of getting a new machine and was consider a MS Surface Pro.

    I have had a Surface Pro 2 for a long, long time - been a great machine.

    Am I nuts to consider this in today's hardware...
  23. Re: Getting the ball rolling. Which VB6 projects are you working on?

    @dragokas, I've asked everyone that same question so far. Taking an impartial poll.
  24. Re: Getting the ball rolling. Which VB6 projects are you working on?

    @dragokas - I see this is open source. Does you have commercial clients that pay a fee for use?
  25. Replies
    46
    Views
    997

    Re: join three tables to get Sum

    Pay attention to my queries more carefully. The UNION ALL query is simply putting your fields into different columns - NO SUM() in that part of the query.

    The SUM() happens in the SELECT from...
  26. Replies
    46
    Views
    997

    Re: join three tables to get Sum

    You must name the FIELDS in the FIRST select of a UNION ALL - sorry that I did not make that clear.

    You moved my name to the second select - that broke it. Plus I simply named it "Recette" - if...
  27. Replies
    46
    Views
    997

    Re: join three tables to get Sum

    Try this instead



    Select PersonID, Tarif, Cast(0 as money) "Recette", MyDate from MTbl
    Union All
    Select PersonID, Cast(0 as money), Recette, MyDate from Act_Tbl

    Which will allow you to do...
  28. Replies
    46
    Views
    997

    Re: join three tables to get Sum

    I believe what you are trying to tell me, is that, if there are two or more on the same DATE for a PersonID, you want the SUM that activity.

    Please confirm this.
  29. Replies
    46
    Views
    997

    Re: join three tables to get Sum

    Show me what you are trying to do with data
  30. Replies
    46
    Views
    997

    Re: join three tables to get Sum

    You are very welcome!
  31. Replies
    46
    Views
    997

    Re: join three tables to get Sum

    That is achieved with a different method.

    What you are showing me now is that MTbl and Act_tbl are treated the same. The Tarif value and Recette values are simply added up for a date.

    That is...
  32. Replies
    46
    Views
    997

    Re: join three tables to get Sum

    Does the date that you are selecting only exist one time in MTbl?

    If it does not exist, do you want to show that PersonID at all?
  33. Replies
    46
    Views
    997

    Re: join three tables to get Sum

    @optionbase1 - thanks for the warning. I'll spend a bit more time here to see if I can help.

    @mustaphi - this is exactly why a VIEW is a good idea on a child table. Look at this VIEW.


    ...
  34. Re: Getting the ball rolling. Which VB6 projects are you working on?

    @trick - is that a commercial application that you market?
  35. Replies
    46
    Views
    997

    Re: join three tables to get Sum

    This


    (Select MT.MyDate, Sum(MT.Tarif) From MTbl MT Where MT.PersonID = PT.PersonID) as TarifTotal" &

    Can only return one field

    MT.MyDate is not allowed in that sub-query.

    For two...
  36. Replies
    46
    Views
    997

    Re: join three tables to get Sum

    Sub-queries like the one I showed you - those that are inline in place of where you would put a single field in a statement - they can only return a single field themselves. And of course a single...
  37. Replies
    46
    Views
    997

    Re: join three tables to get Sum

    There is not a single MyDate for an ID so which would you want?
  38. Replies
    46
    Views
    997

    Re: join three tables to get Sum

    Instead of having a comma in front of the second sub-query, make that a + sign, and you are adding them together. Make it a minus sign and you are substracting.

    I showed you how to get a subquery...
  39. Replies
    46
    Views
    997

    Re: join three tables to get Sum

    Missing commas in front of each sub-query.


    StrSql = "Select PT.PersonID " & _
    ",(Select Sum(MT.Tarif) From MTbl MT Where MT.PersonID = PT.PersonID) as TarifTotal" & _
    ",(Select...
  40. Replies
    46
    Views
    997

    Re: join three tables to get Sum

    Change it to as TarifTotal and as RecetteTotal

    I'm just naming the columns - remove it all together.

    Are you MS-SQL?
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width