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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by HarryCohen

  1. HarryCohen

    new to flash

    Hi, I've never used Flash and now one of my clients want me to do some (i hope) fairly simple animations to make their website look snazzier. I was about to rush out and buy Flash MX 2004 but then took pause wondering if it might be better to use an older version for such a simple thing. I...
  2. HarryCohen

    Multiple table SQL problem

    Of course posting here was all I needed to work out the problem. I changed it from SUM(ISNULL(Payments.smnyValue,0)) to SUM(DISTINCT ISNULL(Payments.smnyValue,0)) and it does what it should.
  3. HarryCohen

    Multiple table SQL problem

    The following is part of a stored procedure that is meant to return outstanding money for a specific bank. Normally this works fine. However when there is a trade with multiple legs of which the intUnits value is identical then the SUM(ISNULL(Payments.smnyValue,0)) returns a value that is...
  4. HarryCohen

    days query

    Thanks jHall. You are using VBA to do that whereas I'm wanting pure SQL, but it was enough to point me in the right direction. SQL also has a datepart function which is mostly the same (doesn't allow to choose first day of week). I'm running my query through Visual Basic so I can easily format...
  5. HarryCohen

    days query

    Thanks, but no, that's not what I mean. I want to know how many records there are for Monday, how many for Tuesday, etc. For instance I am using this to return a count by hour (for every day). SELECT DatePart('h',mydatefield), COUNT(DatePart('h',mydatefield)) as CntHour FROM mytable GROUP BY...
  6. HarryCohen

    days query

    A field in my table holds date information. I want to create a query that returns the number of times each day has an entry. eg. Monday 20 Tuesday 15 Wednesday 10 Thursday 24 etc
See more

Part and Inventory Search

Back
Top