Solved

concat in sql server: I must do to concatenate the 3rd column...

Posted on 2011-02-24
1
506 Views
Last Modified: 2012-06-21
select s.ComexSecuenciaOperacion, sl.SecuenciaLeasing, s.ComexSecuenciaOperacion + sl.SecuenciaLeasing concat
            from solicitud s inner join solicitudleasing sl
                        on s.CodSolicitud = sl.CodSolicitud
concatenar.jpg
0
Comment
Question by:enrique_aeo
1 Comment
 
LVL 10

Accepted Solution

by:
dwe761 earned 250 total points
ID: 34974229
select s.ComexSecuenciaOperacion, sl.SecuenciaLeasing, convert(varchar(20),s.ComexSecuenciaOperacion) + convert(varchar(20),sl.SecuenciaLeasing) as ConCat
            from solicitud s inner join solicitudleasing sl
                        on s.CodSolicitud = sl.CodSolicitud
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now