It seems to me that your code is doing exactly what you want it to do, so where is the problem?

Anyway, if you have some sort of nullophobia (

Here's another (similar) way:

declare @time nvarchar(20)

declare @timefloat float

declare @minutes int

set @time = '211:34'

set @timefloat = replace(@time,':','.')

set @minutes = floor(@timefloat) * 60 + (@timefloat - floor(@timefloat)) * 100

Regards

Phil

My understanding is that scheduled SQL job steps run as transactions, ie they either fail or succeed. Partial success is not a possible outcome - as it appears to...

I agree with Osoba - have played with Round, casting to decimal etc and nothing works elegantly. If you do not change the datatype of the column in the...

Hi Jana

If the filenames are always the same, why not just create 12 separate imports that run one after the other as part of the same DTS package and use...

Though 'retruning' is a great-sounding word, I think you mean returning?

Great question - I'm assuming that you're performing an insert to a table...

Yuk! If no one has anything already written, I will help you out. Presume you're planning on using VBA?

Regards

Phil

A thousand records is hardly a spike for most hardware running SQL Server. What problems are you experiencing? Do you actually mean 'terminate', or just 'freeze' and perhaps...

Not 100% sure what you're after here. I presume it's something a bit more complex than just

select fld1, fld2, fld3, fld4

from tbl1

where fld1 = 123 and fld2 = 'abc'...

Hi Mitch

Sounds like you are trying to insert an explicit value into a field that has been designed to assign its own values automatically on insert (possibly an auto-incrementing primary...

In what format do you want the results presented? Random order of numbers 1-52 in a table?

Regards

Phil

This looks deliberate on the part of Microsoft.

This link looks relevant

Regards

Phil

Yes, this can be done. Check out OBJECTPROPERTY in BOL, specifically the CnstIsDisabled property name.

Phil

Strange. 8152 = "String or binary data would be truncated," which suggests some sort of update failure to me (eg if you are trying to update a 20 character...

This doesn't sound good. I tried doing a Google search on

"hang module hungapp" mmc

and still not getting very far. The evidence seems to implicate hardware and/or some...