If you absolutely are identifying a row here base on the values of emp1, emp2 and emp3, then you can create a calculated field that persists in the table. This...

Another option you can try is the fixed width delimiter in SSIS. THere is no guarantee here though as it totally depends on the way your data is laid out.

You are in a tight spot here. You have text files with commas as the field separators and some of those fields are strings with commas within them. You cant...

RonKyle (9/28/2016)

---

I have trouble imaging this, and certainly...

So you would not use SSIS to pull into Access? I think the user wants...

If you are able to access the folder and file then you may want to study creating a proxy account for the SQL SERVER Agent account. This allows the agent...

I am not totally certain but you may want to install the appropriate version of the provider (32 bit, 64 bit) on both the machine where Office is installed and...

If DAX in any way resembles MDX then I would say yes it is hard. Like any language, if you dont use it you begin to lose this. This holds...

In a Where clause you may have a situation as

WHERE (a>20) OR

...

Just out of curiosity, what was your language setting?

If you want to preserve a static definition of territory over time, I am guessing this is by your definition and not the clients. I think of having a extra...

Kazmerelda (9/26/2016)

---

Sorry foe the delay, I was out last Monday on holiday so couldn't test it properly.

So I went in to test this morning all hopeful....and sadly I am getting...

The only issue I see here is with Scott and My results is the emp_id = 45678. The employee has the same email for both fields, and that email is...

What I did first is create a list of invalid emails

With myCTE as

(

Select emp_id, emailType, email

From #temp1

Unpivot (email for emailType in ([email1],[email2])) as upvt

)

Select email, count(email) as numTotal

into...

Good article that highlights rounding as really a formatting function. In the movement and derivation of data, I like to save rounding towards the end. That is, when you actually...