Or further, to be fool proof, modify your UPDATE statment like this

update #test

Set Amount_Sterling =

Case when local_amount is null then cast(amount as real)

else cast(local_amount as real) / 100.00

end

Type-Cast...

LOL, Lutz 😀

In the update statement, divide it by 100.00 .. THen you wil get the 2 point precision..

Hey there, the following code will get you what you want

NOTE : This is not my code, if found it somewhere in this forum; can't remember who coded it. So...

Wow, nice to hear that my code helped you..Pleasure!

Yana, here is the code for you.. But i recommend yout to provide your full table definitions etc etc so that we can give u the best possible code..

IF OBJECT_ID('TEMPDB..#SomeTable1')...

jwellington (4/28/2010)

---

Your answer did get part of the way, but what I need is the detail you have provided as headings to the columns in the view, and then to...

You cant control it that way for INT data-types... Do this instead - Make the column INT, create a CHECK CONSTRAINT on that column to allow only integers from 0...

My poor soul, got lot of free time these days and i am utilizing it to LEARN..:w00t:

Now that said, i have given my time in scripting the code for...

Hi Buddy,how about you going through this following article and helping us help you?? 🙂

CLICK HERE FOR FORUM POSTING ETIQUETTES - JEFF MODEN[/url]

When u do so, i am sure a...

A year will constitute 12 months. And thats the reason i have done a little tweak to my function. If my code should function as exactly the same as you...

Hey Jus, thanks for posting the DDLs..

Here is a gift for you. This does not perform those 12 SELECT statements, but it still does what u wanted..

Here is the CODE..

ALTER...

ps. (4/27/2010)

---

ColdCoffee (4/24/2010)

---

Nice thread, imho!!

Me born in , une fois par le territoire français (once a french territory) PONDICHERRY, in INDIA! 😉

And now working in chennai (again in INDIA) for...

You're welcome Lee!!

FROM BOL

All base tables referenced by the view must be in...