You could create a view that displays that same information and that would have the added benefit of being real time.

Forgive me if this is a stupid suggestion but are you certain that there are zero applications inserting, updating and deleting on that table? Is there replication configured on that...

Oh my gosh, I spent nearly all day banging my head against the wall trying to come up with this. Thank you very much for the help and your time....

Your JOIN clauses must come after your FROM clause, as PW mentioned. And yes, if policy number is what links the three tables, then join on that, but the bottom...

Yes, the point of those joins is to return many results, because I want to perform a COUNT on the result set. So the first one might return 20-75 rows,...

It looks like ProductType is what joins together GE_Transaction and the other two tables. You could do something like this:

SELECT @WPR_R = Sum(Convert(float,r.WaiverofPremium))* Case

When ([ProductType] = 'P2'...

Your last SELECT statement is trying to select WaiverOfPremium and LossDate from GE_Transaction.

You need to join to the other two tables in order to make those columns available. If...

Thanks a lot! I had to change some things because I am using SQL Server 2005 but it's roughly the same. I also just put my EXEC statement inside the...

I totally agree that programmers need to be business analysts as much as technical experts and developers.

At my company we only hire people like this. We have no pure...

Offshore technical labor has limitations. For one thing, communication in software development is difficult with people who can speak to each other clearly, much less through different languages and accents....

I know how to calculate medians and means. I do it pretty much every day, but thanks for the review

I thought each row...

I don't understand why the median, which is something you derive from multiple rows, has a value for every single row...am I am missing something?

I usually use functions to return one single value, to help make query's easier to write. Like for example say you have a departments table, with a recursive fk relationship....

I wasn't aware of that. I join tables both ways, sometimes using both ways within the same statement. Can you give us an example that produces ambiguous results?

Another way that to my eyes is simpler looking:

SELECT p1.productName as ParentProduct, p2.productName as ChildProduct

FROM products p1, products p2, kits k, cart c

WHERE p1.productId = c.productId

AND k.parentProductId...