DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 8 of 8

Thread: Multiple Query Problem

  1. #1
    Scott Guest

    Multiple Query Problem


    I have a db that stores transaction records with a separate db that has the
    accounting code for that transaction. I need to add up charges and payments
    then output the outstanding accounts.
    I would like to does this in one query but my limited knowledge prevents
    me from figuring this out. If any has any pointers or sample code that would
    help me, I would appreciate it.

    Charges Query:
    SELECT TS.Custid, Sum(TS.AMT_1) AS charges FROM TS
    INNER JOIN TC ON TS.TCODE = TC.TCODE
    WHERE TC.ACODE='+' and TS.accept <> 'v'
    group by TS.custid

    Payments Query:
    SELECT TS.Custid, Sum(TS.AMT_1) AS charges FROM TS
    INNER JOIN TC ON TS.TCODE = TC.TCODE
    WHERE TC.ACODE='-' and TS.accept <> 'v'
    group by TS.custid

    Thanks,
    Scott



  2. #2
    Daniel Reber Guest

    Re: Multiple Query Problem

    Try this:

    select
    ts.custid,
    chg.charges,
    pay.payments

    from ts
    join (select tcode, sum(amt_1) charges from dbname.dbo.tc
    where acode = '+' and accept <> 'v'
    group by tcode) chg on chg.tcode = ts.tcode
    join (select tcode, sum(amt_1) payments from dbname.dbo.tc
    where acode = '-' and accept <> 'v'
    group by tcode) pay on chg.tcode = ts.tcode


    that should work. The only thing you will need to change is which table is
    fully qualified. If you are running it from the database TS is in, then you
    are fine. But if you are running it in the database that TC is in, then TS
    will need to be fully qualified. You may also need to add left joins
    depending on what you want. Why do you have the transactions in a separate
    database?

    hope this helps

    Daniel Reber, MCP



    Scott <cs@ozarka.edu> wrote in message news:3a555714@news.devx.com...

    I have a db that stores transaction records with a separate db that has the
    accounting code for that transaction. I need to add up charges and payments
    then output the outstanding accounts.
    I would like to does this in one query but my limited knowledge prevents
    me from figuring this out. If any has any pointers or sample code that
    would
    help me, I would appreciate it.

    Charges Query:
    SELECT TS.Custid, Sum(TS.AMT_1) AS charges FROM TS
    INNER JOIN TC ON TS.TCODE = TC.TCODE
    WHERE TC.ACODE='+' and TS.accept <> 'v'
    group by TS.custid

    Payments Query:
    SELECT TS.Custid, Sum(TS.AMT_1) AS charges FROM TS
    INNER JOIN TC ON TS.TCODE = TC.TCODE
    WHERE TC.ACODE='-' and TS.accept <> 'v'
    group by TS.custid

    Thanks,
    Scott





  3. #3
    Scott Pinkston Guest

    Re: Multiple Query Problem


    Daniel,
    I didn't make myself very clear. It is two databases. One called TS that
    has all of the customer information including the payments and charges and
    the tcode in it and the other is TC that has tcode and acode which is -,
    +, or =.
    The link is on ts.acode to tc.tcode.
    Sample data:
    TS
    CustID AMT_1 TCODE ACCEPT
    333 22.00 CR
    333 12.00 CP

    TC
    TCODE ACODE
    CR +
    CP -

    The end result is that custID 333 charged 22.00 and paid us 12.00 so his
    balance is 10.

    It's not our design on the database, we are just trying to develop a web
    interface on the accounting side of it.

    Thanks for looking at it,
    Scott


    "Daniel Reber" <danielreber@earthlink.net> wrote:
    >Try this:
    >
    >select
    >ts.custid,
    >chg.charges,
    >pay.payments
    >
    >from ts
    >join (select tcode, sum(amt_1) charges from dbname.dbo.tc
    > where acode = '+' and accept <> 'v'
    > group by tcode) chg on chg.tcode = ts.tcode
    >join (select tcode, sum(amt_1) payments from dbname.dbo.tc
    > where acode = '-' and accept <> 'v'
    > group by tcode) pay on chg.tcode = ts.tcode
    >
    >
    >that should work. The only thing you will need to change is which table

    is
    >fully qualified. If you are running it from the database TS is in, then

    you
    >are fine. But if you are running it in the database that TC is in, then

    TS
    >will need to be fully qualified. You may also need to add left joins
    >depending on what you want. Why do you have the transactions in a separate
    >database?
    >
    >hope this helps
    >
    >Daniel Reber, MCP
    >
    >
    >
    >Scott <cs@ozarka.edu> wrote in message news:3a555714@news.devx.com...
    >
    >I have a db that stores transaction records with a separate db that has

    the
    >accounting code for that transaction. I need to add up charges and payments
    >then output the outstanding accounts.
    >I would like to does this in one query but my limited knowledge prevents
    >me from figuring this out. If any has any pointers or sample code that
    >would
    >help me, I would appreciate it.
    >
    >Charges Query:
    >SELECT TS.Custid, Sum(TS.AMT_1) AS charges FROM TS
    >INNER JOIN TC ON TS.TCODE = TC.TCODE
    >WHERE TC.ACODE='+' and TS.accept <> 'v'
    >group by TS.custid
    >
    >Payments Query:
    >SELECT TS.Custid, Sum(TS.AMT_1) AS charges FROM TS
    >INNER JOIN TC ON TS.TCODE = TC.TCODE
    >WHERE TC.ACODE='-' and TS.accept <> 'v'
    >group by TS.custid
    >
    >Thanks,
    >Scott
    >
    >
    >
    >



  4. #4
    Daniel Reber Guest

    Re: Multiple Query Problem

    That's fine if it is 2 databases, my example will still work. That is why I
    used the fully qualified name for TC

    Scott Pinkston <cs@ozarka.edu> wrote in message
    news:3a5a869b$1@news.devx.com...

    Daniel,
    I didn't make myself very clear. It is two databases. One called TS that
    has all of the customer information including the payments and charges and
    the tcode in it and the other is TC that has tcode and acode which is -,
    +, or =.
    The link is on ts.acode to tc.tcode.
    Sample data:
    TS
    CustID AMT_1 TCODE ACCEPT
    333 22.00 CR
    333 12.00 CP

    TC
    TCODE ACODE
    CR +
    CP -

    The end result is that custID 333 charged 22.00 and paid us 12.00 so his
    balance is 10.

    It's not our design on the database, we are just trying to develop a web
    interface on the accounting side of it.

    Thanks for looking at it,
    Scott


    "Daniel Reber" <danielreber@earthlink.net> wrote:
    >Try this:
    >
    >select
    >ts.custid,
    >chg.charges,
    >pay.payments
    >
    >from ts
    >join (select tcode, sum(amt_1) charges from dbname.dbo.tc
    > where acode = '+' and accept <> 'v'
    > group by tcode) chg on chg.tcode = ts.tcode
    >join (select tcode, sum(amt_1) payments from dbname.dbo.tc
    > where acode = '-' and accept <> 'v'
    > group by tcode) pay on chg.tcode = ts.tcode
    >
    >
    >that should work. The only thing you will need to change is which table

    is
    >fully qualified. If you are running it from the database TS is in, then

    you
    >are fine. But if you are running it in the database that TC is in, then

    TS
    >will need to be fully qualified. You may also need to add left joins
    >depending on what you want. Why do you have the transactions in a separate
    >database?
    >
    >hope this helps
    >
    >Daniel Reber, MCP
    >
    >
    >
    >Scott <cs@ozarka.edu> wrote in message news:3a555714@news.devx.com...
    >
    >I have a db that stores transaction records with a separate db that has

    the
    >accounting code for that transaction. I need to add up charges and

    payments
    >then output the outstanding accounts.
    >I would like to does this in one query but my limited knowledge prevents
    >me from figuring this out. If any has any pointers or sample code that
    >would
    >help me, I would appreciate it.
    >
    >Charges Query:
    >SELECT TS.Custid, Sum(TS.AMT_1) AS charges FROM TS
    >INNER JOIN TC ON TS.TCODE = TC.TCODE
    >WHERE TC.ACODE='+' and TS.accept <> 'v'
    >group by TS.custid
    >
    >Payments Query:
    >SELECT TS.Custid, Sum(TS.AMT_1) AS charges FROM TS
    >INNER JOIN TC ON TS.TCODE = TC.TCODE
    >WHERE TC.ACODE='-' and TS.accept <> 'v'
    >group by TS.custid
    >
    >Thanks,
    >Scott
    >
    >
    >
    >





  5. #5
    Daniel Reber Guest

    Re: Multiple Query Problem

    I just noticed your initial post. your select statement was:

    SELECT TS.Custid, Sum(TS.AMT_1) AS charges FROM TS
    INNER JOIN TC ON TS.TCODE = TC.TCODE
    WHERE TC.ACODE='+' and TS.accept <> 'v'

    is TS & TC databases or tables? If they are databases. what are the table
    names? Your from clause needs table names.

    Scott Pinkston <cs@ozarka.edu> wrote in message
    news:3a5a869b$1@news.devx.com...

    Daniel,
    I didn't make myself very clear. It is two databases. One called TS that
    has all of the customer information including the payments and charges and
    the tcode in it and the other is TC that has tcode and acode which is -,
    +, or =.
    The link is on ts.acode to tc.tcode.
    Sample data:
    TS
    CustID AMT_1 TCODE ACCEPT
    333 22.00 CR
    333 12.00 CP

    TC
    TCODE ACODE
    CR +
    CP -

    The end result is that custID 333 charged 22.00 and paid us 12.00 so his
    balance is 10.

    It's not our design on the database, we are just trying to develop a web
    interface on the accounting side of it.

    Thanks for looking at it,
    Scott


    "Daniel Reber" <danielreber@earthlink.net> wrote:
    >Try this:
    >
    >select
    >ts.custid,
    >chg.charges,
    >pay.payments
    >
    >from ts
    >join (select tcode, sum(amt_1) charges from dbname.dbo.tc
    > where acode = '+' and accept <> 'v'
    > group by tcode) chg on chg.tcode = ts.tcode
    >join (select tcode, sum(amt_1) payments from dbname.dbo.tc
    > where acode = '-' and accept <> 'v'
    > group by tcode) pay on chg.tcode = ts.tcode
    >
    >
    >that should work. The only thing you will need to change is which table

    is
    >fully qualified. If you are running it from the database TS is in, then

    you
    >are fine. But if you are running it in the database that TC is in, then

    TS
    >will need to be fully qualified. You may also need to add left joins
    >depending on what you want. Why do you have the transactions in a separate
    >database?
    >
    >hope this helps
    >
    >Daniel Reber, MCP
    >
    >
    >
    >Scott <cs@ozarka.edu> wrote in message news:3a555714@news.devx.com...
    >
    >I have a db that stores transaction records with a separate db that has

    the
    >accounting code for that transaction. I need to add up charges and

    payments
    >then output the outstanding accounts.
    >I would like to does this in one query but my limited knowledge prevents
    >me from figuring this out. If any has any pointers or sample code that
    >would
    >help me, I would appreciate it.
    >
    >Charges Query:
    >SELECT TS.Custid, Sum(TS.AMT_1) AS charges FROM TS
    >INNER JOIN TC ON TS.TCODE = TC.TCODE
    >WHERE TC.ACODE='+' and TS.accept <> 'v'
    >group by TS.custid
    >
    >Payments Query:
    >SELECT TS.Custid, Sum(TS.AMT_1) AS charges FROM TS
    >INNER JOIN TC ON TS.TCODE = TC.TCODE
    >WHERE TC.ACODE='-' and TS.accept <> 'v'
    >group by TS.custid
    >
    >Thanks,
    >Scott
    >
    >
    >
    >





  6. #6
    Scott Pinkston Guest

    Re: Multiple Query Problem


    Sorry, its two tables.

    "Daniel Reber" <danielreber@earthlink.net> wrote:
    >I just noticed your initial post. your select statement was:
    >
    >SELECT TS.Custid, Sum(TS.AMT_1) AS charges FROM TS
    >INNER JOIN TC ON TS.TCODE = TC.TCODE
    >WHERE TC.ACODE='+' and TS.accept <> 'v'
    >
    >is TS & TC databases or tables? If they are databases. what are the table
    >names? Your from clause needs table names.
    >
    >Scott Pinkston <cs@ozarka.edu> wrote in message
    >news:3a5a869b$1@news.devx.com...
    >
    >Daniel,
    >I didn't make myself very clear. It is two databases. One called TS that
    >has all of the customer information including the payments and charges and
    >the tcode in it and the other is TC that has tcode and acode which is -,
    >+, or =.
    >The link is on ts.acode to tc.tcode.
    >Sample data:
    >TS
    >CustID AMT_1 TCODE ACCEPT
    >333 22.00 CR
    >333 12.00 CP
    >
    >TC
    >TCODE ACODE
    >CR +
    >CP -
    >
    >The end result is that custID 333 charged 22.00 and paid us 12.00 so his
    >balance is 10.
    >
    >It's not our design on the database, we are just trying to develop a web
    >interface on the accounting side of it.
    >
    >Thanks for looking at it,
    >Scott
    >
    >
    >"Daniel Reber" <danielreber@earthlink.net> wrote:
    >>Try this:
    >>
    >>select
    >>ts.custid,
    >>chg.charges,
    >>pay.payments
    >>
    >>from ts
    >>join (select tcode, sum(amt_1) charges from dbname.dbo.tc
    >> where acode = '+' and accept <> 'v'
    >> group by tcode) chg on chg.tcode = ts.tcode
    >>join (select tcode, sum(amt_1) payments from dbname.dbo.tc
    >> where acode = '-' and accept <> 'v'
    >> group by tcode) pay on chg.tcode = ts.tcode
    >>
    >>
    >>that should work. The only thing you will need to change is which table

    >is
    >>fully qualified. If you are running it from the database TS is in, then

    >you
    >>are fine. But if you are running it in the database that TC is in, then

    >TS
    >>will need to be fully qualified. You may also need to add left joins
    >>depending on what you want. Why do you have the transactions in a separate
    >>database?
    >>
    >>hope this helps
    >>
    >>Daniel Reber, MCP
    >>
    >>
    >>
    >>Scott <cs@ozarka.edu> wrote in message news:3a555714@news.devx.com...
    >>
    >>I have a db that stores transaction records with a separate db that has

    >the
    >>accounting code for that transaction. I need to add up charges and

    >payments
    >>then output the outstanding accounts.
    >>I would like to does this in one query but my limited knowledge prevents
    >>me from figuring this out. If any has any pointers or sample code that
    >>would
    >>help me, I would appreciate it.
    >>
    >>Charges Query:
    >>SELECT TS.Custid, Sum(TS.AMT_1) AS charges FROM TS
    >>INNER JOIN TC ON TS.TCODE = TC.TCODE
    >>WHERE TC.ACODE='+' and TS.accept <> 'v'
    >>group by TS.custid
    >>
    >>Payments Query:
    >>SELECT TS.Custid, Sum(TS.AMT_1) AS charges FROM TS
    >>INNER JOIN TC ON TS.TCODE = TC.TCODE
    >>WHERE TC.ACODE='-' and TS.accept <> 'v'
    >>group by TS.custid
    >>
    >>Thanks,
    >>Scott
    >>
    >>
    >>
    >>

    >
    >
    >



  7. #7
    Daniel Reber Guest

    Re: Multiple Query Problem

    try this then:

    select
    ts.custid,
    chg.charges,
    pay.payments,
    isnull(chg.charges,0) - isnull(pay.payments,0) balance

    from ts
    left join (select tcode, sum(amt_1) charges from tc
    where acode = '+' and accept <> 'v'
    group by tcode) chg on chg.tcode = ts.tcode
    left join (select tcode, sum(amt_1) payments from tc
    where acode = '-' and accept <> 'v'
    group by tcode) pay on chg.tcode = ts.tcode

    I added left joins in case either table doesn't have matching rows.

    This should work now.

    Scott Pinkston <cs@ozarka.edu> wrote in message
    news:3a5b439a$1@news.devx.com...

    Sorry, its two tables.

    "Daniel Reber" <danielreber@earthlink.net> wrote:
    >I just noticed your initial post. your select statement was:
    >
    >SELECT TS.Custid, Sum(TS.AMT_1) AS charges FROM TS
    >INNER JOIN TC ON TS.TCODE = TC.TCODE
    >WHERE TC.ACODE='+' and TS.accept <> 'v'
    >
    >is TS & TC databases or tables? If they are databases. what are the table
    >names? Your from clause needs table names.
    >
    >Scott Pinkston <cs@ozarka.edu> wrote in message
    >news:3a5a869b$1@news.devx.com...
    >
    >Daniel,
    >I didn't make myself very clear. It is two databases. One called TS that
    >has all of the customer information including the payments and charges and
    >the tcode in it and the other is TC that has tcode and acode which is -,
    >+, or =.
    >The link is on ts.acode to tc.tcode.
    >Sample data:
    >TS
    >CustID AMT_1 TCODE ACCEPT
    >333 22.00 CR
    >333 12.00 CP
    >
    >TC
    >TCODE ACODE
    >CR +
    >CP -
    >
    >The end result is that custID 333 charged 22.00 and paid us 12.00 so his
    >balance is 10.
    >
    >It's not our design on the database, we are just trying to develop a web
    >interface on the accounting side of it.
    >
    >Thanks for looking at it,
    >Scott
    >
    >
    >"Daniel Reber" <danielreber@earthlink.net> wrote:
    >>Try this:
    >>
    >>select
    >>ts.custid,
    >>chg.charges,
    >>pay.payments
    >>
    >>from ts
    >>join (select tcode, sum(amt_1) charges from dbname.dbo.tc
    >> where acode = '+' and accept <> 'v'
    >> group by tcode) chg on chg.tcode = ts.tcode
    >>join (select tcode, sum(amt_1) payments from dbname.dbo.tc
    >> where acode = '-' and accept <> 'v'
    >> group by tcode) pay on chg.tcode = ts.tcode
    >>
    >>
    >>that should work. The only thing you will need to change is which table

    >is
    >>fully qualified. If you are running it from the database TS is in, then

    >you
    >>are fine. But if you are running it in the database that TC is in, then

    >TS
    >>will need to be fully qualified. You may also need to add left joins
    >>depending on what you want. Why do you have the transactions in a separate
    >>database?
    >>
    >>hope this helps
    >>
    >>Daniel Reber, MCP
    >>
    >>
    >>
    >>Scott <cs@ozarka.edu> wrote in message news:3a555714@news.devx.com...
    >>
    >>I have a db that stores transaction records with a separate db that has

    >the
    >>accounting code for that transaction. I need to add up charges and

    >payments
    >>then output the outstanding accounts.
    >>I would like to does this in one query but my limited knowledge prevents
    >>me from figuring this out. If any has any pointers or sample code that
    >>would
    >>help me, I would appreciate it.
    >>
    >>Charges Query:
    >>SELECT TS.Custid, Sum(TS.AMT_1) AS charges FROM TS
    >>INNER JOIN TC ON TS.TCODE = TC.TCODE
    >>WHERE TC.ACODE='+' and TS.accept <> 'v'
    >>group by TS.custid
    >>
    >>Payments Query:
    >>SELECT TS.Custid, Sum(TS.AMT_1) AS charges FROM TS
    >>INNER JOIN TC ON TS.TCODE = TC.TCODE
    >>WHERE TC.ACODE='-' and TS.accept <> 'v'
    >>group by TS.custid
    >>
    >>Thanks,
    >>Scott
    >>
    >>
    >>
    >>

    >
    >
    >





  8. #8
    Daniel Reber Guest

    Re: Multiple Query Problem

    I made a mistake. The 2nd derived table join should be pay.tcode = ts.tcode,
    not chg.tcode = ts.tcode

    this one will work.


    select
    ts.custid,
    chg.charges,
    pay.payments,
    isnull(chg.charges,0) - isnull(pay.payments,0) balance

    from ts
    left join (select tcode, sum(amt_1) charges from tc
    where acode = '+' and accept <> 'v'
    group by tcode) chg on chg.tcode = ts.tcode
    left join (select tcode, sum(amt_1) payments from tc
    where acode = '-' and accept <> 'v'
    group by tcode) pay on pay.tcode = ts.tcode



    Daniel Reber <danielreber@earthlink.net> wrote in message
    news:3a5b4aa0$1@news.devx.com...
    try this then:

    select
    ts.custid,
    chg.charges,
    pay.payments,
    isnull(chg.charges,0) - isnull(pay.payments,0) balance

    from ts
    left join (select tcode, sum(amt_1) charges from tc
    where acode = '+' and accept <> 'v'
    group by tcode) chg on chg.tcode = ts.tcode
    left join (select tcode, sum(amt_1) payments from tc
    where acode = '-' and accept <> 'v'
    group by tcode) pay on chg.tcode = ts.tcode

    I added left joins in case either table doesn't have matching rows.

    This should work now.

    Scott Pinkston <cs@ozarka.edu> wrote in message
    news:3a5b439a$1@news.devx.com...

    Sorry, its two tables.

    "Daniel Reber" <danielreber@earthlink.net> wrote:
    >I just noticed your initial post. your select statement was:
    >
    >SELECT TS.Custid, Sum(TS.AMT_1) AS charges FROM TS
    >INNER JOIN TC ON TS.TCODE = TC.TCODE
    >WHERE TC.ACODE='+' and TS.accept <> 'v'
    >
    >is TS & TC databases or tables? If they are databases. what are the table
    >names? Your from clause needs table names.
    >
    >Scott Pinkston <cs@ozarka.edu> wrote in message
    >news:3a5a869b$1@news.devx.com...
    >
    >Daniel,
    >I didn't make myself very clear. It is two databases. One called TS that
    >has all of the customer information including the payments and charges and
    >the tcode in it and the other is TC that has tcode and acode which is -,
    >+, or =.
    >The link is on ts.acode to tc.tcode.
    >Sample data:
    >TS
    >CustID AMT_1 TCODE ACCEPT
    >333 22.00 CR
    >333 12.00 CP
    >
    >TC
    >TCODE ACODE
    >CR +
    >CP -
    >
    >The end result is that custID 333 charged 22.00 and paid us 12.00 so his
    >balance is 10.
    >
    >It's not our design on the database, we are just trying to develop a web
    >interface on the accounting side of it.
    >
    >Thanks for looking at it,
    >Scott
    >
    >
    >"Daniel Reber" <danielreber@earthlink.net> wrote:
    >>Try this:
    >>
    >>select
    >>ts.custid,
    >>chg.charges,
    >>pay.payments
    >>
    >>from ts
    >>join (select tcode, sum(amt_1) charges from dbname.dbo.tc
    >> where acode = '+' and accept <> 'v'
    >> group by tcode) chg on chg.tcode = ts.tcode
    >>join (select tcode, sum(amt_1) payments from dbname.dbo.tc
    >> where acode = '-' and accept <> 'v'
    >> group by tcode) pay on chg.tcode = ts.tcode
    >>
    >>
    >>that should work. The only thing you will need to change is which table

    >is
    >>fully qualified. If you are running it from the database TS is in, then

    >you
    >>are fine. But if you are running it in the database that TC is in, then

    >TS
    >>will need to be fully qualified. You may also need to add left joins
    >>depending on what you want. Why do you have the transactions in a separate
    >>database?
    >>
    >>hope this helps
    >>
    >>Daniel Reber, MCP
    >>
    >>
    >>
    >>Scott <cs@ozarka.edu> wrote in message news:3a555714@news.devx.com...
    >>
    >>I have a db that stores transaction records with a separate db that has

    >the
    >>accounting code for that transaction. I need to add up charges and

    >payments
    >>then output the outstanding accounts.
    >>I would like to does this in one query but my limited knowledge prevents
    >>me from figuring this out. If any has any pointers or sample code that
    >>would
    >>help me, I would appreciate it.
    >>
    >>Charges Query:
    >>SELECT TS.Custid, Sum(TS.AMT_1) AS charges FROM TS
    >>INNER JOIN TC ON TS.TCODE = TC.TCODE
    >>WHERE TC.ACODE='+' and TS.accept <> 'v'
    >>group by TS.custid
    >>
    >>Payments Query:
    >>SELECT TS.Custid, Sum(TS.AMT_1) AS charges FROM TS
    >>INNER JOIN TC ON TS.TCODE = TC.TCODE
    >>WHERE TC.ACODE='-' and TS.accept <> 'v'
    >>group by TS.custid
    >>
    >>Thanks,
    >>Scott
    >>
    >>
    >>
    >>

    >
    >
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center