Viewing 15 posts - 4,006 through 4,020 (of 4,076 total)
Without sample data it's really hard to know, but it sounds like you don't really need to compare months, you just want members who were added this month. There...
August 18, 2009 at 1:27 pm
It might work with a global temp table. You define a global temp table using two octothorpes instead of just one
Create Table ##temp
The global temp table can be used...
August 18, 2009 at 1:02 pm
I think the confusion is coming because of the term "Total Customers". There are actually two separate measures which could be called "Total Customers" and you're mixing the two....
August 18, 2009 at 10:31 am
Ryan Keast (8/18/2009)
Just had a chance to test out your code and I am still pulling back the three results as originally posted.Any more help would be appreciated.
As I said...
August 18, 2009 at 8:46 am
Revenue should be one of the facts in your fact table and this fact should become a measure when you create and process your cube. If revenue is not...
August 18, 2009 at 8:17 am
Ravi (8/17/2009)
I have attached the sample data and expected outputlet me try to explain what i need
It's only slightly better. You still haven't provided it in the...
August 17, 2009 at 8:29 pm
The purpose of BI is to give you the BIG PICTURE about your business. If you're looking at individual customers out of ~ 3 million customers, you're down in...
August 17, 2009 at 3:33 pm
Jon Beer (8/17/2009)
(CompanyA avg_customer_revenue * CompanyA total_customers) + (CompanyB avg_customer_revenue * CompanyB total_customers)
+ (CompanyC avg_customer_revenue * CompanyC total_customers)
/ (CompanyB total_customers + CompanyC total_customers)
In the denominator we...
August 17, 2009 at 11:59 am
I think that you're trying to make this more complicated than it needs to be. I was able to match your output with a simple ORDER BY clause.
SELECT Parent_ID,...
August 16, 2009 at 12:41 pm
netguykb (8/15/2009)
I think its because FOR XML PATH is a 2005 thing I only have 2000[...]
Thanks again I appreciate both your efforts, and he definitely pays to post with etiquette
Well,...
August 15, 2009 at 1:44 pm
I think this code is much simpler.
ALTER procedure Emp_name_proc
(
@emp_id varchar(100)
)
as
begin
declare @sql varchar(100)
select @sql = 'SELECT EmpName FROM Test WHERE EmpID IN (' + @emp_id + ')'
Exec(...
August 14, 2009 at 3:40 pm
Grant Fritchey (8/13/2009)
Or, since you only care about when records do exist, check for NOT NULL values on the outer table. You'll still arrive at the same place.
No, the OP...
August 13, 2009 at 2:35 pm
If you are using joins to check, an inner join will only work where a record exists. If you want to check for non-existence, you will have to use...
August 13, 2009 at 1:08 pm
Ryan Keast (8/13/2009)
I expect this as I am linking to the dbo.DW_SERVICEORDERSJOBS_F table and that invoice...
August 13, 2009 at 9:10 am
Julie Zeien (8/12/2009)
August 12, 2009 at 2:14 pm
Viewing 15 posts - 4,006 through 4,020 (of 4,076 total)