Yes, but it would be far better to have your page call a stored procedure which performs both updates...

nick.mcdermaid (2/6/2013)

---

I'm interested in getting to the bottom of it. In fact it's far more interesting than what I'm meant to be doing which is why I'm having difficulty spending...

It depends.

Perhaps if you supplied some tables definitions and sample data that exhibits the problem, it would be easier to help.

Also, it would be helpful to document how you configured your...

Hi Eidjaz,

I have not done...

Jury is still out on that...:hehe:

DECLARE @t table(Col1 char(1),Col2 char(1),Col3 char(1));

INSERT @t(Col1,Col2,Col3)

VALUES('a','b','c');

SELECT Col

FROM @t as T

CROSS APPLY (VALUES(Col1),(Col2),(Col3)) AS CA(Col);

Welsh Corgi (1/21/2013)

---

Thanks. Not sure why I'm getting an error on the substring function.

Msg 8116, Level 16, State 1, Line 1

Argument data type numeric is invalid for argument 1 of...

It seems posting from a tablet makes me sloppy...it should have read like this:

Welsh Corgi (1/19/2013)

---

I'm haveing trouble with a simple CAST to VARCHAR Statement.

SELECT

CASE WHEN CAST(LEFT(Customer.STARTDATE, 2 AS...

Welsh Corgi (1/19/2013)

---

I'm haveing trouble with a simple CAST to VARCHAR Statement.

SELECT

CASE WHEN CAST(LEFT(Customer.STARTDATE, 2 AS VARCHAR(2)))

...

You should be able to just wrap the existing method in LEFT(....,LEN(name)) to get the correct answer...

but only if the original data was no more than half as long as...

you might want to take a look at the proc dm_fts_parser

It might just provide the word analysis you are looking for...

Link : http://msdn.microsoft.com/en-us/library/cc280463(v=sql.100).aspx

I suspect that somewhere along the line, a unicode string has been badly converted, first...

Just wondering what is the datalength() of one of those names, such as AHSGuest ?

two single quotes are used inside the string, so 'ab''c' equals ab'c

you want '''ABC'''