titsiros (12/30/2015)

---

Hi Phil, thanks for the -1 tip, that would work also..Do you know of any tool that would do this instead of scripting this manually? I looked into Redgate...

If a CASE statement is returning an item from a list...

dndaughtery (12/30/2015)

---

I used a select...into to create a staging table. Its been fine but lastnight I got a truncation error. I was under the "Assumption" that sql server looked at...

Certainly did. And invented a new noun, the "scree-shot" 😛

Eric M Russell (12/28/2015)

---

I'm assuming the scenario is that you have two clients in separate SQL Server instances, each having overlapping sequential integer identifiers, and so you need to assign...

drew.allen (12/29/2015)

---

Your client may be limiting the number of characters returned. It may limit either the total returned or the amount returned per column. For instance, SSMS limits...

Eirikur Eiriksson (12/29/2015)

---

Phil Parkin (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

Phil Parkin (12/29/2015)

---

Grant Fritchey (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

I really appreciate the effort of those who write the articles posted on this site but sometimes the...

Eirikur Eiriksson (12/29/2015)

---

Phil Parkin (12/29/2015)

---

Grant Fritchey (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

I really appreciate the effort of those who write the articles posted on this site but sometimes the quality seriously suffers from...

Grant Fritchey (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

I really appreciate the effort of those who write the articles posted on this site but sometimes the quality seriously suffers from the absence of technical...

Have you also considered using a script task? It might be the most elegant solution in this case.

Ok thanks. Have you considered creating an appropriately indexed 'working' table to hold the results?

I'd suggest including a date created column.

Then your package logic becomes

1. Should I recreate results? (Based...

Yes, as far as I know. SSIS packages are executed by dtexec.exe, which is separate from the other...

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?