hi how are I have this query
SELECT
nom_emp,
ISNULL (LENTES,0)[LENTE],
Fecha_Gestion,
ISNULL (AYUDA_ODONTOLOGICA,0)[AYUDA ODONTOLOGICA],
Fecha_Gestion
FROM
(SELECT me.nom_emp,Fecha_Gestion,TB.Tipo_Benef,Monto
F...
I need to be able to perform a query in which I must filter by dates, in which I have start date and end date and that the query gives me results that are within the range of those two dates
I have the following query on sql server, the goal is to bring the records of the Personas table that are related to ListaMarketing_persona but since this is an AnyToAny table that joins ListaMarketing , there may be several...
I have an SP in which I create a temporary table in the following way:
SELECT *
INTO #TABLA_AR
FROM TRABAJADOR
WHERE AREA IN (3,5,9,15)
The SP has several processes and if it fails in some process after creating the temporary table, when co...
I need help! I'm working with inheritance. Client: Person
and I need to insert from the Client class, where the methods are (register, modify, delete, list).
I need you to insert yourself in a method!
The idea that I have is to identify the id o...
I'm doing a program of Libros and Autores where a autor has many libros .
When inserting a new Libro I need to get id of autor to save it as fk_dni in table Libros , so I have...
I have a database dynamically attached to my asp.net mvc project, with 12 columns to fill with test data, since I do not find a software that generates exactly the data I need and the limits of each one as age, names, dates, etc. I think that a...
I have the following query:
SELECT
COUNT(IDPROVEEDORES),
IDPROVEEDOR
FROM PROVEEDORES
WHERE COUNT(IDPROVEEDORES) > 1
But I get the following error:
Incorrect syntax near the keyword 'where'.
I have a problem with the insertion of the following data in the following table:
CREATE TABLE TB_ADMIN_MONITOREO
(
FECHA_PROCESO NVARCHAR,
FECHA_EJECUCION DATETIME,
SERVIDOR NVARCHAR,
UNIDAD CHAR,
[LIBRE...