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...

Cross database access requires that the user also have rights in the other database.

Yes, if set to unrestricted growth, it will grow until it fills the drive. You should also look at setting tempdb to grow a set amount instead of 10%...

Obviously, your ERP database is using the Full Recovery model. In this model, if you are using Full, Differential, and Transaction Log backups appropriately, you can recover your database...

tymberwyld (11/10/2008)

---

Basically what's going on here is that someone is looking at some wireframes of the UI and that's getting translated directly into a database design. If they want...