如何在asp.net代码后面转换sql查询 [英] How to convert sql query in asp.net code behind

问题描述

如何在asp.net代码中编写此选择查询

How to write this select query in asp.net code behind

DECLARE @calls_table TABLE
    (
      ID INT ,
      Division CHAR(1) ,
      [STATUS] VARCHAR(50)
    )
INSERT  INTO @calls_table
        ( ID, Division, STATUS )
VALUES  ( 1001, 'A', 'Open' ),
        ( 1002, 'B', 'Closed' ),
        ( 1003, 'A', 'Closed' ),
        ( 1004, 'C', 'Open' ),
        ( 1005, 'C', 'Open' )

SQL查询：

SQL Query:

SELECT  Division ,
        SUM(CASE WHEN STATUS = 'Open' THEN 1
                 ELSE 0
            END) AS Open_Calls ,
        SUM(CASE WHEN STATUS = 'Closed' THEN 1
                 ELSE 0
            END) AS Closed_Calls ,
        COUNT(*) AS 'Total_Calls' ,
        CONVERT(DECIMAL(5, 2), SUM(CASE WHEN STATUS = 'Closed' THEN 1
                                        ELSE 0
                                   END)) / COUNT(*) AS Closed_Calls_Perc
FROM    @calls_table
GROUP BY Division

请尽快给我答案。



谢谢

Sathik

Please kindly give me the answer as soon as possible.

Thanks
Sathik

推荐答案

以字符串格式存储sql查询。然后使用该字符串并执行它

Store that sql query in string format. then use that string and execute it

这篇关于如何在asp.net代码后面转换sql查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！