Friday, December 11, 2009

Fun with Recursive SQL (Part 1)


This blog post is derived from an article that I wrote as an article for Teradata Magazine about fun uses for recursive SQL.

Show of hands: how many of you have used recursive SQL in the past six months? For something useful?  Using ANSI syntax rather than Oracle's CONNECT BY?  If you said "yes" to all three, then congratulations!  You've won a prize: 15 minutes of your day back.  You can jump down to the bottom of this post and just review my fun example.  This first part is just an introduction to recursive SQL.

Introduction to Recursive SQL
First let's just review the definition for "recursion."  Handy-dandy dictionary here.... recourse... rectify.... recursion:
See: recursion
Not very helpful.  How about this instead.  A recursion is a method of solving problems in which the algorithm or function applies itself in the execution of the solution.  For instance, if I were to define a recursive algorithm for summarizing a list of numbers, I could say something like "the sum of a list is determined by adding the first number in the list to the sum of all the remaining numbers in the list; if the list is empty, then the sum is zero."  You notice how the definition of "sum of a list" includes the use of the "sum" operation, as in "sum of all the remaining numbers."  You'll also note that there's an explicit terminal condition to define what happens when you have nothing in the list.

So, recursive SQL works the same way.  A recursive SQL statement is one in which the determination of the result set requires the execution of SQL on the result set itself.  In recursive SQL, there has to be a seed statement, as well as the recursive call, and a termination condition.

WITH RECURSIVE [temp table] [column list] AS
(
  [seed statement]
  UNION ALL
  [recursive statement]
)

A Simple Example
For the sake of comfort, a simple example might involve an employee hierarchy table where each row had the employee ID and associated manager ID.  A standard query could retrieve a list of direct reports for a given employee ID:  SELECT * FROM employee WHERE mgr_id = 123.  A recursive query, however, could return the list of all employees anywhere under the hierarchy below that same manager.  An example that might be:
WITH RECURSIVE emp_hier (emp_id, mgr_id, level) AS
(
SELECT a.emp_id, a.mgr_id, 0 
FROM   employee a
WHERE  a.emp_id = 123
UNION ALL
SELECT b.emp_id, b.mgr_id, c.level+1 
FROM   employee b,
       emp_hier c
WHERE  b.mgr_id = c.emp_id
)
SELECT e.emp_title, e.emp_id, e.mgr_id, h.level
FROM   employee e,
       emp_hier h
WHERE  e.emp_id = h.emp_id
  AND  e.emp_id <> 123;

In this query, the is a simple select that pulls the manager record for which we want all of the descendants.  The selects all records from the employee table where the employee is managed by someone already in the emp_hier temporary table – hence the join on employee.mgr_id and emp_hier.emp_id.

On to some more exciting examples...


Example 1: String Concatenation
Ever notice that there are no string aggregation functions in SQL?  Something like a SUM() for character fields that would take two parameters: the field or expression from each row and a delimiter.  Usually, programmers end up having to write code outside of the database to do that kind of string manipulation. Recursive SQL can achieve that kind of character aggregation quite nicely if used appropriately.

Consider a list of email addresses for several members of the same family.  The table has a FAMILY_ID, PERSON_ID, SEQuence number, and EMAIL_ADDR.  The desired output is a single row that contains a comma-separated list of all the email addresses for the entire family (for a mailing list perhaps).

WITH RECURSIVE email_list (coverage_id, emails, seq) AS
(
  SELECT m.family_id, m.email_addr, m.seq
  FROM   members m
  WHERE  m.seq = 1
  UNION ALL
  SELECT e.emails ||’, ’|| m.email_addr, m.seq
  FROM   email_list e, members m
  WHERE  m.seq = e.seq + 1
    AND  m.family_id = e.family_id
)
SELECT r.family_id, r.emails
FROM   email_list r
WHERE  r.seq = (SELECT MAX(h.seq) FROM email_list h 
                WHERE h.family_id = r.family_id 
                GROUP BY h.family_id)
