DEV_kpi_Scripts_SQLQuery_2014-07-11.sql

USE [kpi_forms_db]
GO

SELECT *
  FROM [dbo].[u_kpi_table]
  WHERE UserName = 'Îâºê'
GO

--DELETE FROM [dbo].[u_kpi_table] WHERE UserName <> 'Ðì½òìÏ'

UPDATE [dbo].[u_kpi_table] SET u_kpi_conf = '0', u_kpi_doneconf = '0' WHERE UserName = 'Îâºì'
UPDATE [dbo].[u_kpi_table] SET UserName='ÈÙÁ¢¾ý' WHERE UserName = 'ÈÙÀö¾ý'

SELECT SUM(u_kpi_rat) AS SumKpiRat FROM [dbo].[u_kpi_table] WHERE UserName = 'Ðì½òìÏ' AND u_kpi_conf = '1' AND u_kpi_ins_datetime >= (SELECT DATEADD(MONTH, DATEDIFF(MONTH,0,getdate()), 0))

SELECT * FROM [kpi_forms_db].[dbo].[u_kpi_table] WHERE [Username]='Ðì½òìÏ' AND u_kpi_ins_datetime >= (SELECT DATEADD(MONTH, DATEDIFF(MONTH,0,getdate()), 0)) AND [u_kpi_conf] = 1

SELECT * FROM [kpi_forms_db].[dbo].[u_kpi_table] WHERE [Username]='Ðì½òìÏ' AND [u_kpi_conf] = 1 AND u_kpi_conf_datetime IS NOT NULL

SELECT SUM(u_kpi_rat) AS SumKpiRat FROM [dbo].[u_kpi_table] WHERE UserName = '²âÊÔ1' AND u_kpi_conf = '1' AND u_kpi_ins_datetime >= (SELECT DATEADD(MONTH, DATEDIFF(MONTH,0,getdate()), 0))