Oops! You can tell...

drew.allen (8/19/2016)

---

I like the following method, particularly when you are comparing multiple columns.

UPDATE #test

SET Flag = @Flag

CROSS APPLY (

SELECT...

kevin_nikolai (8/19/2016)

---

I am running a data-warehouse which collects data from CRM.

Issue is that when supervisors & managers disable or delete Sites in CRM, I still get them displayed in...

GaMusicMan (8/18/2016)

---

I have a script file that looks like this: Generated by Devart dbForge Data Compare for PostgreSQL

-- Script was generated by Devart dbForge Data Compare for PostgreSQL, Version...

shani19831 (8/18/2016)

---

Thank you for the reply.

Yes the result is not really the same but i can work from excel to change it. something I would love to avoid..

I cant get...

They are excellent, but at least a step away from greatness, IMO, because trying to script them out (along with...

Well done on sorting that out.

Note that the original script you provided contains several errors. Here is one that works, using a temp table and with some guesswork applied to...

Better brush off those...

Steven.Grzybowski (8/18/2016)

---

How do you deal with differences between developing on a workstation and preparing to deploy to a server? For example, In my environment, I have network drives that are...

shani19831 (8/18/2016)

---

Good Afternoon All

I have a project of data migration from old system to new system. The new system needs a flat pipe file in a specific format.

On my Ben...

Eric M Russell (8/17/2016)

---

SSIS does a good job of manipulating rows and columns within buffers as it moves through the pipeline, but sometimes loading the data into target table as...

If you tell us more about the structure of your SSIS package: what components you are using etc. (even a few screen shots would probably do it), we might be...

Virtual Reality (8/16/2016)

---

Hello,

I have one table called A. A has dependencies on B. B has dependencies on c. C has dependencies on D.

A has dependencies on B,C,D.

How could I copy...

sqlfriends (8/16/2016)

---

I am trying to download and install SQL 2016 Data tools on a development server which we have already installed SQL server 2016 database engine.

The SSDT download page is...

sqld-_-ba (8/16/2016)

---

I read somewhere SSC has 600K visitors. Assuming 10% see the salary survey, and 1% respond, that is 6000 responses. I'm also trying to advertise this on stackexchange, and...