SELECT DISTINCT so.name FROM sysobjects so INNER JOIN syscomments sc ON sc.id

In Visual Studio LAYOUT mode, click the field you want to edit.  Viewing the PROPERITES pane, in APPEARANCE, look for the FORMAT setting.  Type a 'd' into the setting.

convert(decimal (5,2),(sum( datediff (hh,DateCompletedByResearch, ReadyOrShippedByFulfillment))/ 31))

Resolution -- the concatenation of VARCHAR and INT together caused the error.  I was able to resolve this via the use of the "str" implicit conversion.  thanks "DUDE".

SET @sql1 = 'Update c_account SET MSA_BB_FootNote ='+Char...

neither of these suggestions were syntacticly correct nor did they work..

Just ran into a slight glich ---

When the same person updates the row 2 times in succession, won't the 2nd update use SUSER_NAME?  We'd need it to continue to use...

PW -- pure genius.... If I were your boss I'd give you a scholarly bonus..

thanks -- that worked.

Almost there... Using your example join of the Virtual tables, I've prepped sample DDL & SQL for use here.  In the following SAMPLE, TEST 1 works fine but TEST 2...

The VB.NET application passes the variable values to a STORED PROC.  The proc performs the UPDATEs.

thx -- this worked perfect... (now I need a system table housing DTS package contents in text format) !!!!

This worked:

DECLARE @t_schema varchar(500),

   @t_name varchar(256)

DECLARE c1 cursor static for

 SELECT Name, 'DBO' FROM sysobjects

  WHERE xtype = 'U' AND name LIKE 'Rich%' --AND datediff(day,crdate,getdate())>400

   OPEN c1

   FETCH NEXT FROM...

Error:

Msg 214, Level 16, State 2, Procedure sp_executesql, Line 10

Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.

All I want to do is DROP a table dynamically (using a CURSOR...

Got it..  I needed to ALTER TABLE DROP CONSTRAINT then ALTER TABLE ADD CONSTRAINT

ALTER

TABLE [dbo].[TAB_a] DROP

Points well taken.  There's absolutely no way to fit a DEC (10,4) into a DEC (9,4) without distorting the value.  What I wound up doing was implementing a predicate to...

I think I'll try this:  SELECT CAST(-102613.5000 AS DECIMAL(9,3))...