Article 3.6.1K : How to update SQL Data with given Time period for single meter ?
SELECT* FROM [Database_Name].[dbo].[Table_Name] WHERE Column_Name='XYZ' AND ScanTime BETWEEN '2016-11-01 00:00:01' AND '2016-11-30 23:59:59'
UPDATE[Database_Name].[dbo].[Table_Name] SET[Column_Name2]='2' Column_Name='XYZ' AND ScanTime BETWEEN '2016-11-01 00:00:01' AND '2016-11-10 23:59:59'
UPDATE[Database_Name].[dbo].[Table_Name] SET[Column_Name2]='20' Column_Name='XYZ' AND ScanTime BETWEEN '2016-11-11 00:00:01' AND '2016-11-20 23:59:59'
Note :
1. Coulmn_Name2 is a location where your data will be set/Update.
Related Articles
Article 3.6.1AE : How to check Live Data in a SQL?
First, open the SQL server management studio (SSMS) and log in with the user id and password. After that follow below hierarchy to get Online data from SQL. ElNetDB > dbo.LiveData > Edit Top 200 Rows. You will find the table of the list of the meter ...
Article 3.6.1T : How to copy SQL Data from one table to another table ?
1. SET NOCOUNT ON SET STATISTICS TIME ON INSERT INTO Table_name_one ( colm1, colm2, colm3, colm4, colm5 ) SELECT colm1, colm2, colm3, colm4, colm5, FROM Table_name_two SET STATISTICS TIME OFF SET NOCOUNT OFF Note: Before ...
Article 3.6 SQL 2019 Installation Guide
Please find the attachment
Article 3.1.1R : Is it possible to sync time from PC to meter (RTC) via Elnet software?
Yes. It is possible. It's not available by default but we can customize the software to sync time (RTC). RTC - "Real Time Clock" *** End of article ***
Article 3.6.2S : SQL Configuration manager already installed in PC for new ElNet installation.
As mention in the subject SQL server configuration manager is already installed in a PC of new ElNet software installation. But as I have checked on PC there is not an installed SQL server management studio (SSMS). customer is using SQL for account ...