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

As far as I know, you cannot use Python in a Script Component, so I think you are limited by that.

nshockley (5/29/2015)

---

On SQL Server 2008 R2 some SSIS packages created and regularly scheduled to run have worked perfectly for over a year.

These packages have been upgraded on our...

You could do the whole thing (parsing, splitting, outputting one row with multiple columns per @ group) using an asynchronous Script Component, but it would take a fair chunk of...