EXEC('Insert Into #CountTable
FROM OPENROWSET
(''SQLOLEDB'',''DRIVER={SQL Server};SERVER=xxx;UID=uid;PWD=pwd'',
''Select '''''+@DateOfExecution+''''' ActivityDate, '+@Datacenter+' Datacenter, '+@Farmid+' Farm,DatePart(hh,Requestreceivedtime) [Hour],
Count(*) TotalTrans From DB01.dbo.'+ @Tablename + ' With (Nolock)
Where Requestreceivedtime Between '''''+@StartDate+''''' And '''''+@EndDate+'''''
And Status=1 Group by DatePart(hh,Requestreceivedtime)')
Error Details:
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'FROM'.
Msg 105, Level 15, State 1, Line 4
Unclosed quotation mark after the character string 'Select 'Jun 4 2012 12:00AM' ActivityDate, 3 Datacenter, 14 Farm,DatePart(hh,Requestreceivedtime) [Hour],
Count(*) TotalTrans From DB01.dbo.RequestQueue1014_568 With (Nolock)
Where Requestreceivedtime Between 'Jun 4 2012 12:00AM' And 'Jun 4 2012 11:59PM'
And Status=1 Group by DatePart(hh,Requestreceivedtime)'.
Error using openrowset
Posted - 06/12/2012 : 03:29:45
