RexHelios (5/29/2013)

---

I am passing these to a stored procedure call. If I set it at the SSRS parameter, it will either accept NULL or not. What I need is, for...

For your dataset query, are you using a text command type or stored procedure?

EDIT: I should have been more clear. You can set the parameter in the node to...

I'm... confused I think.

Can you list out your schema and some sample data in a consumable format, along with the triggers you've built so far? It would be far...

Not directly, at least not with SSRS. You'd need more of an interface to pass down parameters for rowcounts and starting rows to a proc which would restrict the...

How many mice did the cats eat before the mice stopped being sentient?

I believe the order of operations is what's confusing you, along with a secondary syntax for IF.

There are two ways to write an IF:

IF 1=1

PRINT 'One Command Only Active'

BEGIN

PRINT...

I was about to suggest that then realized you'd found your answer as I read down.

There are two things you always do for any stored procedure that's more complex than...

There is no countdown, there is only Zuul...

Yes, but the one I have in mind hasn't posted here in a while and I'm afraid to invoke his name.

Out of curiosity, can you move category_id up to #rateheader? That seems like the most logical place for it long-term, and means you won't end up with one...

brickpack (5/24/2013)

---

Let me rephrase that...I'm actually looking for the total number of product *rates* for each product category. That's why I've included the custrate table in the example. A...

Well, I think this gets you where you need to be:

SELECT

c.Category_Name,

COUNT(*) AS Total

FROM

(SELECT DISTINCT

category_id,

rg_id

FROM

#rate

) AS drv

JOIN

#product_category AS c

ONdrv.Category_id = c.Category_id

GROUP BY

c.Category_Name

I converted things to #tables so if you need those:

CREATE...

Without sample schema and data we're trying to offer you ideas, not perfect error free code.

If you would like us to be able to provide solutions that are (nearly) guaranteed...

*scratches head*

Okay, you've officially confused me... and I thought I understood it, so bear with me. Is my assumption correct that the rate table has a 'minimum bought' column...

For the love of gods...

THANK YOU. 😀

I owe you a beer. Or ten.