Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Have Two CTE combined int One Report

Posted on 2011-09-08
3
Medium Priority
?
208 Views
Last Modified: 2012-05-12
What is the best way on this?

Currently I run CTE_T then CTE_S in one SQL File and as a stored Procedure.
It only gets the first CTE data and not both when I try to run the sp and build my chart report in SSRS.

I want a dual bar chart comparing the numbers


I want a dual bar chart comparing the numbers
0
Comment
Question by:jaymz69
  • 2
3 Comments
 
LVL 17

Accepted Solution

by:
dbaSQL earned 2000 total points
ID: 36504739
0
 

Author Closing Comment

by:jaymz69
ID: 36505282
Thanks
0
 
LVL 17

Expert Comment

by:dbaSQL
ID: 36505306
My pleasure.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question