Of course %-%-% is different from (%)%-% so....

DECLARE @FIELDNAME VARCHAR(50), @sql VARCHAR(1000)

SET @FIELDNAME = 'phone'

SET @sql = 'SELECT ' + @FIELDNAME + ', CASE LEFT(' +...

I think I understand your issue with @NEWPHONE name, however SET @NEWPHONE = SUBSTRING(@FIELDNAME,2,3)+SUBSTRING(@FIELDNAME,5,3)+SUBSTRING(@FIELDNAME,9,10) is always going to set a value based on the value of @FIELDNAME.

How about...

DECLARE @FIELDNAME VARCHAR(50),...

Dynamic SQL...

DECLARE @FIELDNAME VARCHAR(50), @NEWPHONE VARCHAR(50), @sql VARCHAR(1000)

SET @FIELDNAME = 'phone'

SET @NEWPHONE = SUBSTRING(@FIELDNAME,2,3)+SUBSTRING(@FIELDNAME,5,3)+SUBSTRING(@FIELDNAME,9,10)

SET @sql = 'SELECT ' + @FIELDNAME + ', ' + @NEWPHONE

SET

More or less...

DECLARE @minutes INT

SET @minutes = 2000

SELECT @minutes / (60 * 8) AS days, @minutes % (60 * 8) / 60 AS hours, @minutes % (60 * 8) %...

Are you sure you've got the right section of code?

Maybe I'm reading this wrong, but you want build a date from a date and a time and insert into a datetime field.  So just do one more conversion to...

Assuming I understand what you're trying to do, Merge Replication is the only way you can have changes on the subscriber replicate back to the publisher.

I don't think there's a good way to join tables on dates, ignoring times and utilizing an index.

I'd look at alternative solutions if this is something you'll be doing regularly. ...

This should help...

http://support.microsoft.com/default.aspx?kbid=246133#XSLTH3137121122120121120120

Check the job history for failures or notifications.  They might provide some info.

Anti virus software may be scanning the file at the same time SQL is trying to delete the file. ...

You can do it in VBScript...  Here's a sample script.  Bad news is I hard coded the column names, but you could modify to build dynamically.

Const adOpenStatic = 3

Const adLockOptimistic...

Is your DB in Simple recovery?  If so, no transaction log backups aren't allowed.

Check the transaction log backup job history.

How about anti-virus software?

I think Allen was referring to the fact that you set up retention periods for transaction files and backup files  seperately within the maintenance plan.

Did you check the job history?

You can almost always eliminate a cursor by using a WHILE loop.

In a case like this I've used a temp table for the parent item and create a identity column,...