Why are you using the GROUP BY clause when you have no aggregates, out of curiousity? I'd try removing that first.

Next, if that doesn't take care of it, try this...

Nice job, Jeff. Did you notice any "lossy" numbers at all, and if not, did you try fun things like putting 1/3 into the varbinary for testing? The main reason...

By the way, I'm assuming this is an app you are having to deal with, so could you provide us with an actual value that the app displays, as well...

I know the basics of how it's stored, but I don't remember the specifics, and I'm pretty sure that for every rule there were exceptions. I'd advise a search for...

Of course, if you replace "Business Intelligence" with "Analytics", it's far more likely to be self-descriptive.

Since you are keeping a copy for everyday, I'm assuming the "XXXX" in your backup file name is MMDD, or something like that. If so, just determine which day(s) you...

The problem is that it's not storing the string representation of @f in @v. It's actually converting the float directly into @v. If you convert @f...

I'm with Peter, and I'd like to see the "unsimplified" table structure in the samples. It would also help if you'd give us an example of what might change that...

You didn't mention that you wanted to use DISTINCT. Without DISTINCT, my solution works fine. For DISTINCT, you need to return the sorting column, so use longshanks solution, which is...

I realize that it was mentioned upthread, but it is absolutely vital that you have the necessary constraints, John. Perhaps you could post a dump of the CREATE TABLE script.

We...

Oops, you're right. He definitely needs to lose that "e." from rownumber in the derived table.

Unless I'm missing something, his original table was about the same size, as he had three columns at 4096 each. While I realize that you questioned his need for that...

I thought that might be it. Try this as a quick fix and see if it works, then it can be expanded upon.

SELECT

 d.*

FROM

 (

 SELECT PartnerLeadTypeID, PartnerID, LeadTypeID, isActive, AllowedStates, RestrictedStates, CreditHistory,...

SG, can you post exactly what you are running when you get that message, as well as a script dump of the tables in question? Either there is a typo...