manub22 (7/26/2012)

---

Who said CURSOR is slower than WHILE loops? Didn't you asked them...

morepainot (7/26/2012)

---

Jeff and Sivaj, thank you guys for your help.

@jeff; I understand what you said and I will keep that in mind for the next post. The reason for the...

Stefan Krzywicki (7/26/2012)

---

Sean Lange (7/26/2012)

---

Here's a chuckle for you security types out there. I was trying reset my security questions today on the ADP site because apparently the available questions...

Here's a chuckle for you security types out there. I was trying reset my security questions today on the ADP site because apparently the available questions change from time to...

ChrisM@Work (7/26/2012)

---

Sean Lange (7/25/2012)

---

Phil Parkin (7/25/2012)

---

Nice article - thanks for the link. When I read absolutes (like 'meaningless') my brain subconsciously challenges them. I still think it was the wrong...

edward_hall76 (7/25/2012)

---

I figured out how to get my software to update without having to close the program I was able to add a button that did a windows refresh with...

Welsh Corgi (7/25/2012)

---

I thought that it could be as simple as a return code to indicate that there was an error.

This procedure will be executed in an SSIS Package.

If someone...

Welsh Corgi (7/25/2012)

---

Sean Lange (7/25/2012)

---

What is the question? I am not sure where you are stuck. You built your proc to log the error. Now just raise it again inside...

I think the OP is having problems with his application and not sql. In other words the 3.5 Million rows is too much for his .NET app. I suspect the...

What is the question? I am not sure where you are stuck. You built your proc to log the error. Now just raise it again inside your catch to have...

That looks correct. Did you try it? It might make things more clear if instead of calling RAISERROR yourself change the try block to something that will raise and error.

BEGIN...

edward_hall76 (7/25/2012)

---

because they want it to update the PONumber table with the total when they fill out the po so they dont have to go into the PONumber and put...

edward_hall76 (7/25/2012)

---

what would you suggest then. I have a table called accounts as well would you use just the ID number for that account that coursponds with that dept and...

edward_hall76 (7/25/2012)

---

The reason for account number being the line item is because each office has there own budget and they are broken into computer supplies, office furnture, copy supplies etc...

edward_hall76 (7/25/2012)

---

Thats working ok except if there is already a amount in the subtotal in the PONumber table then it doesnt add them together.

I also get a error if trying...