Adding(merge) two integer columns and make that as a single output column

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • phanikumar32
    New Member
    • Apr 2014
    • 22

    Adding(merge) two integer columns and make that as a single output column

    Hi all,

    Can any one please provide me the SQL Query for my following requirement.

    As showing in the Figure one i have the Input.
    From that Input i want the Output as shown in figure 2.


    Thanks In Advance
    Phani Kumar.
    Attached Files
  • jforbes
    Recognized Expert Top Contributor
    • Aug 2014
    • 1107

    #2
    You need to let SQL know you want to work with them as string, SQL can be a little dimwitted at times:

    Code:
    SELECT CONVERT(NVARCHAR(5), JoinDate) + '/' + CONVERT(NVARCHAR(5), JoinYear) AS ConcatJoinDate FROM YourTable

    Comment

    • phanikumar32
      New Member
      • Apr 2014
      • 22

      #3
      Thank you Mr jforbes for your response.

      Comment

      Working...