Re: Eliminating Duplicated
- From: "David Portas" <REMOVE_BEFORE_REPLYING_dportas@xxxxxxx>
- Date: Sat, 25 Feb 2006 10:29:58 -0000
"venkataramarao" <venkataramarao@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AC5F930E-5EE5-41B2-AB7B-C809082EF5C7@xxxxxxxxxxxxxxxx
I have 3 tables Employee (empno,name,city) , Emp-Pl (empno,noofleaves) ,
and
Emp-Cl (empno,noofleaves). Now i require the report in the following
format
Sample Data
employee
1 ravi kumar rajahmundry
2 ravindra kakinada
emp-pl emp-cl
empno noofleave empno noofleave
1 2 1 4
1 3 1 2
2 4 1 3
2 1 2 1
2 1
EMPNO NAME CL PL
1 ravikumar 4 2
2 3
3
2 ravindra 1 4
1
1
I don't understand your requirements. Why does data from the CL table appear
in both the CL and PL columns? What determines this output?
Please post DDL and post sample data as INSERT statements rather than
sketches of tables.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
.
- Prev by Date: Re: SELECT ~~ OVER(PARTITION BY ~~) in SQL Server 2005?
- Next by Date: Re: SELECT ~~ OVER(PARTITION BY ~~) in SQL Server 2005?
- Previous by thread: Re: SELECT ~~ OVER(PARTITION BY ~~) in SQL Server 2005?
- Next by thread: Re: Date Range
- Index(es):
Relevant Pages
|
|
