Thanks very much, that was an excellent read.

Being a one man band now, i find i avoid the SQL Server tools.

I use power query instead of ssis and make tabular...

Thanks very much.

I'm doing something like that now, except with ROW_NUMBER() and partitioning by the whole field list to find row numbers bigger than 1.

But I was hoping to be...

thanks

the backups also had holes in them...the most recent set that is usable was from ten days ago.

I am running reports from the restored data against last month's control totals...

Thanks a lot, that's kind of what I did to get here, iow, I did a row_number over partition by my assertion of uniqueness. There were about eight hundred failures...

Thank you both.

dbcc checkdb ran on all dbs without error, but pharmacy queries still did not agree with controls.

I felt I had no choice but to redo the ETL and...

My most desired unimplemented wish list item is the 'You Know What I Mean' button 😛

Thank you both...I'll go with the nullif option

please forgive my senior moment

I appreciate the help

Yes, I see they seem to offer the factory.

From what I understand so far, MySQL is the relational/dimensional store for Mondrian, and there are a bunch of add ons...

Thanks very much.

nevermind...i think it was just a bunch of junk for print ranges.

sorry

Yes, it was a dopey way to conceptualize the implementation and the product needs to be a web service.

Thank you both very much for the advice.

Drew

Lots of good ideas, thanks very much for your advice.

Thanks Koen...you rattled my cage enough to get to the bottom of it.

I found out that you need a little bit more English on the ball to get IIS straight...

Thanks for the heads up Jeff...actually, I got straightened out by Lynn's comment in the first article's comment section, (and yours too) which brought be back to here

http://www.sqlservercentral.com/articles/Tally+Table/72993/

I...

Yes, it will be a gnarly mess...I have a little time to mull though, but it is in preparation for a conversion.

The business problem I am trying to solve is...