Solomon Rutzky (12/26/2015)

---

Just out of curiosity, what exactly...

Welsh Corgi (12/24/2015)

---

Totally screwed up.

SELECT *

FROM PrismDataArchive.dbo.tblcallArchive AS arc

LEFT JOIN PrismData.dbo.tblcall AS Pri ON arc.Call.ID = Pri.Call_ID

WHERE PrismData.dbo.tblcall Pri.Call_ID IS NULL

Msg 4145, Level 15, State 1, Line 13

An expression...

Looks like you fixed the typo.

But telling us that you "can't get it to work" is inviting caustic responses. What is the error you are getting now?

Looks like a typo.

arc.Call.ID = Pri.Call_ID

brad.mccollum (12/23/2015)

---

I'm working on an SSIS pkg. that I need to run a stored procedure to return a pretty large results set. I'm assuming this will need to be...

Re1 (12/23/2015)

---

Hi guys,

I am doing one POC. I am trying to generate and execute a dynamic sql. In that dynamic sql i have to many replace functions.At the time of...

lmarkum (12/22/2015)

---

I have come across several tables recently where the clustered PK on Column (X), for example, is also been duplicated as a nonclustered index. When I look at...

Sean Lange (12/22/2015)

---

Lynn Pettis (12/22/2015)

---

Silver Spoon really doesn't seem to care about learning anything. Just the answer, that's all he is interested in.

I really hope there is someone else...

Alvin Ramard (12/22/2015)

---

Phil Parkin (12/22/2015)

---

Plugging...

Just an idea which may help your troubleshooting, yes.

Plugging in my guitar and...

Snargables (12/22/2015)

---

We have a few instances in the past few days where sql has become unresponsive. The cpu gets to 55% then we cant access it. In the logs right...

RonKyle (12/19/2015)

---

I do use stored procedures for the final insert in the sense that there is a...

Have a look here.

This gives you an idea of data type mappings between SQL Server and SSIS.

The implication of the link is that you should attempt to get your input...

It seems that everyone in this thread spends their spare time shooting things :exclamationmark::-D