Lynn Pettis (1/5/2015)

---

No real difference between CAST and CONVERT unless you need to use a style code for the conversion. Also, if you listen to Mr. Celko, CAST is...

Duplicate thread, answer in this thread

😎

salardx (1/5/2015)

---

Hi guys, I read this link and I have exactly the same problem:

http://www.sqlservercentral.com/Forums/Topic613703-338-1.aspx

But the solution doesn't work for me! I got a type as table:

CREATE TYPE [dbo].[User_Ven_Att] AS TABLE(

[userName]...

Quick fix using row_number in a sub query, just adjust as needed

😎

USE tempdb;

GO

SET...

Jeff Moden (1/4/2015)

---

Eirikur Eiriksson (1/4/2015)

---

Jeff Moden (1/4/2015)

---

Eirikur Eiriksson (1/4/2015)

---

The MERGE does produce an optimal plan for the operation, single scan of both the source table and the first destination table,...

Jeff Moden (1/4/2015)

---

Eirikur Eiriksson (1/4/2015)

---

The MERGE does produce an optimal plan for the operation, single scan of both the source table and the first destination table, one merge operation on...

knikolov4521 (1/4/2015)

---

Hello, can someone help me with this:

I have two tables. I have three columns DEPARTMENT_NAME, LAST_NAME, JOB_ID.

DEPARTMENT_NAME is from table 1. JOB_ID and LAST_NAME are from table 2....

KoldCoffee (1/4/2015)

---

Answers:

1: one remote location for the...

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...