You've already got an example on how to parametrize your dynamic sql, but you kept using the string concatenation. That's a basic NONO in my ruleset.

Why do you want to...

Calculus

sgmunson (12/9/2016)

---

Luis Cazares (12/9/2016)

---

I'd suggest that you read Thom's comments. However, this is a shot in the dark to show what you might need.

SELECT bk.CustomerNumber,

...

I'd suggest that you read Thom's comments. However, this is a shot in the dark to show what you might need.

SELECT bk.CustomerNumber,

cal.Day_Uid,

...

rgp151 (12/8/2016)

---

Yeah, I can't figure this out. But it is the case that if I simply insert the result of the nested query into a temp table first, then select...

Would a FULL OUTER JOIN help?

I changed your sample data to get some results.

-- sample data

DECLARE @table1 TABLE (id int identity, content int NOT NULL, primary key(id, content));

DECLARE @table2 TABLE...

You linked to this thread.

I'm confused. Do you want to have a default or a computed column?

For a default, you might need a trigger to handle that option.

I can't help feeling sad when I remember this. I never met him in...

The description doesn't begin to describe the real problem.

Without at least having the full query and actual execution plans, there's no real advice that can be given here. I agree...

Implosion

What Thom said, just don't use varchar(MAX) to optimize the resources. 😉

Just keep the length of the longest type (in this case 1).

CREATE TABLE foo (

id INT IDENTITY(1,...

I don't find the confusing part. Or maybe I just noticed the 3 hints to the correct answer.

I need to ensure the databases are backed up while minimzing load on...

There's no direct code, but this should help.

DECLARE @Datetime datetime = GETDATE();

SELECT @Datetime, CONVERT(char(10), @Datetime,101) + STUFF( SUBSTRING( CONVERT(char(100), @Datetime,109), 12, 15), 10, 4, ' ');

Here's an approach similar to Phil's, but both will fail if the value starts with '0'.

DECLARE @test1 VARCHAR(10) = '16-17';

DECLARE @test2 VARCHAR(10) = CAST( LEFT( @test1, 2) - 1 AS...