DECLARE @Result TABLE
(
[ID] INT IDENTITY(1,1) PRIMARY KEY,
[UrlName] NVARCHAR(50),
[Numbers] INT
)
INSERT INTO @Result ([Numbers],[UrlName])
SELECT COUNT(*) AS [Numbers],'百度' AS [UrlName] FROM [Im_flowrate] WHERE [loginfrom] LIKE '%baidu.com%'
INSERT INTO @Result ([Numbers],[UrlName])
SELECT COUNT(*) AS [Numbers],'yahoo' AS [UrlName] FROM [Im_flowrate] WHERE [loginfrom] LIKE '%yahoo.com%'
INSERT INTO @Result ([Numbers],[UrlName])
SELECT COUNT(*) AS [Numbers],'google' AS [UrlName] FROM [Im_flowrate] WHERE [loginfrom] LIKE '%google.com%'
INSERT INTO @Result ([Numbers],[UrlName])
SELECT COUNT(*) AS [Numbers],'新浪' AS [UrlName] FROM [Im_flowrate] WHERE [loginfrom] LIKE '%sina.com%'
SELECT * FROM @Result
(
[ID] INT IDENTITY(1,1) PRIMARY KEY,
[UrlName] NVARCHAR(50),
[Numbers] INT
)
INSERT INTO @Result ([Numbers],[UrlName])
SELECT COUNT(*) AS [Numbers],'百度' AS [UrlName] FROM [Im_flowrate] WHERE [loginfrom] LIKE '%baidu.com%'
INSERT INTO @Result ([Numbers],[UrlName])
SELECT COUNT(*) AS [Numbers],'yahoo' AS [UrlName] FROM [Im_flowrate] WHERE [loginfrom] LIKE '%yahoo.com%'
INSERT INTO @Result ([Numbers],[UrlName])
SELECT COUNT(*) AS [Numbers],'google' AS [UrlName] FROM [Im_flowrate] WHERE [loginfrom] LIKE '%google.com%'
INSERT INTO @Result ([Numbers],[UrlName])
SELECT COUNT(*) AS [Numbers],'新浪' AS [UrlName] FROM [Im_flowrate] WHERE [loginfrom] LIKE '%sina.com%'
SELECT * FROM @Result