ptownbro (10/27/2016)

---

Sorry. This solution would not work for me. I understand there are a lot of ways to setup your solution to make it easy to rollup calendar data. But...

Deries (10/26/2016)

---

Luis, Thank you for the code and the suggestion. Really Appreciate it. We need to show hours in the secondary table as in the front end GUI we got...

This should do what you are looking for

DECLARE @datetest TABLE (CaseID INT, MTDThresholdDate date, YTDThresholdDate date);

INSERT INTO @datetest (CaseID, MTDThresholdDate, YTDThresholdDate)

VALUES (1, NULL, NULL)

, ...

The correct covering index also takes care of the order by

CREATE...

I...

drew.allen (10/24/2016)

---

This is known as the packing intervals problem. Itzik Ben-Gan wrote up a New Solution to the Packing Intervals Problem. You're going to need to pack the...

It can also be done without the CTE or the need for a @results table.

And since it's a single statement, there is no need for the explicit transaction.

CREATE PROCEDURE dbo.GetNextId

...

Modify tblMonths to be more like a proper calendar table

CREATE TABLE dbo.tblMonths (

MonthKey int,

Month_Name varchar(40),

Quarter_Name varchar(40),...

NBSteve (10/24/2016)

---

DesNorton (3/6/2016)

---

You could also pass the filter directly to xp_readerrorlog.

See this post ... http://www.mssqltips.com/sqlservertip/1476/reading-the-sql-server-log-files-using-tsql/%5B/quote%5D

While generally a good idea, that would defeat the point of this script. ...

Please do not cross post.

This question was posted on SQL 2008 and SQL 2012 boards.

What version of SQL are you using, as it may affect the solutions that are proposed.

You can use Alan Burstein's PatExclude8K[/url]

WITH cteData AS (

SELECT x.String

FROM (VALUES('XDX114A77400'),

...

TheSQLGuru (10/20/2016)

---

I really didn't follow what said about a view and then sproc. But I have these issues:

1) first and foremost, you have a function around a pair of columns...

Firstly, it would help if you provided data in a readily usable format.

That said, this should do the trick.

-- Create a table to house the demo data

CREATE TABLE #Data (

...

select

TABLE_QUALIFIER = DB_NAME()

, TABLE_OWNER = OBJECT_SCHEMA_NAME(object_id)

, TABLE_NAME = OBJECT_NAME(object_id)

, *

from sys.columns

where object_id = OBJECT_ID('dbo.WHATEVER_THE_TABLE_IS', 'U')

Does this query return the the same value in both columns?

And is it '2016-10-19 09:59:59.997' or '2016-10-19 10:00:00.997'?

declare @StartdateTime datetime;

SELECT TOP 1 @PortsLastEndDate = EndDate

FROM dbo.BandwidthLogCalculatedTest6

WHERE PortIndex = 8

ORDER BY...