To clarify, are you looking for a form of Consecutive Number Sequences, i.e. for the values 1-3 you would have the combinations below?

😎

1

12

123

13

2

23

3

Quick questions for clarification:

1. Why are you doing this?

2. What is the end goal?

3. What is the cardinality of the table?

4. Should each combination...

Quick alternative to Chris's solution, this one catches better the fractional end hours

😎

USE TEEST;

GO

SET NOCOUNT ON;

--http://www.sqlservercentral.com/Forums/Topic1810466-3077-1.aspx

--/* -- UNCOMMENT THIS LINE TO SKIP THE SETUP

-- sample data setup

IF OBJECT_ID(N'dbo.MyTable') IS NOT...

vprunic (8/19/2016)

---

Hello all,

what does this mean?

Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult:...

Here is an article on PS & SMO

😎

Quick example, recommend you add constraints to the data type columns to prevent malicious code injection.

😎

USE TEEST;

GO

SET NOCOUNT ON;

--

IF OBJECT_ID(N'dbo.TBL_TEST_DYNAMIC_CREATE') IS NOT NULL DROP TABLE dbo.TBL_TEST_DYNAMIC_CREATE;

-- Create the table definition...

😀

...just managed to save mine

😎

Perfectly normal.

😎

Quick suggestion, opening the plan in SQL Sentry Plan Explorer is probably the easiest way to do this, trying to query/analyse the plan can be a very complex task.

😎

Snargables (8/16/2016)

---

Everything i read goes on and on about how bad it is. One of our sql instances houses a database that uses mainly batch processing and as a result...

Quick solution for SQL Server 2008

😎

First add this POC index

CREATE NONCLUSTERED INDEX NCLIDX_DBO_ZZZ_SSC_HELP_GROUP_STARTDATE ON dbo.zzz_SSC_Help (GroupID ASC, StartDate ASC) INCLUDE (EndDate);

The query

;WITH BASE_DATA AS

(

SELECT

...

DAP 93723 (8/12/2016)

---

Thanks for all your feedback.

So If I install a new instance of 2012 Standard on the same machine, it's NOT going to affect ANY aspect of existing 2008...

The OP will have to come back with answers to my questions, otherwise we're only guessing, probably an object restore from a backup would be the way to go here...

First...

Not if done correctly, done many times larger files this way.

😎