Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

'Q'+substring(datename(m,Dateadd(ms,-3,Dateadd(qq, Datediff(qq,0,GetDate()), 0))),1,3) +''''+ substring(cast(datepart(yyyy,Dateadd(ms,-3,Dateadd(qq, Datediff(qq,0,GetDate()), 0))) as varchar),3,2)

Hi All

While am trying to run the above SQL in BODS Scirpt am finding a Syntax Error.

Can any help.

ODBC data source(DDTCSQL31.fremont.lamrc.net) error message for operation(SQLExecute): ([Microsoft][SQL Server Native Client 11.0 [SQL Sserver] Incorrect syntax near','.

regards

Karthik

Former Member
Not what you were looking for? View more on this topic or Ask a question