All gists - Opengist

0 likes

0 forks

3 files

123

test

11111111111

0 likes

0 forks

1 files

1	<h1>Hello World</h1>

1 likes

0 forks

1 files

0 likes

0 forks

2 files

1 likes

0 forks

1 files

ffffg

ggg

1 likes

0 forks

1 files

1	--TEST
2	SELECT r.session_id AS [Session_Id]
3	,r.command AS [command]
4	,CONVERT(NUMERIC(6, 2), r.percent_complete) AS [% Complete]
5	,start_time AS [Start Time]
6	,GETDATE() AS [Current Time]
7	,CONVERT(VARCHAR(20), DATEADD(ms, r.estimated_completion_time, GetDate()), 20) AS [Estimated Completion Time]
8	,CONVERT(NUMERIC(32, 2), r.total_elapsed_time / 1000.0 / 60.0) AS [Elapsed Min]
9	,CONVERT(NUMERIC(32, 2), r.estimated_completion_time / 1000.0 / 60.0) AS [Estimated Min]
10	,CONVERT(NUMERIC(32, 2), r.estimated_completion_time / 1000.0 / 60.0 / 60.0) AS [Estimated Hours]