<div>
Thanks angelIII thats exactly the result I was looking for, many thanks<br />
<br />
RangerLad
</div>


Thanks angelIII thats exactly the result I was looking for, many thanks

RangerLad

<div>
<div class="content wysiwyg-content">
Hi Experts<br />
<br />
I need to create a date string then do a test against it with another date within a SQL Stored Procedure. So I am first of all extracting the Year I want into a variable called @FinancialYr then need to set a date of 1/4/@FinancialYr.<br />
<br />
My existing code is;<br />
<br />
set @FinancialYrStart = cast((&quot;01/04/&quot;&amp;@FinancialY<wbr />r) as datetime)<br />
print &nbsp;convert(datetime, @FinancialYrStart)<br />
<br />
The second line is where I am trying to view the result. I am getting an error ;<br />
&quot;Syntax error converting the varchar value '01/04/' to a column of data type int.&quot;<br />
<br />
Can anyone give me an idea where the syntax is falling down ?<br />
<br />
Many thanks<br />
RangerLad
</div>
</div>


Hi Experts

I need to create a date string then do a test against it with another date within a SQL Stored Procedure. So I am first of all extracting the Year I want into a variable called @FinancialYr then need to set a date of 1/4/@FinancialYr.

My existing code is;

set @FinancialYrStart = cast(("01/04/"&@FinancialYr) as datetime)
print  convert(datetime, @FinancialYrStart)

The second line is where I am trying to view the result. I am getting an error ;
"Syntax error converting the varchar value '01/04/' to a column of data type int."

Can anyone give me an idea where the syntax is falling down ?

Many thanks
RangerLad

Syntax question for SQL Stored Procedure

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.