sqlvogel (1/3/2015)

---

It's possible to do two inserts in a single statement like this:

INSERT INTO dbo.table_b (empid, epsal)

SELECT empid, epsal

FROM

(

MERGE INTO...

KoldCoffee (1/3/2015)

---

I have an Execute Process Task that uses this tutorial to get the job of getting a file from a remote server dropped into a local folder.

http://winscp.net/eng/docs/guide_ssis

Next I want...

To me it appears as the nolock hint is used here as a blanket solution, without understanding the potential effects of it,...

A quick (self explanatory) solution which should be enough to get you passed this hurdle

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

/* Drop the sample table if it exists */

IF OBJECT_ID(N'tempdb..#MyPhoneList') IS NOT NULL...

Quick questions, could you provide some sample data? Why the NOLOCK hints? What is the definition of a unique entry in the set?

😎

Quick thought, this can be done in some circumstances where the result sets are equal in structure, consider this example

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

CREATE PROCEDURE dbo.TWO_RESULT_USP

AS

SELECT

OBJECT_ID

...

Jeff Moden (1/3/2015)

---

I'll see if I can come up with a simplified example similar to the data I've had to deal with in the past makes it impossible to do...

Strongly recommend following Luis's suggestion, simple and well tested approach.

😎

For completeness, below is an sample solution which replicates the logic in a query instead of the splitter function.

USE tempdb;

SET...

Phil Parkin (1/3/2015)

---

Eirikur Eiriksson (1/3/2015)

---

Be careful with the implicit conversion as the results will be depending on the system settings, no guarantee that it...

Phil Parkin (1/3/2015)

---

Thanks, but I know this 🙂

The quote was from the original post & I just wanted to throw this in as an aside, not as a suggested solution...

Be careful with the implicit conversion as the results will be depending on the system settings, no guarantee that it will be interpreted as...

Given that the originating data type is not date, the operation is twofold, first...

Phil Parkin (1/3/2015)

---

By the way, this is not a great idea:

Rather than @@Identity, you would be better off...

It doesn't as the output clause retrieves the identity values generated in the first...

marcia.j.wilson (1/2/2015)

---

One example of what I was looking for was whether DT_R8 would map to DT_NUMERIC. (It did.) I was getting one of those errors where you know something's...