please see this article that shows how...

yes, I am sure you can.

but before this can be easily delivered......can you please provide sample table scripts/insert data/expected results....examples and links...

wwwnlc111 (5/4/2016)

---

Hi,

I need to show SQL job execution for last 30 days at what time, this mean I have Date and time.

Now question how I can take Time (hh:mm) for...

DECLARE @calendardate datetime

SET @calendardate = '20160901'

SELECT fiscal_year = CASE

...

sunil.mvs (5/2/2016)

---

Tons of Thanks to you , in fixing and finding solution . But I am not sure , how it works on production data . As of now...

to the OP

you have marked my code as correct but havent posted any comments?

would be interested to know how you are getting on. ??

jasona.work (5/1/2016)

---

First up, Phil has it right. Get backups of *ALL* the databases on the server and test restore them. It doesn't have to be to a "server,"...

Phil Parkin (4/30/2016)

---

First things first: protect the data. Get him to get backups and to restore them on another server to verify them.

Then ensure that regular backups are in place.

Then...

Jacob Wilkins (4/29/2016)

---

You didn't misread it, but the sample data...

Jacob...dont seem to get the results expected from your code in comparison to mine.....have I misread your code:

-- create some test data

USE tempdb

GO

IF OBJECT_ID('tempdb..tempdata', 'U') IS NOT NULL

...

my test script......responses appreciated !

-- create some test data

USE tempdb

GO

IF OBJECT_ID('tempdb..tempdata', 'U') IS NOT NULL

DROP TABLE tempdb..tempdata ;

WITH ctetrans as (

SELECT TOP 5000000

BusName = CHAR(Abs(Checksum(Newid()))...

Jacob Wilkins (4/29/2016)

---

Ah, most likely you have a NULL...

Hi Jacob.....

on a larger data set I am getting

A TOP or FETCH clause contains an invalid value.

any ideas please?

maybe.....

CREATE table #temp (SysKey int identity(1,1) ,BusName varchar(9) ,BusType varchar(6) ,StartDateKey Datetime ,EndDatekey Datetime)

Insert into #temp (BusName,BusType,StartDateKey,EndDatekey)

Select 'A' ,'AC', '20130401', '20130402' union ALL

Select 'A' ,'AC', '20130403' ,'20130404' union ALL

Select 'A'...

Rod at work (4/28/2016)

---

Jeff, your reply was very interesting. I'm saving that for when I have a discussion with my boss about this. I am especially interested in the statistics...