[UPHPU] OT: SQL question (MSSQL)

[J M]

Sorry, I was going to post it but thought you might know what I was talking
about conceptually...assuming I gave a decent explanation.

http://paste-bin.com/336

Note: When I uncomment the last 'group by' line it lists all charge codes on
multiple lines.


On 9/6/06, Tyler Gee <geekout at gmail.com> wrote:
>
> Post your SQL statement.
>
> On 9/6/06, J M <jmul.php at gmail.com> wrote:
> > I have a SQL question.  Please let me know if it is too far off topic
> and
> > I'll take this question elsewhere.  I have to work with MSSQL but I
> think I
> > might be able to translate, if I have to, your suggestions based on your
> > knowledge of other rdbms's to make it work with MSSQL.  I'm looking
> around
> > for an MSSQL mailing group to join that doesn't dive too far into .Net
> > stuff.
> >
> > I asked this question on the IRC channel but I'm still having a
> problem.  I'm
> > trying to run a query that will return a charge_code and a count of how
> many
> > times this charge code was used.  I'm also getting other data back but
> my
> > question has to do with the charge code and the count.
> >
> > I've rearranged the code and tried all the ideas I could think of and
> I'm
> > still not getting the desired result.  I want all 6300+ charge codes
> listed
> > in my result whether or not they were used.  If they weren't used I want
> a
> > zero in the count column.  What is happening is every single record
> contains
> > the total number of all the charge codes used in the time frame
> specified.
> >
> > Example of what I'm getting…
> >
> > chg_code         count
> >
> > 0060N             24052
> >
> > 0061N             24052
> >
> > 00961              24052
> >
> > 0552N             24052
> >
> > …
> >
> > Example of what I'd like to get…
> >
> > chg_code         count
> >
> > 0060N             15
> >
> > 0061N             259
> >
> > 00961              0
> >
> > 0052N             72
> >
> > …
> >
> > Would I need a subquery with some sort of loop that adds up the
> count?  If
> > so, I've never done loops in SQL.  Are there any good web
> references?  (Books
> > Online isn't helping me any)  If using a loop is too complicated for
> this
> > problem, is there another (better) way to approach this?
> > TIA,
> >
> > John
> >
> > _______________________________________________
> >
> > UPHPU mailing list
> > UPHPU at uphpu.org
> > http://uphpu.org/mailman/listinfo/uphpu
> > IRC: #uphpu on irc.freenode.net
> >
>
>
> --
> ~Tyler
>