Search results for query: *

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

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.

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

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

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

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