it's not actuallt converting anything when it anything over e-5. or under however u want to look at it.

I've run into performance issues w/ windows function over time. I've stopped using them alltogether. that's just my 2 cents

select cast( '1.550e-6' as float)

?????????

returns 1.55E-06

????????

shouldnt it return .00000155 ?

i removed the hint. I still dont understand a scenerio where a sleeping spid would block another. I was under the impression that is it's in sleeping mode it is...

Whats stopping the first query from clearing. It's in sleeping mode and doesnt appear to be doing anything. It's doing a clustered index seek and does around 3 reads. What...

thanks guys. The selects is a proc in project server. So i hesitate to change it however at this point i'm not sure if i have any other option. Here's...

lol. I didnt create this table and assumed the used flag was a big. the table has several more cols. I just pulled ones that matter for this discussion and...

i'm thinking i'm going to wrap all three updates in a tran and have some sort of retry logic if all three arent updated successfully

Closing the loop here. I had to knock the dust off my c# to create the below. however it worked for me.

The problem it solves: The issue is i...

i suppose i can write an exe to search for the data issue and replace the double quote w/ two double quotes. its a band aid though

running into this same issue. I read that 2012 could handle column dilimiters embedded in a text however It's not working for me. When i preview the data it...

i see now that my logic is flawed when i assumed the these dynamic view hold what i want consistently. Apparently the only real way for me to get what...

so at this point for whatever reason it appears there are proc calls that are happening that arent getting returned dm_exec_procedure_stats nor dm_exec_query_stats. Either that or the object id...

dropped the ball on this one for a bit however it has loomed it's ugly head again. I run the below and it isn't returning a proc call that took...

excellent thank u