randyetheridge (9/23/2015)

---

Took some help from a friend but the answer turned out to be simple

isnull(cast([OriginatingLeadId] as VARCHAR(36)),'NA')

when checking for NULL in a uniqueidentifier field you have to cast it as...

Whenever I have to do this (convert Regular SQL to doubled-quoted SQL to insert into a @variable) I cut & paste the SQL statement to a new, empty, editing window...

I'm not letting SQL off the hook 😛 - it is...

Blimey! Wouldn't KEEP be the more obvious default choice (and NOKEEP the optional one)?

or @YesNo IS null)

I wish that SQL Server have a mode/flag/option that would moan about things like this ... on the occasions that they take hours to find the time...

Hadn't spotted that CHOOSE was added in SQL2012 ...

... nor that...

Indeed :-), and that is actually what the error message is saying of course:

"Conversion failed when converting...

I think it depends a bit on how complex your code is (I assume your example is a trivial example compared to the actual code), but I don't know for...

fabriziodb (9/23/2015)

---

delete insert is 2 operation, i think other way is most expensive:

1) insert the rows from parameter that are not in the table

2) update the rows that are both...

@erichansen1836

As I understand it you have a "full backup" mde when all users are our of the system, e.g. at end-of-business. But it is not clear to...

Dunno if this is relevant, but can you pre-sort the imported data into Clustered Index Key...

WayneS (9/22/2015)

---

In your ISNULL statement, you are building an empty string if the column is NULL. That is not valid for a UNIQUEIDENTIFIER data type.

DECLARE @t UNIQUEIDENTIFIER = ''

This will...

We do a few things to our databases that are released to Clients (i.e. our database is a 3rd party APP on their servers)

We keep all Sproc, View, Trigger, etc....

We have a filter index including WHERE MyKeyColumn IS NOT NULL on some of our FKey-supporting indexes - e.g. where we have an FKey on a User Defined Column which...

But I don't have a...