And I just logged in to respond to your original message! 🙂

How can we resolve this issues without changing any code?

Your options are limited.

Reducing the length of one or more of the underlying table columns is the best idea that comes...

That's how...

I get that error when i run my code against a very large table. Most Prod_IDs have two dashes. I want to pull the value between the dashes.  This...

• This reply was modified 7 years, 1 months ago by Phil Parkin.

SELECT ...

FROM ...

WHERE @SomeTime >= StartTalk AND @SomeTime <= EndTalk

Try this

DROP TABLE IF EXISTS #SomeTable;

CREATE TABLE #SomeTable
(
    Id INT
   ,EventId INT
   ,A VARCHAR(20)
   ,B VARCHAR(20)
  ...

There is an option, but it's well...

Can you briefly explain why this is required?

And if there are three rows of source data, what do you want to see?

@Phil Parkin When you say put the source code into the project, do you mean the dll?  They exist in the assemblies folder.  Or do you mean the actual...

You need to put the source code for the assembly into your database project. It is part of the build.

If start date is 1/1/2019 and end_date is 5/5/2019 and attended_day is Monday, which date should be used?

As you have no access to the source database and no way (in code) of identifying rows which have recently been added, modified or deleted, you are in a very...

Did you also run

EXEC sp_configure 'remote access', 1

GO 

RECONFIGURE ; 

GO

Presumably, you mean a run-time syntax error, because I see no other syntax error there?

Which specific command generates the error?

Can the select @user part of the query ever return more...

If the  question was just to convert union into join - I would have gone with full join with coalesce function -though this will not work in the view...