Do you have plenty of free space on the disk(s) on which the msdb data and log files are located?

John

Gosh, that's the first time you've mentioned that requirement. But not to worry - all you need is a UNION ALL and a further statement selecting all rows where...

Is it not as simple as this?

SELECT

id

,product

,MIN(start_date) AS StartDate

,MAX(end_date) AS EndDate

,DATEDIFF(DAY,MIN(start_date),MAX(end_date)) AS Diff

FROM @t

WHERE end_date IS NOT NULL

GROUP BY

id

,product

John

It is if you don't want to lose any data. Yes, if you were doing this at all then perhaps...

Pedro

It's all explained here.

John

Ooo, how interesting. I thought it was sys.master_files that doesn't get updated immediately, not sys.database_files.

John

That's curious. What does this return, please?

SELECT name, physical_name

FROM Widgets_Copy.sys.database_files

John

Are you sure you're looking at the physical name of the files and not the logical name? Please will you post the RESTORE DATABASE script you ran? (If...

https://msdn.microsoft.com/en-GB/library/ms187928(v=sql.100).aspx

John

No, system accounts can't be used for interactive logins. Did you give your own Windows account access when you installed SQL Server? If not, you'll need to ask...

There are circumstances in which option 4 is the correct answer. The question does not state that the table is empty, nor does it say anything about the data...

Sergiy (1/6/2016)

---

Those who know other languages better than SQL they prefer to use CTE. it's simply more comfortable for them.

Those who know how to design databases and program in SQL...

Is that a problem? Should the language be kept in a glass case and never added to or...

Edvard

Not directly, no. You could do some additional fancy date arithmetic to subtract Saturdays or Sundays, or you could create a Dates table, and join to that, counting only...

Nicole

You say it's for ETL processing - are you using SSIS? If so, you might consider weeding out the invalid values in your data flow. There are ways...