June 18, 2014 at 6:38 am
gurbanov.1984 (6/18/2014)
thanks for your precious timebut why us # RG_SalesOut_Report (test pattern) that it give us?
baseline data about 12 million lines and how you want to write such a request with a list of data, the database is increased 1.5 million / month.?
if you are not understood correctly verify pls
Please post readily consumable sample data. If you're not sure how to do this, please read this article: http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy