Quick thought, the former returns an empty set and no assignment takes place, the latter returns a set with a empty (null) column whitch is assigned to the variable.

😎

Junglee_George (10/10/2014)

---

I am now using a SELECT DISTINCT to avoid the duplicate records from retrieving.

I can remove this DISTINCT keyword from the query once the OUTER APLLY is changed to...

It is a separate download, SQL Server Data Tools for SQL Server 2014.

😎

The SSDT 2014 is an additional download (last time I checked). To run the 2012 jobs/packages on the 2014 system there are two options, install the 2012 SSIS components on...

ramana3327 (10/11/2014)

---

Hi,

The job is running in Sql 2012 succefully.

I migrated that job in to Sql 2014 instance that is running in seperate box.

The job is running the ssis package. That...

Jeff Moden (10/11/2014)

---

This kind of information is available in a tool called "Books Online". It's the "Help"...

Just for fun, here is a union alternative, certain that this is not the most efficient solution but it is simple to write and fun to play with, uses XML...

Eric M Russell (10/11/2014)

---

There are...

ramana3327 (10/10/2014)

---

Hi,

I installed sql 2014 enterprise edition. I didn't see any visual studio installation by the selection of Integration Service. Where we can develop the Packages?

I am giving the attachment...

Worked for a national statistics office a while back, seen some "interesting" interpretations especially when politics get thrown in the works, very CREATIVE business:-P

😎

This is the essentially the same in SSIS 2012 (VS 2010)

😎

Quick thought, an identity property column cannot be updated, here is a demonstration and a workaround

😎

USE tempdb;

GO

SET NOCOUNT ON;

/* Drop if exists */

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

/*...

Quick (semi) dynamic sql approach, simple and self explanatory

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

CREATE TABLE dbo.TBL_SAMPLE_DATA

(

Doc_ID VARCHAR(20) ...

GilaMonster (10/10/2014)

---

Which the OP said he's using (albeit with a incorrect word, he said advanced settings...

Koen Verbeeck (10/10/2014)

---

You should see this as an...