;
Let's walk through the SQL piece by piece.  First, the seed statement starts the result set off by picking just the first person from each family (that is, the people with a SEQ=1).  That sequence number is admittedly a bit artifical and contrived to make the recursive SQL easier to write.  If you needed to, you could generate the SEQ on the fly using a RANK() of people within each family and then leverage the RANK() as a sequence number.  Hopefully the example isn't lost because of that bit of confusion.

The recursive portion of the SQL simply takes what was seeded in through the first query (i.e. people with SEQ=1) and joins that to all the records in the EMAIL_ADDR table with a SEQ = SEQ + 1 (from result set).  The EMAILS output field is created by concatenating the email address from the seed to record with the next highest sequence number.

Then that result set is taken and the same thing is done.  And so on.  And so forth.

The query terminates when the result set contains no records.  That is, when we exhaust all the SEQ numbers in the table.

The outer query refines the results down to exactly what we're looking for by keeping the final record and throwing away all the intermediate records that were used to built up the results.

Next Time
Look ahead for additional posts on how to use recursive SQLto parse a field with comma separated values and how to split and reconcile overlapping time segments into a single, flat time line.

101 comments:

  1. This has been a really valuable post! Do you have any examples of the string concatenation where I don't have a convenient sequential reference (i.e. where you suggest that Rank() be used)?

    Each time I've tried to create this using a window function, I get an "Illegal or unsupported use of subquery/derived table inside a recursive query/view" error.

    ReplyDelete
  2. Nice & Easy Keep Doing Good Job

    ReplyDelete
  3. almost same, but with test data

    http://thesimpleprogrammer.blogspot.com/2013/02/concat-rows-as-single-column-in-teradata.html

    ReplyDelete
  4. Hi Paul, thanks for your article. Recursive SQL can be tricky to understand, so I appreciate you taking the time to explain it step-by-step to us.

    ReplyDelete
  5. Hi Paul,
    Your explanation is great which made complicated logic to simple. thanks. Keep doing good job.

    ReplyDelete
  6. Thank you very much for this article, it is so rare to see nowadays written as fervently article. I enjoyed reading it and I learned a lot of things. I will go and continue reading your blog =). Good luck for the future and another one for the quality of it.You can also check out this (http://www.sqiar.com).

    ReplyDelete
  7. Thank you for taking the time to put this together. It's very helpful in understanding SQL recursion.

    ReplyDelete
  8. This comment has been removed by the author.

    ReplyDelete
  9. Hey, two questions:
    1. in your email concatenation example: for the recursive select portion, do you think it lacks one column (right now only two columns)?
    2. As you know, the email column in the result would be a very long one? How can you make sure it won't be truncated given the very first record of "emails" is only for one email...I ran something similar on Teradata 15.00.0305...my results from recursive selections were all truncated by the seed selection.

    ReplyDelete

  10. Thanks for sharing this information and keep updating us. This is informatics and really useful to me.
    Selenium Training in Chennai | Selenium Training | Selenium Course in Chennai

    ReplyDelete
  11. Unfortunately the question of Nicholas concerning the rank() was not answered.
    I have exactly the same problem: Creating a tree with specific order by can only be done with a rank(), resulting in eg an order by field: 1, 1.1, 1.2, 1.3, 1.3.1, 1.3.2, ..., 2, 2.1, etc.

    ReplyDelete
  12. It's A Great Pleasure reading your Article, learned a lot of new things, we have to keep on updating it salesforce certification training Thanks for posting.

    ReplyDelete
  13. very nice good we share it useful benefits posted.
    Appium Training From India

    ReplyDelete
  14. Greetings! Very helpful advice within this article! It’s the little changes that produce the biggest changes. Thanks for sharing!
    Golden gate Classes

    ReplyDelete
  15. This information is impressive; I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic.
    oneplus service center chennai
    oneplus service center in chennai

    ReplyDelete
  16. You are doing a great job. I would like to appreciate your work for good accuracy
    Regards,
    best selenium training institute in chennai

    ReplyDelete
  17. Thank you for taking time to provide us some of the useful and exclusive information with us.
    Regards,
    selenium course in chennai

    ReplyDelete
  18. . To have more enhanced results and optimized benefits, you are able to take the help of experts making a call at QuickBooks Payroll Support Number Well! If you’re not in a position to customize employee payroll in

    ReplyDelete
  19. Dial our number to obtain in contact with our technical specialists available twenty-four hours each and every day at QuickBooks Customer Support Number.

    ReplyDelete
  20. QuickBooks Payroll is a credit card applicatoin which include made payroll a straightforward snap-of-fingers task. It is possible to very easily and automatically calculate the tax for your employees. It really is an absolute software that fits your organization completely. We provide Quickbooks Payroll tech support team with regards to customers who find QuickBooks Payroll difficult to use. As Quickbooks Support we utilize the responsibility of resolving all the problems that hinder the performance associated with the exuberant software.

    ReplyDelete
  21. QuickBooks Payroll Support Phone Number software may be the better option. You can certainly do WCA, PAYE, SDL along with UIF calculations. This generates annual IT3A as well as IRP5. Employees also result in the loan. How will you manage that? QuickBooks does that in ease. The application brings accumulative balance.

    ReplyDelete
  22. QuickBooks Enterprise Tech Support Gives Necessary Features In Real Time For The Enterprises. Because The Software Runs On Desktop And Laptop Devices, It Truly Is Prone To Get Errors And Technical Glitches.

    ReplyDelete
  23. QuickBook Customer Support Number genuinely believe that the show must go ahead and thus time is just not an issue for all of us because problems do not come with any pre-announcements.

    ReplyDelete
  24. We genuinely believe that the show must go ahead and thus time is just not an issue for all of QuickBooks Support Phone Number because problems do not come with any pre-announcements.

    ReplyDelete
  25. According to statics released by the Bing & Google search insights more than 50,000 people searching the web to find the Quickbooks Support Phone Number on a daily basis and more than 2,000 quarries related to Quickbooks issues and errors .

    ReplyDelete
  26. QuickBooks, a software solution that will be designed in such a manner that one may manage payroll, inventory, sales and every other need of your small business. Each QuickBooks software option would be developed based on different industries and their needs so that you can seamlessly manage all your valuable business finance at any time as well as in one go. You should not worry if you're stuck with QuickBooks issue in midnight as our technical specialists at QuickBooks Tech Support Phone Number can be acquired twenty-four hours a day to serve you with the best optimal solution right away.

    ReplyDelete
  27. QuickBooks Support Number have a team of experts which may be pro in handling most of the issues because of this incredible software. You'll need not to worry after all as you are seeking help under the guidance of supremely talented and skilled support engineers that leave no stone unturned to land you of all errors which are part and parcel of QuickBooks.

    ReplyDelete
  28. QuickBooks Tech Support Number was made to meet your every accounting needs and requirement with a fantastic ease. This software grows and your business and perfectly adapts with changing business environment.

    ReplyDelete
  29. It includes some luring features which will make this software most desirable. Regardless of most of the well-known QuickBooks Premier features you may find difficulty at some steps. Support For QuickBooks is the foremost destination to call in the period of such crisis.

    ReplyDelete

  30. QuickBooks is an accounting software program generated by Intuit. In QuickBooks Payroll Support 2019, assists you to all the billing, bookkeeping, and invoicing at one place. You are able to track sales and expenses, accept payments etc.

    ReplyDelete
  31. The QuickBooks Payroll Support Phone Number team at site name is held responsible for removing the errors that pop up in this desirable software. We care for not letting any issue can be purchased in in the middle of your work and trouble you in undergoing your tasks.

    ReplyDelete
  32. QuickBooks Premier is an accounting software suit, which caters into the needs of small and medium-sized business enterprises. QuickBooks Support Number comes with an original feature that allows multiple users to gain access to the same file at the same time. This type of QB now offers retrieval of data at any moment as well, because the database is stored on their server. QuickBooks Premier also facilitates evading loss of data and allows recovery of deleted items as well. With Premier, functions like tracking bills, status of created bills, purchase orders and recording other transactions becomes less complicated. QuickBooks Premier also offers high security and privacy aided by the absolute assurance that no theft or leakage of any information or data will require place. This really is why QuickBooks Support is arguably the best online accounting software suit for professionals.

    ReplyDelete
  33. We all know that for the annoying issues in QuickBooks Enterprise software, you'll need an intelligent companion who are able to enable you to get rid of the errors instantly. Due to this we at QuickBooks Enterprise Support Phone Number contact number gives you the essential reliable solution of the each and every QuickBooks Enterprise errors.

    ReplyDelete
  34. Every user will get 24/7 support services with this online technical experts using QuickBooks Enterprise Support Phone Number. When you’re stuck in times for which you can’t discover a way to get rid of a concern, all that's necessary would be to dial QuickBooks customer support contact number. Be patient; they will certainly inevitably and instantly solve your queries.

    ReplyDelete
  35. Quickbooks Payroll Support could be the toll-free quantity of where our skilled, experienced and responsible team are available 24*7 at your service. There are a selection of errors that pop up in QuickBooks Payroll Support Number which are taken care of by our highly knowledgeable and dedicated customer support executives.

    ReplyDelete
  36. We know that for the annoying issues in QuickBooks Enterprise software, you will require a sensible companion who can enable you to eradicate the errors instantly. Because of this we at QuickBooks Enterprise Support Phone number gives you the essential reliable solution of the every single QuickBooks Enterprise errors.

    ReplyDelete
  37. Make Contact With Us. Consult a professional through live chat. Our QuickBooks Tech Support Number executives are here round the clock to wait you. Whatever channel you determine to e mail us, you'll get an undivided awareness of your problem from our people. You will get a number of fixes here in just one ring. Why settle for less then? Give us a call, inform us your trouble and fix it.

    ReplyDelete
  38. Hope now you recognize that just how to interact with and QuickBooks Enterprise Help Number. We've been independent alternative party support company for intuit QuickBooks, we don't have just about any link with direct QuickBooks, the employment of name Images and logos on website simply for reference purposes only.

    ReplyDelete
  39. Every user will get 24/7 support services with this online technical experts using Quickbooks Support. When you’re stuck in a situation in which you can’t find a method to get rid of a problem, all you need is to dial QuickBooks customer support contact number. Have patience; they're going to inevitably and instantly solve your queries.

    ReplyDelete
  40. Pro, Premier, Enterprise, Point of Sale, Payroll along with Accountant, dependant on your need. QIntuit QuickBooks Support team is definitely ready to assist its customers via online support with every possible error which they come in terms with. There are times once the customers face problem in upgrading their software into the newer version, they generally face issue in generating reports etc. Though QuickBooks has made bookkeeping a child’s play, moreover it is sold with a couple of loopholes that cannot be ignored.

    ReplyDelete
  41. Now open the file and click on Update Company File for New Version. And now maybe you are all set. https://www.errorsupportnumber.com/ If this doesn’t help you, go ahead and connect to us at QuickBooks support phone number.

    ReplyDelete
  42. Mistaken for your QuickBooks software or stuck in between making invoice ?You can reach us at QuickBooks Enterprise Support Phone Number to reach us for instant help. You merely need to dial Our QuickBooks Support phone number to reach our experts.

    ReplyDelete
  43. The primary functionality of QuickBooks Support Phone Number + 1888-567-1159 depends upon company file. Based on the experts, if you'd like solve the situation, then you'll definitely definitely need certainly to accept it first. The error will likely not fix completely until you comprehend the root cause associated with problem.

    ReplyDelete
  44. The QuickBooks Payroll Support Phone Number software has tight security. Thus, all of your data are safe. You are able to put the password over there. This might protect the contents.

    ReplyDelete
  45. Basically it is founded that many of customers are facing several issues in their enterprise system, for solving their enterprise related issues QuickBooks Support Number Hosting services are made for solving their issues. Using this service of QuickBooks the customers

    ReplyDelete
  46. Problems are inevitable plus they usually do not come with a bang. Our team at QuickBooks Support Phone Number is ready beforehand to provide you customer-friendly assistance if you speak to an issue using QuickBooks Pro. All of us is skilled, talented, knowledgeable and spontaneous. Without taking most of your time, our team gets you rid of all unavoidable errors of this software.

    ReplyDelete
  47. The QuickBooks Payroll has many awesome features that are good enough when it comes to small and middle sized business. QuickBooks Payroll also offers a dedicated accounting package which include specialized features for accountants also. You can certainly all from the QuickBooks Toll Free Phone Number to find out more details. Let’s see many of the options that come with QuickBooks that features made the QuickBooks payroll service exremely popular.

    ReplyDelete
  48. A QuickBooks Payroll Support Phone Number is a type of subscription this is certainly done to activate the payroll features in your QuickBooks Desktop Software. Intuit Online Payroll exports transactions to QuickBooks Desktop along with Quickbooks Online as standalone software.

    ReplyDelete
  49. nice article
    http://www.kitsonlinetrainings.com/ibm-integration-bus-online-training.html
    http://www.kitsonlinetrainings.com/ibm-message-broker-online-training.html
    http://www.kitsonlinetrainings.com/ibm-message-queue-online-training.html
    http://www.kitsonlinetrainings.com/linux-admin-training.html

    ReplyDelete
  50. nice article thanks for sharing the post...!
    http://www.kitsonlinetrainings.com/linux-online-training.html
    http://www.kitsonlinetrainings.com/microsoft-azure-online-training.html
    http://www.kitsonlinetrainings.com/oracle-dba-online-training.html
    http://www.kitsonlinetrainings.com/oracle-soa-online-training.html
    http://www.kitsonlinetrainings.com/r-programming-online-course.html

    ReplyDelete
  51. nice article
    http://www.kitsonlinetrainings.com/scom-training.html
    http://www.kitsonlinetrainings.com/quality-analysis-qa-training.html
    http://www.kitsonlinetrainings.com/qtp-training.html
    http://www.kitsonlinetrainings.com/manual-testing-training.html

    ReplyDelete
  52. nice article
    http://www.kitsonlinetrainings.com/scom-training.html
    http://www.kitsonlinetrainings.com/quality-analysis-qa-training.html
    http://www.kitsonlinetrainings.com/qtp-training.html
    http://www.kitsonlinetrainings.com/manual-testing-training.html

    ReplyDelete
  53. QuickBooks Enterprise Support contact number is assisted by an organization this is certainly totally dependable. It is a favorite proven fact that QuickBooks Support has had about plenty of improvement in the area of accounting.

    ReplyDelete
  54. A group of QuickBooks Technical Support dedicated professionals is invariably accessible to suit your needs so as to arranged all of your problems in an attempt that you’ll be able to do your projects while not hampering the productivity.

    ReplyDelete
  55. To fix this issue the HP Printer Tech Support Team Number user needs to find the heat source and check for the air flow. For this, you are supposed to know how to clean HP laptop fan. One of the most witnessed issues with the HP laptop overheating and shutting down. Overheating of a system can cause many problems.

    ReplyDelete
  56. Advanced Financial Reports: the consumer can surely get generate real-time basis advanced reports with the help of QuickBooks. If one is certainly not known with this feature, then, you can easily call our QuickBooks Payroll Technical Support. They are going to surely provide you with the necessary information to you personally.

    ReplyDelete
  57. If you are a small business owner, you need to be aware of the fact that Payroll calculation does demands large amount of time and man force. Then came into existence QuickBooks Payroll Support Phone Number and Quickbooks Payroll Customer Support telephone number team.

    ReplyDelete
  58. This comment has been removed by the author.

    ReplyDelete
  59. How to contact QuickBooks Payroll support?
    Different styles of queries or QuickBooks related issue, then you're way in the right direction. You simply give single ring at our toll-free intuit QuickBooks Payroll Helpline Number . we are going to help you right solution according to your issue. We work on the internet and can get rid of the technical problems via remote access not only is it soon seeing that problem occurs we shall fix the same.

    ReplyDelete
  60. The difference that we make amongst our competitors is that our QuickBooks Support Number can be obtained 24*7. But we now have made certain that our services are there not only for namesake.

    ReplyDelete
  61. Our research team is always prepared beforehand because of the most suitable solutions that are of great help much less time consuming. Their pre-preparedness helps them extend their hundred percent support to all the entrepreneurs in addition to individual users of QuickBooks Customer Support Number.

    ReplyDelete
  62. You might explore the various queries which were posted by other individuals to their online forum page. Most of the time, what the results are would be the fact that there could be few individuals who may have the exact same concern or query related to their QuickBooks Payroll Support Phone Number software product.

    ReplyDelete
  63. QuickBooks encounter an amount of undesirable and annoying errors which keep persisting with time if you do not resolved instantly. Certainly one of such QuickBooks issue is Printer issue which mainly arises as a result of a number of hardware and software problems in QuickBooks, printer or drivers. You're able to resolve this error by using the below troubleshooting steps you can also simply contact our QuickBooks Tech Support Phone Number available at.You should run QuickBooks print and pdf repair tool to determine and fix the errors in printer settings prior to starting the troubleshooting.

    ReplyDelete
  64. Are you currently utilizing the software the first time? You can find some technical glitch. You'll have errors also. Where do you turn? Take assistance from QuickBooks Support Phone Number right away. We are going to provide full support to you. You can cope with the majority of the errors.

    ReplyDelete
  65. If you are already using QuickBooks Payroll for your business while having now certain problems with it, you are able to immediately get in touch with our QuickBooks Payroll Support team service experts that may help you rectify the issues or whatever problems you might very well be facing along with your QuickBooks Payroll business software product.

    ReplyDelete
  66. Only at QuickBooks Enterprise Support Number . User get directly linked to expert certified Technicians to have immediate fix with regards to their accounting or technical issues.

    ReplyDelete
  67. You will find lots many errors in QuickBooks Support Phone Number such as difficulty in installing this software, problem in upgrading the software in the newer version so that you can avail the most up-to-date QuickBooks features,

    ReplyDelete
  68. A little grouping of execs are capable of you manually because of they’re absolute to offer the standard services. So, if you face any issue with your package you don’t need to go anywhere except QuickBooks Support Phone Number.

    ReplyDelete
  69. QuickBooks Enterprise Support Phone Number assists you to definitely overcome all bugs through the enterprise forms of the applying form. Enterprise support team members remain available 24×7 your can buy facility of best services.

    ReplyDelete
  70. Therefore, QuickBooks Support Phone Number is present for users around the globe as the best tool to produce creative and innovative features for business account management to small and medium-sized business organizations.

    ReplyDelete
  71. We understand that for your annoying issues in QuickBooks Enterprise software, you want a good companion who are able to allow you to eradicate the errors instantly. This is the reason we at QuickBooks Enterprise Support Number offers you the essential reliable solution of the each and every QuickBooks Enterprise errors.

    ReplyDelete
  72. At QuickBooks Support Phone Number we focus on the principle of consumer satisfaction and our effort is directed to give a transparent and customer delight experience. A timely resolution when you look at the minimum span could be the targets of QuickBooks Toll-Free Pro-Advisors. The diagnose and issue resolution process has been made detail by detail and is kept as easy as possible.

    ReplyDelete
  73. You can make call us at QuickBooks Enterprise Support Phone Number to install the software on your computer and fix all the issues related to the performance of your software.QuickBooks Desktop Enterprise is accounting software that offers business reporting and management tool to control the business from one robust platform. This software provides inventory management tools that allow users to analyze the data and take informed decisions. It is also helpful in preparing customized reports.

    ReplyDelete
  74. We are committed to providing high quality remote tech support assistance to all our customers. Call us QuickBooks Enterprise Support Phone Number at +1 877 717 0787 and get quick resolution of all your tech problems. We are 24/7 available to assist you without making you wait longer over the phone call. For best results and instant assistance, call now!
    QuickBooks Enterprise Support Phone Number +1-877-717-0787

    ReplyDelete
  75. At QuickBooks Premier Support Phone Number
    we focus on the principle of consumer satisfaction and our effort is directed to provide a transparent and customer delight experience. A timely resolution when you look at the minimum span may be the targets of QuickBooks Toll-Free Pro-Advisors. The diagnose and issue resolution process happens to be made step by step and is kept as easy as possible.

    ReplyDelete
  76. QuickBooks is one of the most sought-after financial accounting software in the marketplace. Due to its great variety of features, it has become extremely popular among its users. However, it can from time to time be plagued by certain technical hindrances. You can even contact our QuickBooks Support Phone Number team using QuickBooks Support number.

    ReplyDelete
  77. QuickBooks Support Is One Stop Solution Our dedicated team is sure with you. These are typically surely working at any hour to assist and make suggestions if you run into any QuickBooks error/s. Our QuickBooks Tech Support Number team surely have in-depth knowledge regarding the issues and complications of QuickBooks.

    ReplyDelete
  78. The QuickBooks Enterprise lets a business take advantage of their QuickBooks data to create an interactive report that can help them gain better insight into their business growth that have been manufactured in recent past. This particular advanced levels of accounting has various benefits; yet, certain glitches shall make their presence while accessing your QuickBooks data. QuickBooks Support Phone Number is available 24/7 to provide much-needed integration related support.

    ReplyDelete
  79. Roku Customer Care Phone Number +1-(877-717-0727) is one of the best ways to talk to their customer support team. The Roku Help services are available 24*7 for the customers to provide the user-friendly customer support services. If you are facing trouble with the service of Roku TV, and need some help from customer care executive to sort out the issue. So Call our roku customer care phone number +1-877-717-0727 toll free for USA/CANADA Customer support.
    Roku Customer Care Phone Number +1-(877-717-0727) For USA Support

    ReplyDelete
  80. The QuickBooks Desktop Support Number is toll-free as well as the professional technicians handling your support call may come up with an instantaneous solution that can permanently solve the glitches.

    ReplyDelete
  81. The retail businesses always consume a lot of time. Retail sellers have to sell their goods to achieve maximum profit. QuickBooks Enterprise Support Number can easily manage your retail business by availing its silent features. This software is helpful to manage your data, pricing, reports in the most efficient manner.With the help of advanced inventory feature, you can manage the inventory easily. You can easily handle the data with this software like vendor lists, items and customers. This software is helpful in adding thousands of price rules.

    ReplyDelete
  82. Nice information

    Revanth Technologies provides best WebSPhere MQ Online Training from India. We provide the software training with well experienced and real time faculties on various IT Courses. We provide the training based of the specific needs of the students.

    For more details contact : 9290971883, 9247461324
    Mail : revanthonlinetraining@gmail.com
    For course content & details visit http://www.revanthtechnologies.com/web-sphere-online-training-from-india.php

    ReplyDelete
  83. ?QuickBooks often called the QB is the greatest accounting software that features integrated various tools to produce your company accounting process a hurdle free one. QuickBooks is popular due to the reliable, certain and accurate calculations which do save your time with regards to managing your business accounts the correct way. QuickBooks Support phone number can be obtained 24/7 to provide much-needed integration related support. Being a favorite product among both small and large scale business running people, QuickBooks does have its own flaws that can be immediately reported and corrected by contacting the QuickBooks Support Number team.

    ReplyDelete

  84. The group deployed at the final outcome of QuickBooks Support telephone number takes great good care of most from the issues of the software. QuickBooks Support have a group of experts that might be pro in handling almost all of the issues as a result of this incredible software.

    ReplyDelete
  85. Roku Customer Care Phone Number (+1)-877-717-0727 is one of the best ways to talk to their customer support team. If you want to fix your errors/issues then call our toll free number. Roku customer care number is designed to provide customer support for available resources.
    https://www.reviversoft.com/answers/1160724023/roku-customer-care-phone-number-1-877-717-0727-for-usa-support

    ReplyDelete

  86. We have been very popular support providers for QuickBooks accounting solutions. Your QuickBooks software issues will begin vanishing as soon as you are certain to get associated with us at QuickBooks Support Phone Number.

    ReplyDelete
  87. We have a team of professionals that have extensive QB expertise and knowledge on how to tailor this software to any industry. Having performed many QB data conversions and other QB engagements, we have the experience that you can rely on. To get our help, just dial the QuickBooks Support to receive consultation or order our services. We will help you streamline and simplify the accounting, reporting and tracking so that managing your company’s finances would be much easier. Also, we guarantee to maintain anonymity and high level of security while handling issues related to QB software use. Our QuickBooks customer service is available to you at any time. Get in touch with us by using a phone number or email indicated on the Quickbooks Support site. We will be happy to assist you with any question about QuickBooks you might have.

    ReplyDelete
  88. Call us now at our Avast Support Phone Number even if you are a new user of Avast. We provide all the tips and suggestions to help you have a go with Avast antivirus. If you still get the same mistake, dial the Avast phone number and get technical assistance. Avast technical team has years of experience and can solve all your questions in a very short time. Now you won't have to worry about technical problems with Avast. Simply dial the antivirus support phone number for Avast support and talk to our technical managers.
    Avast Support Phone Number +1-877-717-0727 IN USA/CANADA

    ReplyDelete
  89. Hi! Lovely post. I simply couldn’t leave your website before suggesting that I liked your work. I’m gonna be back continuously to check up on the new post. QuickBooks POS is one of the best versions of QuickBooks. You can avail instant help and support at QuickBooks POS Support Phone Number 1-855-236-7529. So, in case you come across any error then simply dial our QuickBooks Technical Support Phone Number 1-855-236-7529.
    Read more: http://bit.ly/2kgOogd

    ReplyDelete
  90. If you are one of the users experiencing similar problems, you can contact the AVG support number. If you have problems or have a technical problem by default, you can connect to the support team by dialing Avg Antivirus Support Phone Number +1{877 -717-0727}. So, if you are concerned about the safety and protection of your system, contact the expert team today by dialing AVG support number and say goodbye to all your worries. The experts are available 24/7 to provide your immediate assistance to troubleshoot AVG Antivirus issues.
    Avg Antivirus Support Phone Number +1-877-717-0727 IN USA/CANADA

    ReplyDelete
  91. Our Avira Support Phone Number +1 {877-717-0727} you in completely removing the viruses and malwares from your computers and Laptops. Let us take the secure way to protect your PCs by identifying the issues you are facing due to Viruses. Call our Toll free support number to speak to one of our technician and we will apply best solution to take care of your problem. We are providing a technical support for avira antivirus for USA and CANADA client we providing a 24x7 technical support for avira our toll free number is 877-717-0727. Visit: https://getownflower.com/avira-support-phone-number.php

    ReplyDelete
  92. Contact HP Printer Customer Care Number for troubleshoot all HP printer errors. HP printer customer service team is available 24 hours for help and support. HP Printer HP Printer Support Number +1-855.381.0111 to resolve all HP Printer products. HP Printer is an American multinational company which was founded by HP Printer using its company headquarters in Round Rock, United States of America. Contact HP Printer for Setup & Installation HP Printer Setup Service & Installation.
    HP Printer Customer Care Number +1-855-381-0111 IN USA/CANADA

    ReplyDelete
  93. Nice information, thanks for posting. We provide software online and classroom training. Visit www.revanthtechcnologies.com

    ReplyDelete
  94. Great info, thanks for sharing with us.
    If you need any type help in QuickBooks accounting software you can call our QuickBooks technical support expert @ +1-800-280-5068 and you can go here too Quickbooks Payroll Support

    ReplyDelete