Create Foreign Key Relationships

What have you tested ?

This can be an option:

; with cteHighestDate as (
Select PatID
, case Name4 when 'None' then 
case Name3 when 'None' then 
case Name2 when...

Not my call

• I'm still stuck with a couple of SQL2005 instances because some softwares prevent upgrading the database end of the system because they use sql server systems stuff that is...

Statistics !

Knowing the actual value you are looking for versus "well ... there will be a value overhere, but at this time I cannot say which" makes a ton of...

Since you cannot share the full DDL, can you strip it down to key, onemorecolumn, the denied column and see if the problem also manifests itself in that situation.

Maybe then...

open a support case in your azure subscription.

You need to grant the sql server...

Can you provide usable DDL of your tables + indexes + views + test data + the failing query?

How to post code problems

Interesting .... you must have pushed to hard to educate.

Such a shame ... especially when someone is willing to fix...

and some times it even throws in a right outer join ( in the mix of LOJ s )

I have noticed some "nested joins" some times can have a positive...

• You need to provide access to the target share or folder

  • to the sql agent service account

OR

<li style="list-style-type: none;">

• to a sqlagent proxy account ( and have...

Every once in...

"...gamedate nvarchar..."  ? Really?

Why aren't you using the correct data type Date / time / Datetime2 ?

Those come with a couple of advantages:

- validation

- calculation/conversion options

- small space consumption

-...

Every once in a while,...