When you performed the migration of the database to 2014, what steps did you take?

I'm not sure what a 'shared location filer'...

Was your question about whether to use SSIS or not? Or was it about which technique to use within SSIS?

You could try the import wizard.

Oh yes it helps, very nice. Thank you very much!

Junglee_George (6/4/2015)

---

Thank you all for the replies.

Actually my need is to rearrange the JOINs and ON conditions in a meaningful readable way.

There are so many JOINs written in a very...

What do you mean by this? Formatting, or logic, or something else?

That's too long! Post here straight after day 1 in future 🙂

So sorry. I missed this.

OK. Here is a hack for you.

with addresses

as (select address = 'Elland **REQUIRES BOOKING IN***'

...

Pack_Star (6/3/2015)

---

Hi All,

I have an Address column that I need to Substring. I want to remove part of the string after either, or both of the following characters i.e ','...

Ozzmodiar (6/2/2015)

---

I see you have a perfectly valid solution, so I won't bother typing it all up unless you're interested.

There is a very elegant solution to this problem using the...

That is unlucky.

P Jones (6/2/2015)

---

We do lots of csv import and have found that | isn't a good delimiter character as it can easily be mistyped into data when hitting the shift...

Alan.B (6/1/2015)

---

You don't.

When you create a primary key you have the ability...