another one of those questions straight from my database course 😛

I'm sure someone will come up with a more elegant solution, but this should work for you. if the total negative numbers add up to more than the total positive...

the main reason why you're getting problems trying to execute the code that people have been pasting here to assist you, is because they can't test it themselves before giving...

Ravi (8/17/2009)

---

for example if 0-30 days qty = -4 , 31-60 days qty = 4 and 61-90 days qty =2 then the expected output is 0-30days =0 , 31-60days...

Your stored proc returns a result set I assume, so I assume you're asking if you can do something like:

INSERT INTO TABLE (COLUMNS)

EXEC StoredProc

To my knowledge, no, you can't do...

If you actually want to remove N spaces, IE you want your procedure / statement to have an input which will define the number of spaces you want to remove,...

I don't think default values work for functions, though I could be wrong. Either way though, what Matt wrote will work, you don't really need to change your function declaration...

Yeah, having tried to help some other people out here with incomplete data to work with, I know how annoying that can be, so I do what I can 😛

The...

Well, I'm not sure if there's a CAST or...

So, let me see if I understand this right.

What you're essentially doing is, getting a total of the subscribers on a monthly basis, and then, using the results stored into...

it's pretty unlikely that the cause is due to the linked servers.

the procedure you've pasted is pretty huge, and without knowing any table structure or data details, it'd be hard...

Ravi (8/17/2009)

---

I have to create a report for aging and i am getting data as

Qty Age

-5 ...

Actually, you're right - I was wrong in what I wrote earlier.

When you have "IF NOT @i = 0", that evaluates into "IF NOT (UNKNOWN)", which results in FALSE.

IF (UNKNOWN)...

i think you just misinterpreted the answers. when he says "i is null", he means that the result of "If @i is null" evaluates to true, and so he's just...

this was like, an entire lecture's worth of material in the database course i just finished taking 😛 made it a bit easier to figure out, lol