Just wondering if the following is the source of the grief:

-OutputSqlErrors $false

I'm not sure that ROW_NUMBER() is necessary. I looked at...

Not quite: Visio will only help you draw pictures. Designing tables is a separate task...

Hugo Kornelis (3/2/2016)

---

If you want a tool to draw the pretty pictures for your data model, MS Visio gets the job done well enough.

There are also tolls that do way...

If that works, it will only be for reports stored within SQL Server. Any report rendered based on the .RPT file being present solely on the file system...

I have never seen a modelling tool, but then, I can't come up with a reason to want to, either. Too many people don't realize that it's not...

I'm not sure a tool makes the database design process any easier. A tool can help you actually create the tables, but precious little else. Just...

jackie.3981 (2/29/2016)

---

first i don't know what is ETL and am looking in the web what it's right now. about time, it will run about 2 o 3 am or maybe...

ETL maybe if it were a one-time thing, or a scheduled thing, but wanting something that's like replication but can follow all...

You can only pivot on one field. What you may need is a "crosstab". The code you presented would function:

SET LANGUAGE Turkish;

SELECT *

FROM (

SELECT ISNULL(st.AMOUNT, 0) AS...

I think the bigger question is, what's driving your requirement. It sounds like you have network traffic concerns, but where replication is concerned, that should be the least...

I'm not aware of any way to do that. The existing reports aren't going to suddenly figure out what you want... they'll just fail because the data source...

Read this article, and it may help illuminate things:

http://webcache.googleusercontent.com/search?q=cache:lmxFghxfQ4MJ:blogs.msdn.com/b/florinlazar/archive/2005/09/29/475546.aspx+&cd=10&hl=en&ct=clnk&gl=uk

It is rather old, but it does explain things from a .NET 2.0 point of view, as at the time it was...

Have you run sp_WhoIsActive? Not sure if that will help, but the only other thing that I can think of would be running SQL Profiler.

To be honest, I don't think anyone is going to have any idea what you are trying to accomplish. Calculating a percentile value is something where you need...