it looks like this data is coming from an excel spreadsheet that is casting everything as text, hence the scientific numbers and the bad data

maybe worth looking at adding a...

ok - this might be a stupid question - you want it as a number, but still keep it stored as varchar?

why ?

one of the key things and true DBA...

i'm 99% sure you can't restore master from 2005 to 2008

might I suggest you take a huge leap and go to 2019????

and to reattach the databases - use restore database...

cancer is truly horrible and I've had a few...

so many points in your post jeff that I resonate with -...

In a previous company, I once had a C-Level manager tell me that we were migrating to Oracle because we didn't have any Developers that understood set-based logic...

please don't start this - as much as I love food, i'm sick of it at the minute - i'm forced to eat nearly 5000 calories...

I drove through it once

(and PS Grant, you are our long lost mentor, I often wonder if my father wasn't either you or steve 🙂  - we know it's not brent, he...

do y0u have to use a delimited string?

if it's a proc that's doing this then can you pass a table value parameter in rather than a delimited string?

This whole MVP grind can be a serious grind. I love it, but I absolutely see how it can burn you out. Especially on the forums. Some days...

Brad pulled back as well. This whole MVP grind can be a serious...

I am not at all surprised to find a DBA love-fest going on in here. As usual, The Universe Will Be Saved From Stupidity If You Idiots Will Just...

sadly - this is my facebook profile picture

Now I am proudly waving flagbearer of the International Anti-RBAR Confederation. I still come here daily for the QOTD and occasionally jump into a discussion. But mostly I don't...