0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in the history and origins of science and mathematics

declare @CabDoc Table
(

Codigo int,
Data datetime,
Entidade int,
Valor int
)


declare @LinDoc Table
(

CodigoCabDoc int,
NumLinha int,
CodArtigo nvarchar(max),
Descricao nvarchar(max),
Quantidade int,
PrecoUnitario int

)

select getdate(), cast('2013-06-21' as datetime) 

select 1 where getdate() between cast('2013-06-20' as datetime) and cast('2013-06-21' as datetime) 
Select * 
  From @CabDoc CabDoc
 Inner Join @LinDoc LinDoc
         On LinDoc.CodigoCabDoc = Codigo
        And LinDoc.CodArtigo = 'XPTO'
 --Where CabDoc.Data between

fork query

edited jun 21 13

created jun 21 13 anonymous