<div>
Thanks lwadwell - it works fine. &nbsp;I can see I'm going to have lots of queries to recode!
</div>


Thanks lwadwell - it works fine.  I can see I'm going to have lots of queries to recode!

<div>
<div class="content wysiwyg-content">
We are (finally) upgrading from MSAccess to SQL Server 2008 R2. &nbsp;I am new to SQL Server. &nbsp;I have the following query<br />
<br />
&lt;CFSET WeekDate=MakeODBCDate(&quot;12/<wbr />08/2012&quot;)&gt;<wbr /><br />
<br />
&lt;CFQUERY NAME=&quot;MyQuery&quot; DATASOURCE=&quot;JobOrder#Sfx#&quot;<wbr />&gt;<br />
&nbsp; UPDATE Applic_Temp_Group.dbo.Temp<wbr />EmployeesF<wbr />ile <br />
&nbsp; INNER JOIN TsheetsThisWeek ON TempEmployeesFile.UniqueVa<wbr />l =TsheetsThisWeek.UniqueVal<wbr /><br />
&nbsp; SET TempEmployeesFile.Wkg ='Yes'<br />
&nbsp; WHERE TsheetsThisWeek.WEnded=&lt;CF<wbr />QUERYPARAM<wbr /> Value=&quot;#WeekDate#&quot; CFSQLTYPE=&quot;CF_SQL_DATE&quot;&gt;<br />
&lt;/CFQUERY&gt;<br />
<br />
It crashes and says &quot;Incorrect syntax near the keyword INNER&quot;. &nbsp;What is the correct syntax I need?
</div>
</div>


We are (finally) upgrading from MSAccess to SQL Server 2008 R2.  I am new to SQL Server.  I have the following query

<CFSET WeekDate=MakeODBCDate("12/08/2012")>

<CFQUERY NAME="MyQuery" DATASOURCE="JobOrder#Sfx#">
  UPDATE Applic_Temp_Group.dbo.TempEmployeesFile 
  INNER JOIN TsheetsThisWeek ON TempEmployeesFile.UniqueVal =TsheetsThisWeek.UniqueVal
  SET TempEmployeesFile.Wkg ='Yes'
  WHERE TsheetsThisWeek.WEnded=<CFQUERYPARAM Value="#WeekDate#" CFSQLTYPE="CF_SQL_DATE">
</CFQUERY>

It crashes and says "Incorrect syntax near the keyword INNER".  What is the correct syntax I need?

Help with SQL Server query syntax

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.

ColdFusion Language

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.