<div>
Thanks for the grade. &nbsp;Good luck with your project. &nbsp;-Jim
</div>


Thanks for the grade.  Good luck with your project.  -Jim

<div>
I've seen 2 questions like this now...<br />
<br />
IIF translates to a &quot;case expression&quot;<br />
Nz translates to ISNULL() or COALESCE() (the later accepts more parameters than isnull )<br />
CCur translates to CAST() or CONVERT() using the 'money' as type<br />
<br />
<br />
<a href="http://technet.microsoft.com/en-us/library/ms181765(v=sql.105).aspx" rel="ugc">CASE (Transact-SQL)</a><br />
<a href="http://msdn.microsoft.com/en-us/library/ms187928(v=sql.105).aspx" rel="ugc">CAST and CONVERT (Transact-SQL)</a><br />
<a href="http://msdn.microsoft.com/en-us/library/ms190349(v=sql.105).aspx" rel="ugc">COALESCE (Transact-SQL)</a><br />
<br />
<br />
IIF ( boolean_expression, true_value, false_value )<br />
is available in SQL 2012<br />
see: <a href="http://technet.microsoft.com/en-us/library/hh213574.aspx" rel="ugc nofollow">http://technet.microsoft.com/en-us/library/hh213574.aspx</a>
</div>


I've seen 2 questions like this now...

IIF translates to a "case expression"
Nz translates to ISNULL() or COALESCE() (the later accepts more parameters than isnull )
CCur translates to CAST() or CONVERT() using the 'money' as type


CASE (Transact-SQL) [http://technet.microsoft.com/en-us/library/ms181765(v=sql.105).aspx]
CAST and CONVERT (Transact-SQL) [http://msdn.microsoft.com/en-us/library/ms187928(v=sql.105).aspx]
COALESCE (Transact-SQL) [http://msdn.microsoft.com/en-us/library/ms190349(v=sql.105).aspx]


IIF ( boolean_expression, true_value, false_value )
is available in SQL 2012
see: http://technet.microsoft.com/en-us/library/hh213574.aspx [http://technet.microsoft.com/en-us/library/hh213574.aspx]

<div>
<div class="content wysiwyg-content">
Sorry for the simple question, but i have a small query that is in access and I need to convert it so that it works in SQL server<br />
<br />
the code is<br />

<pre><code id="code-10-28261444-1">IIf(Nz([SumofAmount])+Nz([LegacyTotal])=0,Null,CCur(Nz([SumofAmount])+Nz([LegacyTotal]))) AS AllLegacyTotal</code></pre>
<br />
thanks in advance,<br />
Vinnie
</div>
</div>


Sorry for the simple question, but i have a small query that is in access and I need to convert it so that it works in SQL server

the code is
(CODE)

thanks in advance,
Vinnie

convert small query from access to SQL Server

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

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.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.