473,326 Members | 2,588 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

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 Images
File Type: png Figure 1.png (3.7 KB, 138 views)
File Type: png Figure 2.png (3.6 KB, 141 views)
Aug 21 '14 #1
2 1156
jforbes
1,107 Expert 1GB
You need to let SQL know you want to work with them as string, SQL can be a little dimwitted at times:

Expand|Select|Wrap|Line Numbers
  1. SELECT CONVERT(NVARCHAR(5), JoinDate) + '/' + CONVERT(NVARCHAR(5), JoinYear) AS ConcatJoinDate FROM YourTable
Aug 21 '14 #2
Thank you Mr jforbes for your response.
Aug 21 '14 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Michel Rousseau | last post by:
I have a two column table containing numbers. I would like to make a third column called fieldname "special". In this column I would like to put the following: if column A = column B, then...
9
by: MrSpock | last post by:
1. Create a new Windows Application project. 2. Open the project properties and check "Make single instance application". 3. Build. 4. Go to the release folder and run the application. 5. Try to...
0
by: vinaykumar Maladkar | last post by:
Hi All, I m using Visual studio 2005 and C#. i want to show comparative data of different cars like their price , engine , capacity etc. So i am using DataGridView. but How to group one or more...
1
by: venkuforu | last post by:
Hi, How to Make Only one column Editable in vsfflexgrid.....
2
by: Ken B | last post by:
How can I make a datagrid column into a single row that spans all the other columns? In this case I have a comment field that I want to make as wide as the table but I cannot figure out how to...
1
by: Jon Todd | last post by:
Happy holidays all! I'm developing an application and, as a relative newbie to Python, have come across a stumbling block with Tkinter. I'd like to have a button that when pressed executes a...
2
by: prigupta2 | last post by:
HI friends i wand to add more the one record in single detail column eg name: Mr. abc name: Mr. xyz name: Er.pqr Address: aaa Address: bbb ...
4
by: luciegiles | last post by:
Hi, I wish to transpose data in an Access table currently in a single column over many rows to many columns over single row: Current format: CHI DateIssued 123456 01/01/10...
1
by: cbjones | last post by:
Can I lable the output column resulting from a SELECT query with a variable from one of the tables which are the source of the data? I know I can hard code the lables in the SELECT statement but...
5
by: lollol | last post by:
1st column: block_number 2nd column: unit_number I want to merge the 2 columns and get a tenant_id column. E.g. block_number = 12 unit_number = 1234 tenant_id = 121234 But i kept trying and...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.