Mine was the last posted example, and it uses a CTE, or Common Table Expression, as opposed to a temporary table. The two table variables are only there...

I agree with using PIVOT, and as the two tables are identical save the Name field and the number of records, they can be UNION ALL'ed together, then pivoted. ...

Ok, if you want to copy and paste, then why is there a need to do anything using T-SQL? Assuming the desire is something along the lines...

Yes, I'm referring to the SQL Server Migration Assistant. I never bothered to migrate anything other than Tables and Queries, and because of the problems on the query...

I'd choose the latter, as the net result is that all you then have to do is add up the costs on a per order basis. Just remember...

If I understand you correctly, you appear to be saying that a change in the cost is reflected by a new record in the error cost table? Can...

Two critical questions:

1.) Exactly what do you mean when you say "print"? That can mean anything from getting text output for copy and paste elsewhere, to actually printing...

While you have a solution, you may not be aware, but to accurately display percentage values, you need to ensure that the raw number you compute is between 0 and...

Ok, I'm completely confused... The last time I checked, 8 hours and 15 minutes is a total of 495 minutes, not 75. If the user...

dli,

You're not exactly making this 100% clear, but let me take a stab at it anyway. One of two scenarios comes to mind. Either the record...

The "big one" from a performance perspective, that I see, is the query embedded within the SET statement, which is being executed for EVERY record the UPDATE statement touches. ...

I have to agree with SQLBill, as there are many companies that sell this kind of application and then "force" you into using their contracted services to do anything remotely...

While the OP's post indicates a result that includes the hour, I'm pretty sure the words he used preceding the result indicated he wants to eliminate the time part entirely,...

Take a look at the size of all the indexes in that database. It's quite easy for indexes to occupy far more space than the data itself. ...

I have to agree with the general sentiment here, that the managers, starting with Evelyn, completely failed to manage Eric, and avoided the one thing that could have made a...