Timeline for Msg 8114, Level 16, State 5, Line 1 Error converting data type nvarchar to float
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 25, 2019 at 10:06 | vote | accept | Neymar0001 | ||
| Jul 19, 2019 at 8:21 | history | edited | Akina | CC BY-SA 4.0 |
Code formatting
|
| Jul 19, 2019 at 7:58 | answer | added | Neymar0001 | timeline score: 1 | |
| Jul 19, 2019 at 7:34 | comment | added | Akina |
SELECT CAST(SUM(try_convert(numeric(38, 5), Rüsten_Ist)) AS CHAR) AS Rüsten, 1 AS filtering ... and the same for all another SUMs. Alternatively - posess SELECT FORMAT((... as the first UNION's subquery, and finally sort the UNION's result as needed.
|
|
| Jul 19, 2019 at 7:22 | history | edited | McNets | CC BY-SA 4.0 |
Format
|
| Jul 19, 2019 at 7:15 | history | asked | Neymar0001 | CC BY-SA 4.0 |