table sub division on sql server 2000

Question

table sub division on sql server 2000

raghuldrag

Hall of Fame

Points: 3160
More actions
August 27, 2012 at 11:34 pm

#261174

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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

rhythmk SSCertifiable Points: 7271 More actions · Answer 1

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

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂

raghuldrag Hall of Fame Points: 3160 More actions · Answer 2

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

--------

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 3

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

laurie-789651 SSCertifiable Points: 7680 More actions · Answer 4

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!