These columns are new to the table (a week old), but this is the first time I'm seeing this. Nothing else has changed.

The columns are still decimal(9,2)

I've used Enterprise Manager and Query Analyzer, both show the same thing.

DBCC CHECKTABLE didn't return anything.

I guess I'll answer my own question. All you need to do is cast it to float.

create table a (num varchar(100) null)

insert into a

select '1.4634128977659954E-2'

select cast(cast(num as float)...

I can throw a little Russian into the mix, but let's enjoy the weekend.

Thanks for your replies.

Igor (But in ze Munich Circus I vas ze Incredible Nightcrawler)

I realize position doesn't affect anything and EM is not an option for me.

Here is a script I found that reorders columns in sequential order. I thought someone has the...

Ok, thanks...

I just found another link that seems to handle NULLs better. Can anyone validate that this is the right logic? Thanks again.

http://www.dotnetspider.com/technology/KBPages/716.aspx

Thanks to all that responded! Started building the process using NEWID().

I think this will work. I wanted to simulate shuffling and dealing hands.

I can assign a card to each number like this:

#1 = 2 of Hearts, #2 = 3 of...

Thanks for your replies. All solutions seem to work.

When you use DATEDIFF(dd,0,GETDATE()), what does 0 represent? When does it count from?

You may find this article useful.

http://www.15seconds.com/Issue/010308.htm

You can query the cubes using MDX and put results into a temp table. We have multiple stored procedures that query OLAP just like they would query regular tables. The...

rockmoose,

It's an excellent solution. I tested it and it seems to be working.

It took me a little while to figure out what (select count(*) + 1 from #scores s2 where...

Why does SELECT COUNT(*) take more I/O than SELECT COUNT(some_column) ? One would think it still has to step through each row to count.

I've used SQL DMO to control jobs from the ASP pages...Every time you would refresh a page a new instance of SQL DMO would appear in the process list. Eventually,...