I hate to rain on anyone's parade, but what I'm hearing is that there's no direct connection between the two servers, and there's an expectation of zero down-time. ...

Perhaps Zypsy just needs a little of what I'll call "solution motivation". It seems fairly simple that given the existing data structure, the proposed analysis involving what the...

Kagool,

Thanks for clarifying. You just need to state the entire problem in your initial post, as the design of many solutions is critically dependent on the initial problem...

Sounds like the OP failed to initially disclose criteria that are critical to rendering a proper query. He now introduces the concept of the user replying to a...

You might want to be a bit more specific about exactly what you want to convert to Access, but that query could be used un-changed as a pass-through query in...

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...