Hi i have a table and when i query for a row i want to know which column a specific data appears in TABLE | A1 | A2 | A3 | A4 | A5 | ID | QA W …
How remove from user database type duplicate records with id 221
I have the following stored procedure: ALTER PROCEDURE [dbo].[sp_ImportSurveys] @surveys udtSurveys readonly AS BEGIN INSERT INTO Surveys (Funzione, Id_Intervento, …
returns a table of several columns
I would like to make a function that returns a table of several columns in dependence on the number of columns entered per parameter That is: if the variable num_columns is 10, the function must …
Excluding a value from a count with SQL
I have two temp tables set up. Table A consists of members and the businesses that they manage, multiple members can be associated to a single business. Table B consists of just the members, their ID’…
Updating table with joining to a second table
I’m trying to update the value in column ‘ID’ from table 1 with the value in column ‘ID’ from table 2 – Only if they do not match. I think I have everything except the set statement down. I’m …
SAS Case Statement – if this, then that . else leave as is
I have a column with some unwanted data “XX” and want to set them as 0. Otherwise, keep the column’s data as it is. Something similar to if columnA = “XX” then 0 Else columnA. I tried doing this using …
Python: Read database to display table with equal columns
I have a program when it currently reads from a database, which can be found here. I have users choose a specific record they want to display so the SQL command will execute that record. Now I have a …
Why do the return results of IIF and ISNULL not match my expectation when using date values?
I am trying to use IIF() to return the cast of a column as a date but only when the value isn’t a blank string [the values are not being stored as a null in the database I am working with]. I tried …
Showing multi row in one row
I am developing a page where I have to show all the jobs of an employee with a work number and the total of each type of hours in each work I can display it, but, my problem is when the employer …
Is there a way to import all databases into one database with Mysqldump?
I want to gather automatically all my databases into one with Mysqldump, is there a way to do it ? For example what I want is to move all the tables from DB1, DB2 and DB3 into DB4 (DB4 can already …