Store duration in seconds as an integer; then average is quite easy. Right now you're trying to take an average of a string converted to a float converted to a datetime converted to a time. If that doesn't sound wrong to you, read it again. Then consider that time represents a point time. What is...

You don't need to use pivot you can use dynamic SQL and cursor see example below: DECLARE @From date='1/1/2010', @To date ='1/1/2015' Declare @TempDate datetime Declare @xDate datetime Set @xDate = @From Create Table #Dates(SYear int,StartDate datetime) While (@xDate <= @To) Be...

declare @sql NVARCHAR (MAX) set @sql = N' DECLARE @begin int Declare @end int Declare @name NVARCHAR (250) DECLARE @StartDate NVARCHAR(50) DECLARE @EndDate NVARCHAR(50) SELECT @StartDate=''2012-01-01'' , @EndDate= convert (nvarchar (10), GETDATE(), 120) set @begin = 1 select @end = count(name) f...

I have a table records of employees and a status table in SQL Server, I need to mount a status history for Employee-Month and Year if he was ENABLED in January 2014 and the Status DISABLED status in April 2014, the following months should contain the last status if no other occurrence. On the sta...

So at work something dreadful happened a database server went down and I am having an issue recovering one of our databases from our backups. When I try to restore from a backup using SQL Management Studio the backup proceeds to 100% then fails at the end with the following: An inconsistency wa...

I have a job (Update Tickets) scheduled in Job Agent with a single schedule of "Occurs every day every 30 minute(s) between 12:00:00 AM and 11:59:59 PM. Schedule will be used starting on 11/4/2013." When I use Log File Viewer to see the history for this job, I see no entries for a 2.5 hour period...

you can use this command: Select table_name From INFORMATION_SCHEMA.COLUMNS Where column_name not in('updateddate','createddate') and schema_name='my_schema';