Query on sql server?

Question

Query on sql server?

Navigation

#1 by (0 votes)
#2 by (-2 votes)

0

I have a following query

SELECT
    A.IdDepartment,
    A.IdParent,
    A.Localidad,
    A.Codigo,
    A.Nombre,
    A.Departamento,
    A.Fecha
FROM VW_HORARIOS A
INNER JOIN VW_DAY_WORK B ON A.Codigo = B.Codigo AND A.Fecha = B.Fecha
GROUP BY A.IdDepartment,A.IdParent, A.Localidad, A.Codigo, A.Nombre, A.Departamento, A.Fecha, A.[Registro Entrada],A.[Registro Salida]
ORDER BY A.Fecha

but I want you to show me only the records that are in this view VW_DAY_WORK , help

sql sql-server

asked by Jose Maria Valera Rodriguez 25.01.2018 в 00:03

source

2 answers

How to get the value of an input using closest in Jquery? angular error Can not find module 'rxjs / internal / Observable'

score 0 · Answer 1

SELECT
    B.*
FROM VW_HORARIOS A
INNER JOIN VW_DAY_WORK B ON A.Codigo = B.Codigo AND A.Fecha = B.Fecha
GROUP BY A.IdDepartment,A.IdParent, A.Localidad, A.Codigo, A.Nombre, A.Departamento, A.Fecha, A.[Registro Entrada],A.[Registro Salida]
ORDER BY A.Fecha

score -2 · Answer 2

SELECT
    A.IdDepartment,
    A.IdParent,
    A.Localidad,
    A.Codigo,
    A.Nombre,
    A.Departamento,
    A.Fecha
FROM 
VW_HORARIOS A
RIGHT JOIN VW_DAY_WORK B ON A.Codigo = B.Codigo AND A.Fecha = B.Fecha
GROUP BY A.IdDepartment,A.IdParent, A.Localidad, A.Codigo, A.Nombre, A.Departamento, A.Fecha, A.[Registro Entrada],A.[Registro Salida]
ORDER BY A.Fecha