Author, Web Developer

Wayne Barron

Independent Consultant

Kelvin McDaniel

<div>
I changed it to an INT and it worked out great. 
Thanks, David. 
 
For those who may find a use of this code. 
In order to use it in your site, you will need to do it like this. 
 

<pre><code class="code-10 nolinks" id="code-20-42731803-1">&lt;%
Set sqlyear = CreateObject(&quot;ADODB.Command&quot;)
sqlyear.ActiveConnection=WConn
sqlyear.Prepared = true
sqlyear.commandtext=&quot;select distinct convert( int, t.TrackYear ) / 10 * 10 as TrackYear from Tracks t order by 1&quot;
set rsYear = sqlyear.execute
while not rsYear.eof
if not rsYear.eof then
strYears = rsYear(&quot;TrackYear&quot;)
end if
%&gt;
&lt;%=strYears%&gt; &lt;br /&gt;
&lt;%
rsYear.movenext
wend
rsYear.close
set rsYear = Nothing
%&gt;
</code></pre>
 
Enjoy. 
Wayne
</div>

<div>
<div class="content wysiwyg-content">
Hello All; 
 
I have a table where the column is a varchar. 
(If it needs to change to an INT or Date, please let me know and I will do so. 
It is not too late to make that change.) 
In the column named = Years 
It has the following example. 
 
1978 
1965 
1985 
2017 
1962 
1998 
2012 
2002 
1958 
1978 
 
OK, What I need to do is the following. 
For the years in the table, they need to output as 
 
1950 
1960 
1970 
1980 
1990 
2000 
2010 
etc... 
 
Thanks. 
Wayne
</div>
</div>

Hello All;

I have a table where the column is a varchar.
(If it needs to change to an INT or Date, please let me know and I will do so.
It is not too late to make that change.)
In the column named = Years
It has the following example.

1978
1965
1985
2017
1962
1998
2012
2002
1958
1978

OK, What I need to do is the following.
For the years in the table, they need to output as

1950
1960
1970
1980
1990
2000
2010
etc...

Thanks.
Wayne

SQL Server change 1978 to 1970 during output

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

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.