select two values from table and insert in one column

Goran Bibic

7y891SQL

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.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar7y ago
Accepted 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
+1
Jaish Mathews7y ago
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.Name + "-" + Document.Count + "-" + Document.Company
Please search and understrand ViewModel and DTO objects and their usage.
0
Amit Mohanty7y ago
Try this:

SELECT '201 ULAZNI RACUN OSTALO - ' + CAST(max(number) AS VARCHAR) + ' - ' + company from dbo.partner GROUP BY company
0
Rajanikant Hawaldar7y ago
Let me know issue fixed or not and if any other concerns
0