report using three tables in sql server 2008?

Question

0.00/5 (No votes)

See more:

SQL

create Table #table1(Name varchar(50),ChicksQuantity int,Chicksplaceddate datetime,Billablechicks int,freechicks int,Mortality int,Chickrate float,TotalAmount float,CashRecieved float)
insert into #table1

select A.agentname as Name ,A.Chicksqty as ChicksQuantity,A.Chicksplaceddate as Chicksplaceddate, A.billablechicks as Billablechicks,
 A.freechicks,A.mortality,A.Chickrate,A.Totalamount,A.Cashrec,
 F.farmername as Name,F.Chicksqty as Chicksquantity,F.chicksplaceddate,F.billablechicks,F.freechicks,
 F.mortality,F.Chickrate,F.Totalamount,F.Cashrec,I.farmername as Name,I.noofchicks as chicksquantity,I.mortality,I.Chicksplaceddate from  k_Master_Agentchicksales A
inner join k_Master_IntegrationChickSale I on A.hatchid=I.hatchid
inner join k_Master_Farmerchicksales F on F.hatchid=A.hatchid where A.updatedon between '2013-04-01 00:00:00.000' and '2014-03-31 00:00:00.000'


select * from #table1

i want only 9 columns report using three tables....
i know create table total columns and inserting columns must be same but how can i differentiate plz help me.....

Posted 2-Apr-14 1:13am

santhu888

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Er. Puneet Goel · Answer 1 · 2014-04-02T01:26:00

You ware using Three select statements under the single Insert Query which is not correct. For a single insert single select can act as input. So write three statements like this this single will do the work if you have multiple record.

SQL

INSERT INTO #table1 
SELECT A.agentname as Name, 
	A.Chicksqty as ChicksQuantity, 
	A.Chicksplaceddate as Chicksplaceddate, 
	A.billablechicks as Billablechicks,
	A.freechicks,
	A.mortality,
	A.Chickrate,
	A.Totalamount,
	A.Cashrec

FROM k_Master_Agentchicksales A
    INNER JOIN k_Master_IntegrationChickSale I on A.hatchid=I.hatchid
    INNER JOIN k_Master_Farmerchicksales F on F.hatchid=A.hatchid
WHERE A.updatedon between '2013-04-01 00:00:00.000' and '2014-03-31 00:00:00.000'