In both of them you're mixing character & numeric data joined by +.

You need to CAST/CONVERT it all to character.

What data type are [BU], [SUBSIDUARY] & [OBJECT]?

CASE

WHEN [ORDER_TYPE] =...

You can make it longer by concatenating strings:

declare @nblah nvarchar(max)

set @nblah = convert(nvarchar(max), '')

set @nblah = cast(replicate('0', 8000) as nvarchar(max)) + cast(replicate('0', 1000) as nvarchar(max))

select len(@nblah), datalength(@nblah)

You need to add FoneID & FloorID to MoozeTroofe.

Allow NULL values, & only populate them as required - i.e. when there is a join.

Join to Fone & Floor using LEFT...

Why do you think there would be a massive impact?

You could check out the data & see if it's possible to get duplicate rows.

Someone might have added it because its needed, or maybe 'just in case'...

By the way, if you change the query to left outer join on E, you will get NULLs in the E columns where there is no matching data.

You can handle...

DISTINCT removes duplicate rows from the result set. Only remove it if there ARE no duplicate rows!:-)

Here's how to make the LEFT OUTER JOIN on E.

You should not put join conditions in the where clause - it's very old fashioned, & it's easier to read if...

Jason-299789 (9/28/2012)

---

laurie-789651 (9/28/2012)

---

If you do the CAST on the first value to be processed, that should fix it:

-------------------------------------------------------------------------

DECLARE @A Int, @b-2 Int, @C Int;

SELECT @A = 9,

@b-2 = 3,

@C =...

If you do the CAST on the first value to be processed, that should fix it:

-------------------------------------------------------------------------

DECLARE @A Int, @b-2 Int, @C Int;

SELECT @A = 9,

@b-2 = 3,

@C = 2;

SELECT Cast(SUM(@A*@B)...

Grant Fritchey (9/28/2012)

---

anthony.green (9/28/2012)

---

I missed the London one's...

Can you tell us the exact specification of the 3 fields/columns? - e.g. A is Decimal(30,5) etc...

Give us some examples too.... Thanx

Error trapping is for errors. It may appear similar at a code level but under the hood it uses many more recources to process (according to posts on SSC).

It's...

Koen Verbeeck (9/28/2012)

---

If you do one in Brussels...

ChrisM@Work (9/28/2012)

---

Koen Verbeeck (9/28/2012)

---

If you do one in...