USE [Hyper Historian]
GO
/****** Object:  StoredProcedure [dbo].[insert_records_into_HH]    Script Date: 22.05.2019 09:51:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[insert_records_into_HH]
	@Time varchar(50),
	@FolderName varchar(100),
	@TagName varchar(1000),
	@Quality varchar(1000),
	@Value varchar(1000)
AS
SET NOCOUNT ON;
DECLARE @OpnQ varchar (1000)
DECLARE @SQL nvarchar(3000)

SET @OpnQ = ' INSERT INTO '+@FolderName+'.[RAWDATA](TAGNAME, TIMESTAMP, QUALITY, VALUE) VALUES ('''''+@TagName+''''', '''''+@Time+''''', '''''+@Quality+''''', '''''+@Value+''''') '
	

SET @SQL = 'SELECT * FROM OPENQUERY (HH2,''' + @OpnQ+''')'
EXEC sp_executesql @SQL