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...

If you're looking only for those rows where the 'latest' status is 'bad', something like this should work:

if object_id('tempdb..#GoodBad', 'U') is not null

drop table #GoodBad;

create table #GoodBad

...

Maybe there's a better way, but this seems to work.

declare @StartTime nvarchar(10) = '12:10';

declare @EndTime nvarchar(10) = '12:30';

declare @Diff time(1) = cast(@EndTime as datetime) - cast(@StartTime as datetime);

select StartTime...