Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Multiple aggregates using PIVOT

    It works somehow.

  • RE: Multiple aggregates using PIVOT

    SwePeso (8/28/2007)


    <FONT color=#0000ff size=2>

    SELECT</FONT><FONT size=2> [Part Number]</FONT><FONT color=#808080 size=2>,

    </FONT><FONT color=#ff00ff size=2>SUM</FONT><FONT color=#808080 size=2>(</FONT><FONT color=#0000ff size=2>CASE</FONT><FONT size=2> </FONT><FONT color=#0000ff size=2>WHEN</FONT><FONT size=2> Product </FONT><FONT color=#808080 size=2>=</FONT><FONT size=2> </FONT><FONT color=#ff0000 size=2>'BOM1'</FONT><FONT size=2> </FONT><FONT...

  • RE: Union query to temp table

    ya... Good Answer... Lowell

Viewing 3 posts - 1 through 3 (of 3 total)