How is this percentage supposed to be calculated?

Glad we could help.

Concur. That makes three, must be true.

As you mention a table scan, I am making two assumations, 1) the index that you are referencing is a nonclustered index, and 2) there isn't a clustered index on...

sharon.souto (5/7/2010)

---

Hi all,

I have some code written by a developer who no longer works here, and they often use a star in their where clauses. I don't know what...

CirquedeSQLeil (5/7/2010)

---

GilaMonster (5/7/2010)

---

You and...

Check out the function here. It is an inline TVF and will out perform your multi-line TVF.

Also, if youdo some searching here on SSC you may find similar routines...

I'm STILL trying to...

Doesn't answer the question really. How is this supposed to be computed? If you have included this in the query above,...

Percent of what?

Also, you may want to change this:

where convert(char(8), dtmdatecreated, 112) >= convert(char(8), GETDATE()-7, 112)

to this:

where

dtmdatecreated >= dateadd(dd, -7, dateadd(dd, datediff(dd, cast('19000101' as datetime), getdate()),...

Our PhD candidate at work.

If you want additional help you need to do some additional work.

You need to post the DDL (CREATE TABLE statement(s)) for the table(s) involved. You need to report the...

You may get better help from your email administrator. That is where i would go with issues like this one.

srilu_bannu (5/6/2010)

---

What if i have data in sales table like this:

table c insertion:

insert into sales values

(2,200,2007)

(3,300,2010)

(5,300,2010)

if i only include B.year then i will miss 2007 shipped data in Sales table...

You really don't need to use cursors. A delimited split function written as an inline TVF used with cross apply would work much more efficiently.

You can find several such...