MS SQL Server MSEQ - Eliminating Duplicated

Author

Eliminating Duplicated

venkataramarao

2006-02-25, 9:46 am

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

David Portas

2006-02-25, 9:46 am

"venkataramarao" < venkataramarao@discu
ssions.microsoft.com> wrote in message
news:AC5F930E-5EE5-41B2-AB7B- C809082EF5C7@microso
ft.com...
>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
--

Sponsored Links