Just because it is a domain admin does not mean it is a local admin or SA on your database server. Since the service starts, it is unlikely that...

I have put lots of CTE's together is a single statement and never had any issues.

The NOCOUNT issue could be the problem.

And since I just had a fresh coffee...

Now that...

Sorry - it is the MERGE component (not the MERGE JOIN).

Using a third party component or a third party command line utility will still make you dependant on installing some third party software.

I also agree that creating a button-click schema...

In your report server database look in the ExecutionLog table.

You already pretty much wrote the update

update table(1)

set column (1) = column (2) only when column (2) is not null

in T-SQL is

UPDATE table(1)

SET column(1) = column(2) WHERE column(2) IS...

Then Matt's solution looks pretty good.

Object Explorer displays a treeview that you can navigate any servers you have an open connection to. Registered servers is where you register a server so you do not...

That's the problem.

The registered servers are not displayed in the "Object Explorer" window.

There is a "Registered Servers" window that you need to display Ctrl+Alg+G or select it from the view...

Are you sure you are looking at the "Registered Servers" window and not the "Object Explorer" window?

...and yes I know that was a rather inefficient recusive CTE.

Ok, just to see if I could get this with a quick recursive CTE:

[font="Courier New"]; WITH DatePeriods (DateValue, StartOrEnd)

AS

(

SELECT DATEADD(DAY,-DATEPART(Day,GETDATE())+1,CONVERT(DATETIME,CONVERT(VARCHAR,GETDATE(),101))), 1

UNION ALL

SELECT DATEADD(DAY,-DATEPART(Day,GETDATE())+15,CONVERT(DATETIME,CONVERT(VARCHAR,GETDATE(),101))), 2

UNION ALL

SELECT DATEADD(Month,-1,DateValue), StartOrEnd FROM DatePeriods WHERE...

Oh - and Matt - that's pretty slick.

Hats off to you.

So I assume you want some way to "unscramble" the phone numbers?

If that is the case, you probably want to look into encryption.

Just to add to this, it is fairly easy to do. MS designed the platform with the intention of having developers create custom components.