Quick question, what is the Isolation Level set by the applications?

😎

Head-Desk :pinch:

😎

Can you please post the DDL (create table), some sample data as an insert statement and the expected results?

😎

What you have described so far isn't a complex task but it...

The way you describe it here does not fully match the initial requirements, can you please elaborate?

😎

Generating the output in the format described in your last post is easy, here...

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

...