Tomm Carr (4/29/2008)

---

The problem with any candidate key is that someone can come in afterwards and "what if" it to death. You can take any attribute and keep expanding the...

what error do you get?

Assuming the objects are actually out there - that code looks like it would work....

Your initial (access) query failed because you changed the date around only in the select part of the query, not in the GROUP BY. you're still grouping by the...

add the count() aggregation to the query

SELECT MONTH(DateShipped) as 'Month',

YEAR(DateShipped) as 'Year',

...

In addition to GSquared's point - be sure to make the ReportingServicesTempDB BIG. Just like giving tempDB a big playground, ReportingServicesTempDB is going to take up a substantial portion...

select sum(case when colSector ='02' then colMkt else 0 end)/sum(case when colSector ='TF' then colMkt else 0 end) as percentage

from tblreturn

The reason why views aren't directly affected by sp_recompiled is that views aren't "compiled" in the traditional sense.

Let's try to explain that further

- "regular" views don't get their own...

Assuming you mean "not 0 through 9" when you say non-numeric (i.e. not trying to figure out decimal points, signs, etc...), then

substring(refnum,patindex('%[^1-9]%',Refnum),1)

should do the trick.

Q (4/29/2008)

---

When I read the question the first time, I believe I read it as the author intended; however,

Jeff's response made me think about a couple of possibilities. ...

rbarryyoung (4/29/2008)

---

RBYoung (4/29/2008)

---

Yes, that approach requires either MOSS or Forms Services as a server. I beleive that you can alternatively install (& license) the InfoPath 2007 client on each...

Michael Earl (4/29/2008)

---

You could add a calculated field to a table to have two fields in the table with the same data and two different names. Or, you could...

1. are there any rows in ZIPUSA for zip code '45053'? if not - that will never return anything.

2. if 1. does have data, then the function is messed...

n1pcman (4/29/2008)

---

That worked Thanks All,

Now one more missing peice...

I copy good data into a new table then I run the parsing query which seperates my data the way I...

Gail (4/29/2008)

---

matt the appoximation query from gsquared worked, the other one you gave me that calls the function still gives me no results with cross apply and only one zip...

Median is mathematically not an aggregate function per se - it's more of a windowing function (meaning - it's pulling out unchanged a speicific value in a sequence). You REALLY...