Card

Try this,

REPLACE(value COLLATE Latin1_General_Bin, 'X', '/')

Rod that entirely depends on your situation, if you have no particularly important ties to where you are and the ability to live without income for awhile it's definitely worth...

Pegasus

Just to clarify, are you referring...

GPO (4/4/2016)

I would have thought that's one reason why you put constraints...

GPO (4/4/2016)

We're talking about two different kinds of unique....

GPO (4/4/2016)

Well... kinda. I don't think I explained myself very well. My apologies. Incrementing integers CAUSE uniqueness. They don't...

Mutant

Then that's relatively simple,

SELECT * FROM #temp WHERE ValidFrom IS NULL OR (ValidFrom >= getdate() AND (ValidTo IS NULL OR ValidTo <= getdate()))

That's assuming that...

In all fairness there are perfectly valid reasons to do this,...

sp_executesql should be able to handle a NVARCHAR(MAX) so that shouldn't be the issue, it's likely one(or more) of the values you're trying to use to generate the sql has...

Can you try running it with simpler metadata in the table it's building the dynamic SQL from? If possible only 1 return row, that should make it easier to...

And what are the results from this?

PRINT @v_sql;

There's some pretty basic rules for formatting that I use that I guess I'm just so used to they don't add any overhead what I'm doing. But simple things...