ChrisM@Work (5/21/2014)

---

UPDATE h SET

Phone1 = CASE WHEN d1.Phone IS NOT NULL THEN NULL ELSE Phone1 END,

Phone2 = CASE WHEN d2.Phone IS NOT NULL THEN NULL ELSE Phone2 END,

Phone3 =...

Are the folders setup as shares?

Was not sure if it would help as it was not exactly what you wanted but thought it might spark an idea.

Wanted to count the connections yesterday and came up with this:SELECT distinct

Cses.host_name ...

Create an intermediate table for the data from Excel then use UNPIVOT.

Thanks!

Only one value is expected.

I was reviewing a developers code that had a cursor and thought my way would be better.

Luis C., when I looked at the code I thought I was missing something about Avg, now I know.

mickyT (5/9/2014)

---

Hi

I guessing that the type is the main part of this, so something like

CASE

WHEN Type = 'Type 1' THEN

...

Notice that they have not logged in since 2011

My first thought was you need to check the max memory setting, make sure it is NOT the default. However the limited SAN space may be the problem.

1) what have you tried?

2) do you just have the five columns?

Thanks Lois. I said it was not tested. 😀

That is two wrong in about ten minutes. Time to go home.

I believe you are looking for CHARINDEX with [0-9][0-9][0-9].

Something like:

SUBSTRING(yourvalue, CHARINDEX('[0-9][0-9][0-9]',yourvalue), lengthyourvalue)

Note this is not tested.

What do you get if you run?

SELECT

SUM(ISNULL([Share_Invest],0)) [Investment],

SUM(ISNULL([Profit_Share],0)) [Profit Amount],

[Variance] = SUM(ISNULL([Share_Invest]-[Profit_Share],0))

FROM Finance

Thanks. Since the MS default is to append I did not know, even though I always do the full backups into separate files.

We have grown and I was wondering...