Hello T-SQL people,
I need help on the above subject. I have two tables, the name of the first one is Productions with 3 fields namely: agentid,amountproduced,datesold then the second table name is budget with 3 fields namely: agentid, yearbudgetamount, budgetyear,
now what i want now is that i want to calculate the percentage of each agent on amountproduced as against the yearbudget, it must be within that budgetyear.
Please I need Idea.
Thanks in advance!
View Complete Post