This works

SELECT

CONVERT(decimal(20,6),Column2)

FROM ....

WHERE column1 <> 'abc'

Lowell's suggestion would work fine for this. Can you post up a more realistic version of your query? There are ways to simplify complex conditional logic. Use a tvf if...

I actually need to pass multiple parameters so CASE logic would probably get really dense. I am going to look at a multi-statement table-valued function.

I will be joining multiple tables...

Check you max server memory configuration. This is probably entirely coincidental but these error messages seems to have gone away for me after I increased my C drive space, it...

Thanks, interesting. I wouldn't have thought to use cross apply.

I agree on the database shrinking but I with limited DBA resources available the standard SQL server maintenance plans are in effect.

Restated the instance but the restart failed

32(The process cannot access the file because it is being used by another process.)

D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf...

Also the first occurrence of the 'Backup, file manipulation operations..' error was when the blasted maintenance plan attempted its weekly shrink.

Source: Shrink Database Task ...

I am seeing this in my logs.

I wonder if ConnUpdateStartExecutionDate is the process which updates the next run date, it failed and thus my next run date was in the...

I took a screenshot before deleting. Attached.

I deleted and recreated the schedule and its running fine now. It may have been my account nearing its password expiration but I have other jobs with the same account...

I need help in writing a job description for a senior administrative DBA. Can someone suggest an appropriate forum on SSC.com where I can do this?

Multiple jobs will give you greater flexibility if you need to rerun a job or change the schedule. If the procedures are closely functionally related I would create a job...

Thanks, this definitely set me in the correct direction.

The JOIN using BETWEEN is what I was missing. I started thinking about using a tally table but that was over complicating...

You can use OPENROWSET to do ad hoc distributive queries if the remote server is configured to allow this.

http://msdn.microsoft.com/en-us/library/ms187569.aspx