rash3554 (6/10/2016)

---

Hi there,

I have a table with home address with missing spaces between House number and streetname. How can I insert spaces?

Create table dbo.streetaddr(Address varchar(200));

INSERT INTO dbo.streetaddr...

kevin 26531 (6/10/2016)

---

Chris/Thomas

Thanks for the replies.

Chris - Understand your solution however the row id in it comes up in the 30K range (even if I select from 0 to...

As Thomas said. Something like this:

select *

from (

SELECT

tf.formid,

??.formdate,

??.answer,

'field-' + cast(tff.filtertype as varchar(10)) + '-' + cast(tff.id as varchar(10)) as columnname

FROM (

SELECT *,

rowid = ROW_NUMBER() OVER (ORDER...

IA123 (6/8/2016)

---

That took 46 seconds.

I tried select * from @basedata, but it didn't work. It says 'must declare the table variable @basedata'. I'm new to sql so apologies if this...

Sean Lange (6/7/2016)

---

ChrisM@Work (6/7/2016)

---

Haven't you...

Eric M Russell (6/7/2016)

---

Jeff Moden (6/7/2016)

---

I...

Haven't you got one of...

I don't know this function, but I know REVERSE(), CHARINDEX() and PATINDEX(), and so should you....

SELECT NCHAR(8217); -- Alt 0146

-- Replace right closing quote with single quote

DECLARE @EmailAddress NVARCHAR(100) = 'FredO' + NCHAR(8217) + 'Shea@fred.com';

SELECT @EmailAddress;

SELECT REPLACE(@EmailAddress,NCHAR(8217),'''');

-- Replace single quote with right closing...

Chris_M above has pointed out above that some of your rows appear to be truncated...

Plamen Ratchev explains predicate evaluation order issues in this article[/url].

Here's the original question[/url].

Look through your data to find a common rule which will identify the split location. It might be the nth tab, it might be immediately following "200SC-offer-details-May16", it might be...

Each of the rows you have to split have this string in common?

Thanks but that doesn't answer the question. You can determine the split point by eye because you know what to look for. What I'm trying to figure out is a...