Sreenivasa Reddy Thotli

SELECT STUFF(RIGHT(CONVERT(VARCHAR,Createddate,0),7),3,3,' ') + ' - ' + STUFF(RIGHT(CONVERT(VARCHAR,DATEADD(HOUR,1,Createddate),0),7),3,3,' ') AS HOUR, COUNT(*) AS COUNT FROM tableName WHERE Createddate BETWEEN CONVERT(DATETIME,FLOOR(CONVERT(FLOAT,GETDATE()))) AND CONVERT(DATETIME,FLOOR(CONVERT(FLOAT,GETDATE())) + 1) GROUP BY STUFF(RIGHT(CONVERT(VARCHAR,Createddate,0),7),3,3,' ') + ' - ' + STUFF(RIGHT(CONVERT(VARCHAR,DATEADD(HOUR,1,Createddate),0),7),3,3,' ') ORDER BY 1

CREATE TRIGGER [dbo].[TGRName] ON [dbo].[TableName] AFTER UPDATE AS BEGIN SET NOCOUNT ON; IF (UPDATE([ColumnName])) INSERT INTO [TableName]([Columns]....) Select distinct [Columns].... from INSERTED I INNER JOIN Deleted D ON D.Id= I.Id WHERE I.[ColumnName] <> D.[ColumnName] SET NOCOUNT OFF END