How about posting the entire SQL script or procedure that you are have difficulty with. From what you have posted we really can't give much of an answer.

You do know that you are responding to an 8 year old thread.

Stephanie Giovannini (8/6/2015)

---

CREATE TABLE #t (a int);

GO

CREATE PROCEDURE dotest

AS

UPDATE #t SET a = 1 WHERE 1 = 0;

RETURN @@ERROR;

GO

EXEC dotest;

SELECT @@ROWCOUNT;

If you run the above, there is a single result...

Tac11 (8/6/2015)

---

When I run below query I get 3 columns, but when I try to add table name

ind.object_name (object_id) it's giving me an error "Ambiguous column name 'object_id"

How do...

Luis Cazares (8/5/2015)

---

Kutang Pan (8/5/2015)

---

Hi Luis,

Thanks for that. I've started preparing a list of some Q/A but i can't find a nice one about dynamic sql writing. I would like...

OMG. It isn't just here, it's every where.

The preliminary schedule for the Pride of the Rockies Soccer Tournament was published today. I sent an email out to all...

Ed Wagner (8/5/2015)

---

Lynn Pettis (8/5/2015)

---

Sean Lange (8/5/2015)

---

GAH!!! Sometimes I hate having to work with so many different versions of sql all the time. I have been beating my head against...

Sean Lange (8/5/2015)

---

GAH!!! Sometimes I hate having to work with so many different versions of sql all the time. I have been beating my head against the wall trying to...

GilaMonster (8/5/2015)

---

jasona.work (8/5/2015)

---

GilaMonster (8/5/2015)

---

Snippets and a whole pile of script files saved in DropBox and on a creditcard-shaped flash drive (which I need to update).

And to get back on topic:

"What...

Haven't done it myself, but you should look into query notification.

You should post how you resolved your problem. It could help others in your position.

Reading books alone isn't going to help you become an expert. In addition to reading books, you need to put what you read into practice. This means at...

Too bad it would mean moving. I like it here in Colorado Springs and it would mean giving up some things I am involved in outside of work that...

Couldn't find anything that says ISNULL or TINYINT are being deprecated.

Okay, someone wanted a loop, I thought I'd toss out something else, just not quite the complete answer they were looking for. Let's see if they can take the...