zoggling (11/22/2016)

---

Phil Parkin (11/22/2016)

---

We have installed SQL Server 2016 Web Edition (64-bit) on a new virtualised database server running Windows Server 2016 Standard. We have an existing web server running...

Thom A (11/22/2016)

---

Phil Parkin (11/22/2016)

---

We have installed SQL Server 2016 Web Edition (64-bit) on a new virtualised database server running Windows Server 2016 Standard. We have an existing web server...

We have installed SQL Server 2016 Web Edition (64-bit) on a new virtualised database server running Windows Server 2016 Standard. We have an existing web server running Windows Server 2008...

mcfarlandparkway (11/21/2016)

---

Yeah, TY

I have commented that return statement and kept a break point on Execute sql task. I can see all the values which I am passing to that SP...

If you are prepared to accept the occasional false positive, the checksum method is not so bad.

The Except method is, however, more robust.

Jeff Moden (11/21/2016)

---

Now you have...

EXCEPT on a 2-million-row resultset is tidier than a column-by-column comparison, but still not to be recommended, IMO.

mcfarlandparkway (11/21/2016)

---

I didn't understood this point

I understand that, but OUTPUT parameters in a proc do not need the RETURN keyword, all you need to do is set their value within...

PJ_SQL (11/21/2016)

---

Yes it would need to update multiple files in the table.

Are you implying that I import the file received from third party to a table and then update each...

mcfarlandparkway (11/21/2016)

---

I changed from Select to SET.

Still its showing error

"Input string was not in a correct format.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly,...

I understand that, but OUTPUT parameters in a proc...

PJ_SQL (11/21/2016)

---

Hello,

I am sending data(text file) to third party which they import to their tool which users pull information from and make changes.

That data sent is combination of multiple...

mcfarlandparkway (11/21/2016)

---

I have an Execute Sql Task where I am using this SP.

CREATE PROCEDURE [dbo].[InsData]

@DB VARCHAR(20),

@FeT VARCHAR(20),

@SType VARCHAR(50),

@Id INT OUTPUT

AS

BEGIN

SET NOCOUNT ON

INSERT INTO dbo.Emp(FeT,DB,SType,StrtDate)

VALUES(@FeT, @DB, @SType, getdate())

SELECT @Id =...

What client...

djj (11/21/2016)

---

WayneS (11/21/2016)

---

Hugo Kornelis (11/17/2016)

---

Luis Cazares (11/17/2016)

---

Hugo Kornelis (11/17/2016)

---

Eirikur Eiriksson (11/17/2016)

---

Brandie Tarvin (11/17/2016)

---

Beatrix Kiddo (11/17/2016)

---

It's in the link there.

CREATE OR ALTER (Yes, we heard you !!!) – New CREATE OR...