Advertisements I have two columns, one of data type Smallint and the other int. I am trying to concatenate the two columns and a ‘.’ to produce one final value but I keep getting the "Conversion failed when converting the varchar value ‘1.1’ to data type int error". For instance, if I have ‘1’ in… Read More Conversion failed when converting the varchar value '1.1' to data type int
Advertisements mysql> INSERT INTO Departments VALUES (1, ‘Accounting’), -> (2, ‘Human Resources’), -> (3, ‘Marketing’); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘Resources’), (3, ‘Marketing’)’ at line 2 I have tried using " instead… Read More Why can't I use INSERT INTO … to insert value with whitespace into VARCHAR (ERROR 1064 (42000))?
Advertisements I have a dataset with number (some negative) as varchar in my column, some cell also contain ‘#N/A’, ‘#DIV/0!’ and ‘Null’. I’m trying to convert it to float. But when I run my code it convert everything to ‘Null’ Here is my code: Select col1, case when col1 = ‘#DIV/0!’ then null when col1… Read More Convert varchar to flaot with multiple CASE – SQL
Advertisements I have a request to add data that triggers a trigger that checks one condition, and only after that adds it to the purchase table. He also swears at the lines of initializations total_rasr and id_buyer invalid number, although there are the same types in the table and in the trigger. And the biggest… Read More SQL command not properly ended errror database oracle
Advertisements I am getting an error "Error converting data type varchar to numeric" Select CONCAT(‘$’, ‘ ‘, a * 0.05 + b * 12) As value Variables a and b are having money Data type >Solution : Try casting the arithmetic expression to text before including it as a parameter in the CONCAT() function: SELECT… Read More Concatination in SQL Server
Advertisements I have a number of responses for a multiple-choice questionnaire. My goal is to count the number of respondents who answered ‘A’, ‘B’ etc and further process that data. (The raw data is in JSON but this could be table data too. The JSON format isn’t really a factor but if there’s a better… Read More SQL: Counting the answers from a multiple-choice result
Advertisements estoy tratando de descifrar como armar esta base datos, tengo la siguiente informació pero tengo dudas de donde colocar las claves foraneas ya que el esquema no está tan claro, agradeceria si me pudiesen dar una mano. Sobre todo en la relacion "one or many to one or many" con pregunta y etiqueta, un… Read More Duda base de datos MySql
Advertisements I’ve got a query that selects all indexes from a table and generate an output text to drop them individually. I want to put the DB_NAME() info in the beginning of command for once, but at this moment the data is showed at every index drop. I’ve tried to put a select before, but… Read More Force the output query to shows the DB_NAME() data once
Advertisements I have a column on hours looking like that: |time| ————– 8:54 5:32 4:34 7:12 12:55 10:32 3:54 2:35 I want to count how many rows I have with more than 5 hours? something with the format of the hours makes it problematic for me.. the format is varchar (text). how can I do… Read More Counting hours in format H:mm in SQL
Advertisements So my issue can basically be summarized in this small code I wrote declare @report varchar(100) = ‘fajkfgadjk’ if @report like ‘%_%’ begin select 1 end else begin select 2 end It should show 2 but it is showing 1 It does not happen with others like ‘,&^’ Can someone help me here? I… Read More Like operator not working in SQL server 2019