Look at the third example above. That is exactly what you need. Or if it is just a single table just execute an update statement with the same where clause...

That isn't how you want to use Exists.

Take a look at these examples. The last one is most likely what you are after.

UPDATE TABLE tablename

SET columnname = 0

WHERE EXISTS (select...

Are talking about using an xml column to hold your data and using sql to parse it into columns when you retrieve it?

Is PLU_NUM a udf in your system?

Cast does not change the stored value of any data (unless you using it in an update statement). Perhaps if you could provide...

@baabhu - You do realize this thread is almost 3 years old?

@baabhu - You do realize this thread is almost 3 years old?

You're welcome. Glad you were able to solve it. It is customary around here to post your solution (at least something close as it is not always possible to post...

Can you just exclude those in your where clause?

and MyFieldWithNull IS NOT NULL

Or did I miss the point of your question?

well you really have two questions rolled into a single post so for the first question about rounding, you are using implicit conversion which will strip trailing zeros.

Try this instead:

select...

In fact, there is a thread from today about this very topic. Take a look at Craig's post here. He gives a great pseudocode skeleton. Read the rest of the...

krishusavalia (8/25/2011)

---

Can I create trigger on Table ?? I mean logic that check that any update statement occur on the table or not and if occur then insert old...

I think varchar would be fine with one possible exception. DateTime. If you are only going to use this for reporting it might be ok as a varchar but i...

If you get stuck feel free to post back what you have and I will see if we can get it dialed in.

Ninja's_RGR'us (8/25/2011)

---

Grant Fritchey (8/25/2011)

---

SQLRNNR (8/25/2011)

---

GilaMonster (8/25/2011)

---

SQLRNNR (8/25/2011)

---

Really, this is a public forum......

Here is a skeleton psuedocode of what I was thinking.

declare @EngagementYear int

set @EngagementYear = [YourValueHere]

--paste contents of file 0 here

GO

--paste contents of file 1 that creates select_EngagementYear

--create procedure....

GO

exec select_EngagementYear @EngagementYear

GO

drop...