Why are your seconds stored as strings? Convert them to integers, then this should do the trick.

SELECT  *, [HH-MM-SS] = CAST(DATEADD(SECOND, l.Seconds, 0) AS time(0))
FROM ...

Sory @province is not 2 chars it's 1 char. That's the business rule i was asked to do so. 1 char from province 7 chars from Country with seq...

You can create a tracking table and use a Quirky Update in a proc to do this

CREATE TABLE dbo.CountryProvNumber (
    Country   ...

For performance reasons,...

First just to be clear I am not a developer.  I am just an accountant who knows enough SQL to get myself into these predicaments 🙂  So please be...

You can add GROUP BY to Piet's code to ensure that you get distinct data for each EID and BID.  Also change the 3rd parameter of STUFF from 1 to...

are you looking for this?

update #a
set a = case
when a = 0 then NULL
else a 
end,
    b = case
when b = 0 then...

So here is a quick sample of how the DELETE can have unexpected results.

First, the data to work with

IF OBJECT_ID(N'tempdb..#DestTable', N'U') IS NOT NULL
BEGIN
  DROP TABLE...

I haven't used the MERGE statement since I got burned many years ago doing a

WHEN NOT MATCHED BY SOURCE THEN DELETE

As it turns out, you end up...

DesNorton,

You mentioned:

The N'xxx' is an indicator that the contents between the quotes is unicode (which is what the function is expecting).  The N'U' does in...

DesNorton,

I see what you are saying now.  I was reading it wrong.  But what about my second post where SQL says 'CK_isActive' is not a constraint?  I...

DesNorton,

I see what you are saying now.  I was reading it wrong.  But what about my second post where SQL says 'CK_isActive' is not a constraint?  I don't understand...

Remove the where clause.  then it does all products

This is a simple SUM with GROUP BY

SELECT    t.BoughtDate
        , Apples  = SUM( t.BoughtApples )
 ...

Edit:  I ran this part of the code only to see if I can isolate the problem:

ALTER TABLE Costpoint.ProjectCodes
DROP CONSTRAINT CK_isActive;

and I got this error message: