<div>
update e<br />
set e.Name = c.Name + ' ' + cast(year(e.date) as varchar(4)) + '-' + cast(month(e.date) as varchar(4)) <br />
from<br />
Enrollments e<br />
join Courses c on e.CourseId = c.Id<br />
where instance &gt;&nbsp;0
</div>


update e
set e.Name = c.Name + ' ' + cast(year(e.date) as varchar(4)) + '-' + cast(month(e.date) as varchar(4))
from
Enrollments e
join Courses c on e.CourseId = c.Id
where instance > 0

<div>
Great - thanks - just one question - I need the course name transferred with no date suffix where instance &lt;1
</div>


Great - thanks - just one question - I need the course name transferred with no date suffix where instance <1

<div>
<div class="content wysiwyg-content">
Hi:<br />
<br />
I have two joined tabled - Courses and Enrollments structured as follows:<br />
<br />
Courses<br />
----------<br />
Id<br />
Name<br />
<br />
Enrollments<br />
---------------<br />
Id<br />
CourseId<br />
Name<br />
Instance<br />
Date<br />
<br />
I would like to go through the Enrollments table and create/change the name so that if the instance of the enrollment is greater than 0 (the student has taken the course more than once), the Name of the Enrollment would be the Course Name plus the Year and Month the student took the course. &nbsp;For example, if the student took a second instance of Algebra this month, and the instance field was marked as 1, the Name of the Enrollment for that record would be 'Algebra 2013-11'<br />
<br />
I'm having a problem wrapping my head around this. &nbsp;Any help greatly appreciated.<br />
<br />
RBS
</div>
</div>


Hi:

I have two joined tabled - Courses and Enrollments structured as follows:

Courses
----------
Id
Name

Enrollments
---------------
Id
CourseId
Name
Instance
Date

I would like to go through the Enrollments table and create/change the name so that if the instance of the enrollment is greater than 0 (the student has taken the course more than once), the Name of the Enrollment would be the Course Name plus the Year and Month the student took the course.  For example, if the student took a second instance of Algebra this month, and the instance field was marked as 1, the Name of the Enrollment for that record would be 'Algebra 2013-11'

I'm having a problem wrapping my head around this.  Any help greatly appreciated.

RBS

T-SQL Fill in Field from Another Table

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

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.