Thanks, but I'm not working from a screen shot of the data. Please take the time to read the article shown below in my signature block and follow the...

What is your table structure and what is the actual error message you are receiving?

Drop 10 yards and punt?

Not sure either. We don't know your table and view structures, we don't have any sample data with which to work. All we can...

You may need to edit the data. If you have nulls where you can't have them, you will need to provide a proper alternative using ISNULL.

You may have eliminated the cursor, but you may not have eliminated the RBAR (Modenism for Row By Agonizing Row) processing.

If you post your code, table DDL (create statements), sample...

Can you explain why you are "updating" the primary key in your update statement?

paul.starr (11/10/2008)

---

when i run this i get an error:

Msg 208, Level 16, State 1, Procedure BILLTO_Customers, Line 7

Invalid object name 'dbo.cust.Customers'.

USE [AtriumWOE_CS_UserData_52]

GO

/****** Object: StoredProcedure [dbo].[BILLTO_Customers] ...

Would you please post the actual query? What you posted makes no sense to me.

paul.starr (11/10/2008)

---

How do I write a stored procedure that inserts if record is not there and updates if record is there?

////Alter Procedure

ALTER PROCEDURE [dbo].[BILLTO_Customers]

AS

DECLARE @message ...

Christopher Stobbs (11/10/2008)

---

well other than the fact that you missing half the BETWEEN statement I would say yes almost there.

c.Date > = DATEDIFF(yy,-5,GETDATE())

Please not the this will take into account...

GilaMonster (11/10/2008)

---

Patrick Russell (11/10/2008)

---

I guess I hadn't thought of that. I actually try to stay away from dynamic sql. I always thought there where sql injection issues with it. Only...

Don Bernstein (11/10/2008)

---

I have a linkage table with 2 columns: StudentID, CustomID.

I want to use a Print statement to show the number of students (StudentID's) in the table.

I could not...

It would also help if you posted the code for your UDF as well as both valid and invalid sample data for the function.

No,...

It depends. Is there anything else going on with the database that you haven't told us, like replication? There could also be some long running transactions that keep...