I am not...

Cursors are notoriously bad for performance and should be avoided except for maintenance tasks if at all possible. I suspect you don't need a cursor for this at all. If...

Can you try to explain a bit more clearly what you are trying to do? Take a look at the first link in my signature about best practices.

erics44 (9/20/2012)

---

Luis Cazares (9/20/2012)

---

At this moment, I wish I didn't post any response.

Your answers have been rude to someone that is trying to help you by giving a good advise.

This...

Luis Cazares (9/20/2012)

---

At this moment, I wish I didn't post any response.

Your answers have been rude to someone that is trying to help you by giving a good advise.

This might...

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

But same issue of lack of details. I guess Luis has...

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

erics44 (9/20/2012)

---

Sean Lange (9/20/2012)

---

But same issue of lack of details. I guess Luis has his mind reading...

erics44 (9/20/2012)

---

you...

Take a look here. It should have everything you are asking about and then some. http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/%5B/url%5D

F8R (9/20/2012)

---

Hi,

I have two Table, Order and OrderDetail

Create Table [Order]

(

Id BigInt Identity(1,1) Primary Key,

OrderTotal Decimal(22,2) Not Null

)

Create Table [OrderDetail]

(

Id BigInt Identity(1,1)...

But same issue of lack of details. I guess Luis has his mind reading cap on today.

This looks a lot like your other question. http://www.sqlservercentral.com/Forums/Topic1361875-391-1.aspx

On neither of these of posts have you provided anywhere near enough detail for anybody to do much but try to decipher...

Take a look here. http://www.connectionstrings.com/%5B/url%5D

This site has connection string details for just about everything.

Simply repeating the question is not helping me understand what you are asking. It seems the English is not your first language, no problem, we can work with that. Can...

ScottPletcher (9/19/2012)

---

Sean Lange (9/19/2012)

---

SQLKnowItAll (9/19/2012)

---

Here's some sample code:

CREATE TABLE #test(id int identity (1,1), filler VARCHAR(1))

GO

INSERT INTO #test(filler)

SELECT 'a'

GO 5

DECLARE @sql VARCHAR(150)

SET @sql = 'BEGIN TRAN SELECT * FROM #test ...