Don't use functions in a WHERE clause if you can avoid it, as they destroy "sargability".

In this case, just directly check each variable for NULL or a match, as...

I have meant 200 rows of code

Column1,

Column2,

----

Column200

I appreciate SSMS will generate it for me, yet again, I was hoping to have neater solution, something like one would do in...

This is how I handle variable inputs

DECLARE @ProjectID   int            = 300;
DECLARE @ProjectName varchar(100) ...

Thanks. That works fine. But the one issue that remains is there is a duplicate value for Bids in the NF is duplicated and there should be only one....

Look at the progress we've got in SQL over the years!

what used to be 13 years ago a short inline formula using system functions and integer arithmetic is...

Duplicate post

https://www.sqlservercentral.com/forums/topic/convert-seconds-to-minutes-2#post-3672679

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