This works without calling functions

DECLARE @t table (Col1 varchar(50))

INSERT @t

values

('immediate due 14,289.00'),

('04/15/15 5,213.00'),

('05/15/15 5,213.00'),

('06/15/15 5,213.00'),

('07/15/15 5,213.00'),

('08/15/15 5,213.00'),

('09/15/15 5,213.00'),

('10/15/15 5,213.00'),

('11/15/15 5,210.00')

UPDATE @t

SET

col1 = REPLACE(REPLACE(Col1,'immediate due','immediatedue'),',','')

SELECT

DueDate=

CASE

WHEN LEFT(Col1,CHARINDEX(' ',Col1)...

select job_order

into #trig

from deleted

UNION ALL

Select job_order

from inserted

end

SELECT job_order FROM #trig

drop table #trig

sorry,

make table1 come after FROM and LEFT JOIN to Table2

use a LEFT JOIN

and use ISNULL(,0) for your sum and count

What about

right('0000' + Docket,5)

Did you check that that the SP was created in the correct database?

But they wouldn't be 1 until after their BDay

or you could just

DECLARE @DOB DATETIME

SET @DOB='01/01/2013'

SELECT FLOOR((DATEDIFF(DD,@DOB,'01/01/2014')+1)/365.25)

This seems to work

DECLARE @DOB DATETIME

SET @DOB='9/19/2000'

SELECT FLOOR(DATEDIFF(DD,@DOB,GETDATE())/365.25)

Right-click the bottom right cell of the Matrix in Layout mode and add column.