<div>
cause your mo, dy and YR are int<br />
try<br />
set [date] = cast(mo as varchar)+'/'+cast(dy as varchar)+'/'+cast(YR as varchar)
</div>


cause your mo, dy and YR are int
try
set [date] = cast(mo as varchar)+'/'+cast(dy as varchar)+'/'+cast(YR as varchar)

<div>
See - I knew it was something simple...<br />
<br />
Thanks Nightman - you were first to answer...<br />
<br />
Sean
</div>


See - I knew it was something simple...

Thanks Nightman - you were first to answer...

Sean

<div>
SQL will automatically recognize YYYYMMDD as a valid format, so this is easier to do:<br />
<br />
UPDATE [daily sales totals by account type]<br />
SET [date] = yr * 10000 + mo * 100 + dy<br />

</div>


SQL will automatically recognize YYYYMMDD as a valid format, so this is easier to do:

UPDATE [daily sales totals by account type]
SET [date] = yr * 10000 + mo * 100 + dy


<div>
<div class="content wysiwyg-content">
I am trying to update a table using the following query:<br />
update [daily sales totals by account type]<br />
set [date] = mo+'/'+dy+'/'+YR<br />
<br />
MO, DY and YR are fields in the table [daily sales totals by account type] and are all int. &nbsp;[date] is a varchar field.<br />
<br />
I am getting the following error:<br />
Server: Msg 245, Level 16, State 1, Line 1<br />
Syntax error converting the varchar value '/' to a column of data type int.<br />
<br />
I have tried using CAST, CONVERT, &amp;&nbsp;(instead of +), single quotes, double quotes and have not been able to get this one to work. &nbsp;I am needing a swift kick in the butt - 'cuz I'm sure this one is something simple that I am overlooking...been working on this issue too long...<br />
<br />
Can someone please tell me where I am going wrong?<br />
<br />
Thanks!<br />
<br />
Sean
</div>
</div>


I am trying to update a table using the following query:
update [daily sales totals by account type]
set [date] = mo+'/'+dy+'/'+YR

MO, DY and YR are fields in the table [daily sales totals by account type] and are all int.  [date] is a varchar field.

I am getting the following error:
Server: Msg 245, Level 16, State 1, Line 1
Syntax error converting the varchar value '/' to a column of data type int.

I have tried using CAST, CONVERT, & (instead of +), single quotes, double quotes and have not been able to get this one to work.  I am needing a swift kick in the butt - 'cuz I'm sure this one is something simple that I am overlooking...been working on this issue too long...

Can someone please tell me where I am going wrong?

Thanks!

Sean

Using forward slash &quot;/&quot; in query

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.

Using forward slash &quot;/&quot; in query

Using forward slash "/" in query