OK. So do you still need help? If so, what...

gfoulks (3/13/2014)

---

It sort of makes sense but not entirely. I'm not evaluating the phone numbers together but instead want to treat them two separate values

Does the ANI = "6141112222' or...

Glad that worked for you. Do you...

gfoulks (3/13/2014)

---

I created this trigger

CREATE TRIGGER TR_SomeTableInsteadOfFilter ON SomeTable

INSTEAD OF INSERT

AS

BEGIN

SET NOCOUNT ON;

INSERT INTO SomeTable([DateTime],Acct_Number,SSN,Script_Code,Div_indicator,first_name,last_name,ani,terminate_area,transfer_area)

SELECT [DateTime],Acct_Number,SSN,Script_Code,Div_indicator,first_name,last_name,ani,terminate_area,transfer_area

FROM INSERTED WHERE ani <>...

Seggerman-675349 (3/13/2014)

---

I want to thank you guys (you are guys, right?) for all your help. I've got the running total working, now gotta get the rest of it working....

SQLRNNR (3/13/2014)

---

Greg Edwards-268690 (3/13/2014)

---

The Dixie Flatline (3/13/2014)

---

andrew gothard (3/13/2014)

---

The Dixie Flatline (3/12/2014)

---

SQLRNNR (3/12/2014)

---

The Dixie Flatline (3/12/2014)

---

I have a database. It doesn't work. Please advise.

Thanks in advance.

P.S. Please...

Nice job posting ddl and consumable sample data. That goes a long way towards getting an answer. I don't see anything in your code or your desired that makes this...

Unless I am missing something it seems that you already wrote the query.

Just put a SELECT in front and a FROM

Select TotalWeightedCost = sum(SWeightingFactor...

Glad you got it figured out and thanks for letting me know.

We are getting close to an understanding. We now have the two tables (AVAILATS and ORDER_ITEMS_STAGE).

Can you explain what should happen here. I think that what you want for Item_No...

This is a good place to start.

http://technet.microsoft.com/en-us/library/ms189121.aspx

You will notice that there is a built-in role...

You shouldn't...

Seggerman-675349 (3/12/2014)

---

thank you for making the stored procedure more readable

here's what the procedure does:

it takes a file of Available to Ship

with ItemNo CUSTNO and qty

...

Luis Cazares (3/12/2014)

---

I might be trying to kill a fly with a sledgehammer but this could be an option. It could be turned into an inLine Table-valued Function if needed...

Let's start with formatting this so we can read it.

ALTER PROCEDURE SlowStoredProcedure @FirstCUSTNO CHAR(6) = '000000'

,@LastCUSTNO CHAR(6) = '099999'

,@LowItem VARCHAR(30) = '0'

,@HighItem VARCHAR(30) = 'ZZZZZ'

AS

BEGIN

SET NOCOUNT ON

DECLARE @RightNow DATETIME

DECLARE @sum_shipqty...