Playing w/queries

Hi,

Have a complex (for me) query which combines several subqueries and tables
to get the following information:

Agent_ID, Agent_Name, (and their expenses) Transportation, Salary, Meals..
(and their incomes) Commissions, bonus,..and dates.

I'd like to create an output where vertically will list the agents' names
and horizontally their expenses and incomes ordered by month.

Something like:



January February

Transportation, Salary. Transportation, Salary.

Agente_Name: 120 1200 100
1200



Not sure if it's possible but I thought to ask.

TIA

Ron

SQL2k



--------------------------------------------------------------------------------

Estoy utilizando la versión gratuita de SPAMfighter para usuarios privados.
Ha eliminado 1696 correos spam hasta la fecha.
Los abonados no tienen este mensaje en sus correos.
¡Pruebe SPAMfighter gratis ya!



.

Relevant Pages

  • Re: Playing w/queries
    ... You need pivot queries. ... Agent_ID, Agent_Name, (and their expenses) Transportation, Salary, Meals.. ... Estoy utilizando la versión gratuita de SPAMfighter para usuarios ... Ha eliminado 1696 correos spam hasta la fecha. ...
    (microsoft.public.sqlserver.datamining)
  • Tax confusion
    ... ChEngr.employed on ocean tugboats and large commercial fishing ... motels and meals and transportation to and from various specialists,x- ... unemployment fees.I was out of pocket for all expenses until I ... them.And since they pay a lot for insurance etc.etc.they did not cover ...
    (misc.taxes)
  • Re: Tax confusion
    ... motels and meals and transportation to and from various specialists,x- ... unemployment fees.I was out of pocket for all expenses until I ... them.And since they pay a lot for insurance etc.etc.they did not cover ... for your actual expense to compute what you may deduct, ...
    (misc.taxes)
  • Re: Travel Expenses
    ... >meals, computer, etc). ... > My question is can I deduct all my travel expenses to and from my home ... Initially it sounds like your primary work location is going to be in the ...
    (misc.taxes)
  • Re: Tax treatement of expense reimbursements for meals
    ... of my "travel" expenses are from within my tax home. ... whether the 50% rule applies to the meals for which I was reimbursed. ... You deduct the costs you actually paid for in 2007 on your 2007 sch C. ...
    (misc.taxes)