Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

table sub division on sql server 2000 Expand / Collapse
Author
Message
Posted Monday, August 27, 2012 11:34 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 3:57 AM
Points: 179, Visits: 448
table-1
employee details



table-2
salary details

table-3

incentive details



how to make three different tables has to show on single report one by one
Post #1350691
Posted Tuesday, August 28, 2012 12:05 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 3:28 AM
Points: 579, Visits: 914
raghuldrag (8/27/2012)
table-1
employee details



table-2
salary details

table-3

incentive details



how to make three different tables has to show on single report one by one


Can you please elaborate your requirement with the help of an example.


--rhythmk
------------------------------------------------------------------
To post your question use below link

http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1350699
Posted Tuesday, August 28, 2012 1:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 3:57 AM
Points: 179, Visits: 448

table 1

empcode:002244
name:ravi
designation:Programmer
accountno:acc2423


table 2

basic sal 6000
otherallowance 1500

table3
deduction
canteen 500
empf 500
----------

total 10000
--------
Post #1350708
Posted Tuesday, August 28, 2012 4:05 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 1:43 AM
Points: 6,890, Visits: 14,254
raghuldrag (8/27/2012)
table-1
employee details



table-2
salary details

table-3

incentive details



how to make three different tables has to show on single report one by one


This is the SQL Server 2008 forum section. You're using SQL Server 2000. Please repost in the appropriate section.


“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #1350780
Posted Tuesday, August 28, 2012 4:11 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 8:05 AM
Points: 320, Visits: 1,095
raghuldrag (8/28/2012)

table 1

empcode:002244
name:ravi
designation:Programmer
accountno:acc2423


table 2

basic sal 6000
otherallowance 1500

table3
deduction
canteen 500
empf 500
----------

total 10000
--------


You need to specify the joining column too!
Post #1350782
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse