Jeff,

Thanks for the test rig.   Yes, the triangular join isn't pretty.   I chose to take a look at modifying it to have just a single character visitor so...

As Luis has pointed out, Oracle and SQL Server are rather different in how their cursors operate.   In the "stateless" world of Dot Net, a cursor on SQL Server simply...

A couple of thoughts:
1.) Data Type for the package variable @[User::ValidationFlag] - Boolean or Int32 ?
         You might need to make that Boolean for best results, but just...

Okay, now that I've had some time to mess with it, here's a working solution:
USE LOCAL_DB;
GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.DailyVisits', N'U') IS NOT NULL
    BEGIN

And for those willing to take a further look, here's a better formatted copy of the query:
USE LOCAL_DB;
GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.DailyVisits', N'U') IS NOT...

I don't know if the actual solution is even correct.   If the comparison is from one day to the next, then it appears that the "Removed" column is not correct...

Then why pivot in the first place?   As to eliminating NULL values, any form of aggregation can do that, so the question is what data type does the NULL value...

Just for gits and shiggles, I figured I'd try this on for size, and try another option based on Jeff Moden's DelimitedSplit8K function.

Here's the function with the delimiter...

My previous post needed a few edits to the query to get the correct results.  FYI, in case you saw it in a previous version.