That would be because @id is an...

Excellent job posting ddl and sample data!!! I wish everyone would put that much effort into their posts.

You can accomplish this fairly easily using replace.

set @query = 'SELECT modeltrim_oemcode,category_name_natlang,standard_equipment_name_natlang, '...

Nope. Maybe I am being think but I don't get it. What are you comparing the store md5 results to? And not sure how that is demonstrating the issue you...

Ncage (8/10/2016)

---

Steve Jones - SSC Editor (8/10/2016)

---

I think this is really hard without specific data. Can you mock up an example of something that doesn't work that's exact?

I'd think that...

Brandie Tarvin (8/10/2016)

---

SQLRNNR (8/9/2016)

---

Brandie Tarvin (8/9/2016)

---

Sigh.

I am experiencing that sinking feeling one gets when one realizes an instance of SQL was installed without a sysadmin account.

To be fair, I don't...

Ncage (8/10/2016)

---

I have a column thats defined as nvarchar(256). I wish i could post the exact data i'm having issues with but i can't because its sensitive information. Anyways when...

Is there a question here? Or is this supposed to be informational?

No discussion about nested transactions would be complete without a reminder that they are really a myth and do not do what it seems like a real nested transaction should....

J Livingston SQL (8/8/2016)

---

I see Brent Ozar is using torrent for the Stack Exchange Data Dump...I would dearly like to get the data for a future project, but am quite...

Boris Pazin (8/4/2016)

---

Sean Lange (8/4/2016)

---

I can't speak for everybody but seeing a few of the tables definitions would go a LONG way in understanding what it is you are trying...

I can't speak for everybody but seeing a few of the tables definitions would go a LONG way in understanding what it is you are trying to accomplish here. I...

Ronnie Jones (8/3/2016)

---

Hello All,

I need to determine when a user last accessed a table in a SQL Server 2012 environment.

I have a few scripts that will tell me when...

Lynn Pettis (8/3/2016)

---

Jack Corbett (8/3/2016)

---

Lynn Pettis (8/3/2016)

---

Is the code I wrote here really that sophisticated, or is it that I have been doing this so long that for...

The actual plan wold be better but at 4 hours you probably can't generate one. 😉

It looks like tmpLCRollupList is a heap. That means there is no...

Let's start with a little formatting so this is more legible.

SELECT lc.DownLoad

,lc.AccountNum

,lc.PolicyNum

--, splitLC.SplitPolicyNumLmt

,splitLC.SplitPolicyNumLmt

,splitLC.SplitPolicyNumCA

,splitLC.SplitPolicyNumReins

,lc.LCDetailGK

,splitLC.PolicyInsuredLocGK

,lc.CbiId

,lc.LCAmtUSD

,lc.LCAplbtyCode

,lc.LCTypeCode

,lc.PerLocInd

,lc.PolicyLevelInd

,lc.LCQualifierTypeCode

,lc.LCFrequencyCode

,0 AS ProcessInd

FROM AIRGBS.vLCExtract AS lc

INNER JOIN AIRGBS.SplitLCLimits AS splitLC ON splitLC.AccountNum = lc.AccountNum

AND splitLC.PolicyNum = lc.PolicyNum

AND splitLC.DownLoad...