I have to agree with John here. Don't waste your time learning more about cursors. Take what you have written and develop a set-based solution to the problem....

Please tell me that you ARE NOT using this cursor-bassed code in a production environment and that it is simply for your own edification.

sjsubscribe (7/28/2009)

---

You would certainly be considered a disruptive force in an orderly society that protects freedom of speech. Here...

mtucker (7/28/2009)

---

Lynn Pettis (7/28/2009)

---

Unfortunately, rational thinking isn't the end all in solving problems. Many times I have found solutions. not through rational thought, but through inspiration and imagination both...

mtucker (7/28/2009)

---

camassey (7/28/2009)

---

Whoops - didn't mean to kill the reply - sorry about that.

@mtucker, I don't think any of these qualities necessarily comprise maturity in and of themselves, but...

What did you get when you tried it?

When I ran this:

DECLARE @Var int

IF @Var IS NULL

SELECT 'It Works'

ELSE

SELECT 'Nope'

it returned It Works on my system at home.

Are you running this from BIDS in debug mode? If so, on your desktop system or the server? Is the file located on you desktop or the server?

torpkev (7/28/2009)

---

I believe you can try:

SELECT SERVERPROPERTY ('edition') as [Product Edition]

64 Bit should say Standard Edition (64 Bit)/Enterprise Edition (64 Bit) in the text, 32 bit will just say Standard...

Youri S. Pikulin (7/28/2009)

---

Yes, I have tried this.

The copy size is about 80 MB, even with an (empty) ntext column. So, this is a work-around (copy, drop original, rename copy)....

Now you added another table to the mix. Is Table2 used else where in this procedure?

Actually, the error message isn't really helping here. The real problem is that we can't see your package to determine what may be wrong. Start where Alvin suggested...

Something like this?

select

ISIN,

Ticker

from

#TestTab

where

len(Ticker) >=5

and (Ticker like '% %' or Ticker...

Might be E3L (or ETL, but then that might be cofused as something else), English as 3rd Language; as opposed to ESL, English as Second language.

I'm sorry but the second INSERT into Table1 has me totally confused. First, there is a typo as both instances of Table1 are aliased a. Second, it doesn't...

Okay, that's your data, but what does the table look like, what is the output from the query supposed to look like?