Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 how to add the time for the month where i give the

Author  Topic 

celv
Starting Member

6 Posts

Posted - 2014-07-04 : 06:16:38
how to add the time for the month where i give the condition


my table is

CREATE TABLE [dbo].[aten](
[Id] [int] NULL,
[Name] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Status] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Section] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Intime] [datetime] NULL,
[Date] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Outtime] [datetime] NULL
) ON [PRIMARY]




i need to total in Intime for a month

celv

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2014-07-04 : 06:38:49
How does the intime value look like?


Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page
   

- Advertisement -