The first time I played the computer sunk my entire fleet in 29 shots while I only scored 3 hits!!

Grrrr, the code must have BUGS!! 😉

Thanks for a new...

I think what I ended up doing was using a simple select statement to find if the proc would return any results then if it did not, the proc was...

Here's what finally worked in case anyone else needs it:

This is the Expr for the %Growth textbox

=Code.GetGrowthValue(Sum(iif(Fields!Period.Value="YTD",Cdbl(Fields!Qty.Value),Cdbl(0))),

Previous(Sum(iif(Fields!Period.Value="YTD",Cdbl(Fields!Qty.Value),Cdbl(0))), "matrix1_Year"))

I looked at some Calendar table ideas and it seemed you still needed logic for how to handle when a week spans 2 months. I certainly may be over-complicating this....

Hi all,

I was looking for examples for my specific situation and found this thread. I thought I would post my solution in case it helped others.

My specific requirement is to...

Anyone, Anyone 🙂 Is it not possible to replace the cursor in the stored procedure with a set based solution? The cursor works and fulfills my business requirement...

That works. I was trying to use count(*) to compare count of all lines with count of lines that have discounts. Just was not getting it. Your...

That worked. Thanks!

More strange findings when using BCP:

The proc has a cursor. I added an audit log step to the proc so it inserts audit info to another table.

When I run...

Do you guys have any articles or links you can point me to on server side traces? I can't seem to find how to trace a change to a...

Thanks for the info.

I am trying to catch somebody with their hand in the cookie jar 😉

There is some rogue app or custom code somewhere causing an undesired update.

This does...

Ahh, I was only looking in QA then copy/paste to Notepad. The finished output does have the tab.

Thanks.

Thanks for the reply. I was able to get this working. The client is actually a Windows XP Home edition (I get all the doozies). The login...

The status and type only appear in the ordheader, not ordline. So I don't think Inserted would contain the status and type.

I'm quite the junior scripter so any extra info would be appreciated.

1) are u saying use 2 triggers, 1 for update, 1 for insert?

2) where would @@rowcount be used? ...