Link a Query results with a Table

No.of Views	:	685
Bookmarked	:	0 times
Downloads	:
Votes	:	0

By youngmurukan On 15 Feb 2010 21:02:15

Tag : Sql Servers , T-SQL

Skill Level: Intermediate

Images in this article missing? We recently lost them in a site migration. We're working to restore these as you read this. Should you need an image in an emergency, please contact us at info@codegain.com

Hi folks,
This is very useful when we use query results with a table.
for example
here i have written query to get the sum of books from one table then i join that query resultset with another table in which i have sum up.

with chequedet(
BCode,NoofLeaves,TTLBooks)
as
(
select BCode,NoofLeaves,sum(NoofBooks) TTLBooks from ChequeDetails
where JobNo='xxxxxxx'
group by BCode,NoofLeaves
)
select a.bcode,b.NoofLeaves, b.TTLBooks,sum(a.noofbooks)
from ChequeDetails a ,chequedet b
where a.BCode=b.BCode and JobNo='xxxxxxx'
group by a.bcode,b.NoofLeaves,b.TTLBooks
order by a.bcode,b.NoofLeaves, b.TTLBooks

About Author

youngmurukan

Occupation	-	Not Provided
Company	-	Not Provided
Member Type	-	Senior
Location	-	Not Provided
Joined date	-	12 May 2009
Home Page	-	Not Provided
Blog Page	-	Not Provided


Other popularSectionarticles
Use of Rank() function in SQL Server Use of Rank() function in SQL Server Published Date : 15/Feb/2010 Use of Dense_Rank() function in SQL Server Use of Dense_Rank() function in SQL Server Published Date : 15/Feb/2010 How to Get First,Last and No of Days in Month Using T-Sql I have read few questions in forums, about how to select first, last date month and how many days in a month. In my project had used some query to perform these tasks. I will share those with article. Published Date : 17/Dec/2010 How to select random records in SQl Server How to select random records in SQl Server Published Date : 15/Feb/2010 how to get how many records entered in day by a user in sql server. how to get how many records entered in day by a user in sql server. Published Date : 15/Feb/2010

Comments

There is no comments for this articles.