What do your queries look like? Could you post one or two of them?

Alvin Ramard (5/20/2009)

Lynn Pettis (5/20/2009)

Worry not young...

Worry not young padawan, with yours mine...

Glad you resolved the problem I am.

Alvin Ramard (5/20/2009)

Lynn Pettis (5/20/2009)

Alvin Ramard (5/20/2009)

Luke L (5/20/2009)

Alvin Ramard (5/20/2009)

Jack Corbett (5/20/2009)

I have to admit...

In report builder, you may want the function TRUNC instead. Again, though, you will find all of this in BOL.

Books On-Line should be your next best friend (with SSC...

Have you looked up the ROUND() function in BOL yet? I'm pretty sure that this may help you solve your problem.

Alvin Ramard (5/20/2009)

Luke L (5/20/2009)

Alvin Ramard (5/20/2009)

Jack Corbett (5/20/2009)

I have to admit being disappointed you didn't...

Jack Corbett (5/20/2009)

I have to admit being disappointed you didn't say something like:

"Use the force well...

Jack Corbett (5/20/2009)

I have to admit being disappointed you didn't say something like:

"Use the force well...

Examples:

select 1.AColumn :

AColumn

---------

1

select 1.0AColumn :

AColumn

---------

1.0

Now do those with a space before AColumn, you will get the same results.

Now, for those of you waiting impatiently for the explaination, here it is.

SELECT 1.Acolumn is equivalent to SELECT 1. Acolumn. (there is a space between the . (dot) and...

YEA!!!! I Figured it out with a little help from a co-worker!!!!!

Try this and look at the table created:

SELECT

30.AString

,50.AnotherString

,10.SomethingElse

into dbo.TempTable;

select * from dbo.TempTable;

That is interesting. I have no explanation.