You're welcome. You will still have to resolve the lack of decimals places you want to display.
Quick and dirty way of doing it - see example below :-
DECLARE @a INT,
@b-2 INT
SET @a = 22
SET @b-2 = 7
Best way of doing it is to use an appropriate datatype in the table you create.
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx