如何从数据库中获取多个值以给出多个值 [英] How to get multiple value from database to given more than one

问题描述

Sql Server查询.................

Sql Server Query.................

Create proc [dbo].[Get_Headwise_STax]
(
@ProjectId int

)
as
SELECT     Tax_Code.TaxCode_Id, Tax_Code.TaxCode, Tax_Code.serviceTax, Tax_Head.TaxH_Id, Tax_Head.Type, Tax_Head.Project_Id
FROM         Tax_Head INNER JOIN
                      Tax_Code ON Tax_Head.TaxCode_Id = Tax_Code.TaxCode_Id INNER JOIN
                      TaxMst ON Tax_Head.Project_Id = TaxMst.Project_Id
WHERE     (Tax_Head.Project_Id = @ProjectId)

TaxCode_Id TaxCode serviceTax TaxH_Id Type Project_Id



11 002 4 10 U 44

10 001 3.75 11 P 44

10 001 3.75 12 O 44

10 001 3.75 13我44







想要输出...... ..



根据TaxH_Id（UPOI）

我们想要标签价值，





4至label1

3.75至label2

3.75至label3

3.75至label4

TaxCode_Id TaxCode serviceTax TaxH_Id Type Project_Id

11 002 4 10 U 44
10 001 3.75 11 P 44
10 001 3.75 12 O 44
10 001 3.75 13 I 44



And Want the output........

according to TaxH_Id(U P O I)
we want the label value,


4 to label1
3.75 to label2
3.75 to label3
3.75 to label4

推荐答案

您可以通过使用CASE来实现此目的。

You can achieve this by using CASE as showing below.

SELECT     Tax_Code.TaxCode_Id, Tax_Code.TaxCode, Tax_Code.serviceTax, Tax_Head.TaxH_Id, case Tax_Head.Type when Tax_Head.Type='U' then 'label1' when Tax_Head.Type='P' then 'label2' when Tax_Head.Type='O' then 'label3' when Tax_Head.Type='I' then 'label4' else '' end, Tax_Head.Project_Id
FROM         Tax_Head INNER JOIN
                      Tax_Code ON Tax_Head.TaxCode_Id = Tax_Code.TaxCode_Id INNER JOIN
                      TaxMst ON Tax_Head.Project_Id = TaxMst.Project_Id
WHERE     (Tax_Head.Project_Id = @ProjectId)

SELECT     Tax_Code.TaxCode_Id, Tax_Code.TaxCode, Tax_Code.serviceTax, Tax_Head.TaxH_Id, 
case 
when Tax_Head.Type='U' then 'label1' 
when Tax_Head.Type='P' then 'label2' 
when Tax_Head.Type='O' then 'label3' 
when Tax_Head.Type='I' then 'label4' 
else '' end as label, 
Tax_Head.Project_Id
FROM         Tax_Head INNER JOIN
                      Tax_Code ON Tax_Head.TaxCode_Id = Tax_Code.TaxCode_Id INNER JOIN
                      TaxMst ON Tax_Head.Project_Id = TaxMst.Project_Id
WHERE     (Tax_Head.Project_Id = @ProjectId)

这是一个固定版本

This is a fixed version

这篇关于如何从数据库中获取多个值以给出多个值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！