Jon Beer (8/17/2009)

---

Our formula is:

(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...

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,...

Well,...

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( @sql )

end

No need for...

No, the OP...

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...

Ryan Keast (8/13/2009)

---

When I run this code I am getting three results for Sales Invoice Reference 4980586.

I expect this as I am linking to the dbo.DW_SERVICEORDERSJOBS_F table and that invoice...

Julie Zeien (8/12/2009)

---

Correct me if I'm wrong. I'm not saying the OP shouldn't use the PIVOT solution. I'm just saying that if they wanted something that didn't care...

Here is another option using Row_Number() instead of the Identity Column. This means that you don't need the DDL language to create the temp table.

Declare @TagNameIDBase int

SELECT @TagNameID=isnull(MAX(TagNameID),0) from...

Lowell (8/12/2009)

---

the forum doesn't like things that look like html tags....wierd results occur, like the clickable button above, which got rendered as an object instead of text:

i had to find...

My solution will work for stepparents as...

That's much better. Try the following code:

SELECT SCT_NAME, [1] + IsNull(', ' + [2], '') AS Parents

FROM (

SELECT

...

I think that this line from BOL...

You're going to need to use a PIVOT (or equivalent). If you want a more detailed answer, I suggest that you follow the forum etiquette guidelines and post the...

The following query only queries #tmp once.

WITH Z_cte AS (

SELECT id FROM #tmp

GROUP BY id

HAVING Min(value) = 'Z'

...