Skinning cat method #2:

select * from #orders o

cross apply (

select OrderNumber, SUM(total) OrderTotal

from #orders

where OrderNumber = o.OrderNumber

group by OrderNumber) a

Yep, all good. Thanks.

Did it help the last time we worked on this proc?

http://www.sqlservercentral.com/Forums/Topic1218042-392-1.aspx

Only if the table contains biological wastes....

GilaMonster (12/19/2011)

---

Have you looked at the wait type and resource? (of both that function and any other query you run)

Is the CPU bottlenecked?

Is that functionality written optimally? Are there good...

SELECT OBJECT_NAME(parent_object_id)

FROM sys.objects

WHERE...

omalie24 (12/14/2011)

---

HEY....IT WORKS...BUT I NEEDED IT TO CYCLE THROUGH MULTIPLE ROWS OF DATA WHICH HAS DIFFERENT SERIAL NUMBERS.....I KINDA FIXED IT.....I KNOW U WOULDNT LIKE THIS BUT I WRAPPED...

Ok, here is a way to do this with using a loop. I'm showing this way because I think you will understand this the most. You should in general avoid...

Ok, but understand that if you want to...

omalie24, this is the type of info we need to help you. I typed this up to get you started.

create table [dbo].[Test_Sales] (

[TRAN_DATE] varchar(10),[ITEM_CODE] varchar(20), [SERIAL_NUMBER] bigint,

[CUSTOMER_NUMBER] varchar(20), [CUSTOMER_NAME] varchar(20),[QUANTITY]...

Sean Lange (12/13/2011)

---

toddasd (12/13/2011)

---

That's...

That's because all the...

In Access VBA, he is the basic way to call a proc:

Dim rs As New ADODB.Recordset

rs.Open "dbo.StoredProcedure1 " & [Forms]![AcftSelect]![cboSA], CodeProject.Connection, adOpenForwardOnly

'do stuff

rs.Close

Just concatenate the proc name and the parameters.

Edit:...

Nevermind that one, think I got it. Check that any of the dates in the table are before 1753:

SELECT *

FROM dbo.Names

WHERE DateOfLicense1 < '01-Jan-1753'

OR DateOfLicense2 < '01-Jan-1753'

OR DateOfLicense3...

Also, if your columns are char based, then you may have an invalid date. Run this to find it:

SELECT *

FROM dbo.Names

WHERE ISDATE(ISNULL(DateOfLicense1,CAST('01-DEC-2015' AS DATETIME)))=0

OR ISDATE(ISNULL(DateOfLicense2,CAST('01-DEC-2015' AS DATETIME)))=0

OR ISDATE(ISNULL(DateOfLicense3,CAST('01-DEC-2015'...