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))...

No can do.  The obvious enhancement would be to alter the column to DECIMAL (10,4) or greater.  BUT this has ripple effects downstream to additional receiving columns also defined as...

It's the 1st Task.  I mirror'd a solution I found on this forum:

http://www.sqlservercentral.com/columnists/tdavid/moreportabledtspackages.asp

My pkg runs DynPropTask #1 1st -- issuing a SELECT SERVERPROPERTY('SERVERNAME')

It runs fine on my QA Server.  When I...