loveindia Posted March 18, 2014 Report Posted March 18, 2014 Hi Guys, Here is an article on T-SQL Merge statement how to capture the SDC's. (Slowly Changing Dimensions). I have explained What is merge and what it does in basic examples.. Please read and follow accordingly.. http://sqlsaga.com/sql-server/how-to-capture-changes-between-source-and-destination-using-merge-statement/ Please make changes to accommodate in your code accordingly. We can also achieve the same using SSIS which I will post in a later post. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles. Please like us on Facebook and let us help you. If you have any questions or if you need a particular article, please leave a comment in our facebook fan page or leave a comment in our comments section or use the contact-us page from the website. Good Luck Learning.. :)
loveindia Posted March 18, 2014 Author Report Posted March 18, 2014 bump for sql 8+ experienced persons...
pandugadu999 Posted March 18, 2014 Report Posted March 18, 2014 i have a question on ssrs tablix report. naa report ila undi Year/Month FisrtName LatName DOB Booking# POC# 2010,Jan XXX VVVVV XXX XX XXXX 2010,Feb XXX VVVVV XXX XX XXXX 2010,Mar XXX VVVVV XXX XX XXXX 2010,Apr XXX VVVVV XXX XX XXXX 2010,Jun XXX VVVVV XXX XX XXXX 2011,Feb XXX VVVVV XXX XX XXXX 2011,Mar XXX VVVVV XXX XX XXXX 2011,Apr XXX VVVVV XXX XX XXXX 2011,Jun XXX VVVVV XXX XX XXXX 2012,Aug XXX VVVVV XXX XX XXXX 2012,Sep XXX VVVVV XXX XX XXXX 2012,Oct XXX VVVVV XXX XX XXXX 2012,Nov XXX VVVVV XXX XX XXXX naaku kavalsindi entante each year group tarvatha oka blank row ravali,,, like this..... Year/Month FisrtName LatName DOB Booking# POC# 2010,Jan XXX VVVVV XXX XX XXXX 2010,Feb XXX VVVVV XXX XX XXXX 2010,Mar XXX VVVVV XXX XX XXXX 2010,Apr XXX VVVVV XXX XX XXXX 2010,Jun XXX VVVVV XXX XX XXXX 2011,Feb XXX VVVVV XXX XX XXXX 2011,Mar XXX VVVVV XXX XX XXXX 2011,Apr XXX VVVVV XXX XX XXXX 2011,Jun XXX VVVVV XXX XX XXXX 2012,Aug XXX VVVVV XXX XX XXXX 2012,Sep XXX VVVVV XXX XX XXXX 2012,Oct XXX VVVVV XXX XX XXXX 2012,Nov XXX VVVVV XXX XX XXXX how to get this,,,,any ideas?
loveindia Posted March 18, 2014 Author Report Posted March 18, 2014 loveindia check mail Got it myaaan...
loveindia Posted March 18, 2014 Author Report Posted March 18, 2014 i have a question on ssrs tablix report. naa report ila undi Year/Month FisrtName LatName DOB Booking# POC# 2010,Jan XXX VVVVV XXX XX XXXX 2010,Feb XXX VVVVV XXX XX XXXX 2010,Mar XXX VVVVV XXX XX XXXX 2010,Apr XXX VVVVV XXX XX XXXX 2010,Jun XXX VVVVV XXX XX XXXX 2011,Feb XXX VVVVV XXX XX XXXX 2011,Mar XXX VVVVV XXX XX XXXX 2011,Apr XXX VVVVV XXX XX XXXX 2011,Jun XXX VVVVV XXX XX XXXX 2012,Aug XXX VVVVV XXX XX XXXX 2012,Sep XXX VVVVV XXX XX XXXX 2012,Oct XXX VVVVV XXX XX XXXX 2012,Nov XXX VVVVV XXX XX XXXX naaku kavalsindi entante each year group tarvatha oka blank row ravali,,, like this..... Year/Month FisrtName LatName DOB Booking# POC# 2010,Jan XXX VVVVV XXX XX XXXX 2010,Feb XXX VVVVV XXX XX XXXX 2010,Mar XXX VVVVV XXX XX XXXX 2010,Apr XXX VVVVV XXX XX XXXX 2010,Jun XXX VVVVV XXX XX XXXX 2011,Feb XXX VVVVV XXX XX XXXX 2011,Mar XXX VVVVV XXX XX XXXX 2011,Apr XXX VVVVV XXX XX XXXX 2011,Jun XXX VVVVV XXX XX XXXX 2012,Aug XXX VVVVV XXX XX XXXX 2012,Sep XXX VVVVV XXX XX XXXX 2012,Oct XXX VVVVV XXX XX XXXX 2012,Nov XXX VVVVV XXX XX XXXX how to get this,,,,any ideas? Can you show me a screen shot of what you need here.. I did one long before.. you just add a new group row and remove the group name to display a blank row. What is ur sql server version???
Osama Bin Gandhi Posted March 18, 2014 Report Posted March 18, 2014 naadi ssrs kaadu but google cheste idi dorkindi http://social.msdn.microsoft.com/Forums/sqlserver/en-US/9a5c9c7a-8ea7-4bdc-9515-fca64976c422/how-to-insert-a-blank-row-after-each-group-in-a-matrix-report?forum=sqlreportingservices already choosi unte ignore i have a question on ssrs tablix report. naa report ila undi Year/Month FisrtName LatName DOB Booking# POC# 2010,Jan XXX VVVVV XXX XX XXXX 2010,Feb XXX VVVVV XXX XX XXXX 2010,Mar XXX VVVVV XXX XX XXXX 2010,Apr XXX VVVVV XXX XX XXXX 2010,Jun XXX VVVVV XXX XX XXXX 2011,Feb XXX VVVVV XXX XX XXXX 2011,Mar XXX VVVVV XXX XX XXXX 2011,Apr XXX VVVVV XXX XX XXXX 2011,Jun XXX VVVVV XXX XX XXXX 2012,Aug XXX VVVVV XXX XX XXXX 2012,Sep XXX VVVVV XXX XX XXXX 2012,Oct XXX VVVVV XXX XX XXXX 2012,Nov XXX VVVVV XXX XX XXXX naaku kavalsindi entante each year group tarvatha oka blank row ravali,,, like this..... Year/Month FisrtName LatName DOB Booking# POC# 2010,Jan XXX VVVVV XXX XX XXXX 2010,Feb XXX VVVVV XXX XX XXXX 2010,Mar XXX VVVVV XXX XX XXXX 2010,Apr XXX VVVVV XXX XX XXXX 2010,Jun XXX VVVVV XXX XX XXXX 2011,Feb XXX VVVVV XXX XX XXXX 2011,Mar XXX VVVVV XXX XX XXXX 2011,Apr XXX VVVVV XXX XX XXXX 2011,Jun XXX VVVVV XXX XX XXXX 2012,Aug XXX VVVVV XXX XX XXXX 2012,Sep XXX VVVVV XXX XX XXXX 2012,Oct XXX VVVVV XXX XX XXXX 2012,Nov XXX VVVVV XXX XX XXXX how to get this,,,,any ideas?
pandugadu999 Posted March 18, 2014 Report Posted March 18, 2014 Can you show me a screen shot of what you need here.. I did one long before.. you just add a new group row and remove the group name to display a blank row. What is ur sql server version??? 2008 r2 ba...........aa groupings ento chala confusing a unnayi ba...
pandugadu999 Posted March 18, 2014 Report Posted March 18, 2014 naadi ssrs kaadu but google cheste idi dorkindi http://social.msdn.microsoft.com/Forums/sqlserver/en-US/9a5c9c7a-8ea7-4bdc-9515-fca64976c422/how-to-insert-a-blank-row-after-each-group-in-a-matrix-report?forum=sqlreportingservices already choosi unte ignore thanks baa
loveindia Posted March 18, 2014 Author Report Posted March 18, 2014 thanks baa do you have grid around your data items..??? antey report plain white lo chupistunnav aa??? if I so I was able to do it in SSRS... I can show you after I get home...
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts