table sub division on sql server 2000

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » table sub division on sql server 2000

table sub division on sql server 2000

Rate Topic

Display Mode

Topic Options

Author

Message

raghuldrag

Posted Monday, August 27, 2012 11:34 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 2:36 AM
Points: 105, Visits: 259

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

rhythmk

Posted Tuesday, August 28, 2012 12:05 AM

Old Hand

Group: General Forum Members
Last Login: Saturday, November 10, 2012 9:30 AM
Points: 388, Visits: 603

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/
Smile

Post #1350699

raghuldrag

Posted Tuesday, August 28, 2012 1:00 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 2:36 AM
Points: 105, Visits: 259

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

ChrisM@Work

Posted Tuesday, August 28, 2012 4:05 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 9:11 AM
Points: 5,705, Visits: 11,132

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

laurie-789651

Posted Tuesday, August 28, 2012 4:11 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, May 30, 2013 1:26 PM
Points: 278, Visits: 808

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 »

Permissions