<div>
Try this. &nbsp;You have to use dynamic SQL to do that.<br />
<br />
Greg<br />
<br />
<br />

<pre><code id="code-8228267">DECLARE @MaxDate_cdr DateTime, @SQL NVARCHAR(MAX)

SET @MaxDate_cdr = (select MAX(CreatedDate) from Month10.dbo.cdr(nolock))

SET @SQL = 
'INSERT INTO OPENROWSET(''SQLNCLI'',''Server=192.168.150.147;Trusted_Connection=True;'',
 ''master.dbo.configtable(Country,Type,LastUpdateTime)Values(''India'',''cdr'',''' + @MaxDate_cdr + ''')'')'

EXECUTE sp_executesql @SQL</code></pre>
</div>


Try this.  You have to use dynamic SQL to do that.

Greg




DECLARE @MaxDate_cdr DateTime, @SQL NVARCHAR(MAX)

SET @MaxDate_cdr = (select MAX(CreatedDate) from Month10.dbo.cdr(nolock))

SET @SQL = 
'INSERT INTO OPENROWSET(''SQLNCLI'',''Server=192.168.150.147;Trusted_Connection=True;'',
 ''master.dbo.configtable(Country,Type,LastUpdateTime)Values(''India'',''cdr'',''' + @MaxDate_cdr + ''')'')'

EXECUTE sp_executesql @SQL

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am trying to insert a row into a table &nbsp;through openrowset. I get syntax &nbsp;Line 5: Incorrect syntax near '+'.<br />
<br />
<br />

<pre><code id="code-10-27406897-1">DECLARE @MaxDate_cdr DateTime
SET @MaxDate_cdr = (select MAX(CreatedDate) from Month10.dbo.cdr(nolock))
INSERT INTO OPENROWSET('SQLNCLI','Server=192.168.150.147;Trusted_Connection=True;',
     'master.dbo.configtable(Country,Type,LastUpdateTime)Values(''India'',''cdr'','+@MaxDate_cdr+')')</code></pre>
</div>
</div>


Hi,

I am trying to insert a row into a table  through openrowset. I get syntax  Line 5: Incorrect syntax near '+'.


(CODE)

Insert Into OpenRowSet Syntax

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.