select two values from table and insert in one column

Question

Need select two values from table and insert in one column all need to be text

Need to be this type in 1 column

"Document name -count number - Company"

201 ULAZNI RACUN OSTALO -(max(number)) - (select company from dbo.partnert))

201 ULAZNI RACUN OSTALO' + (max(number)) + (select company from dbo.partner))

I try this but error is

Conversion failed when converting the varchar value '201 ULAZNI RACUN OSTALO -' to data type int.

Rajanikant Hawaldar · Answer

Hi Dear, By referring this below sample you can do it SAMPLE 1 You are currently using double quotes you should instead use single quotes since that is a valid string in SQL. DOSQL "INSERT INTO Leads (DateTimeField) VALUES (cbdate1 + ' ' + cbtime1)" Edit: Now if you get further problems it might be because your DateTimeField is a datetime datatype. Now you could then after concatenating convert or cast the string to the correct format. Like: DOSQL "INSERT INTO Leads (DateTimeField) VALUES (Convert(datetime, cbdate1 + ' ' + cbtime1))" Edit #2: Without a 24 hour part you would need a mon dd yyyy format ex: Oct 22 2012. Otherwise you might have to try and get the time part into a 24 hour format. SAMPLE 2 A couple of different ways: 1) make the insert part of the origianl query: INSERT INTO Printers_LOlZ (ColumnName) Select Concat(Manufacturer, ' ', Model) AS Printer From Inventory Where Item LIKE "%Printer%" Group by Printer 2) Assign the values to a variable/ table variable and insert them after. Let us know if you need more... Thanks

Jaish Mathews · Answer

No need to do in Databse, but do it as a mapping in your application layers. You need to take a decision during design. What I do normally using a ViewModel or DTO to send to UI. This ViewModel object will be mapped from the Database context model with the data format what UI needed ie. DocumentDTO.DocumentInfo = Document.N ame + "-" + Document.Count + "-" + Document.Company Please search and understrand ViewModel and DTO objects and their usage.

Amit Mohanty · Answer

Try this: SELECT '201 ULAZNI RACUN OSTALO - ' + CAST(max(number) AS VARCHAR) + ' - ' + company from dbo.partner GROUP BY company

Rajanikant Hawaldar · Answer

Let me know issue fixed or not and if any other concerns