The NOLOCK hint is one that many people don't fully understand. It is usually not a good idea to use when accuracy is important. A view is probably not a...

Not exactly sql server related but this made me chuckle.

for (int i = 0; i < 1; i++)

{

pIntId = pageID.InnerXml.ToString();

}

Perhaps this could be simplified? :w00t:

jasona.work (7/27/2016)

---

Considering the latest response in that topic, I have an...

Good luck. Perhaps if your post was a little more cordial and less demanding we could help. Maybe...

I have no words...

ajspencer (7/27/2016)

---

Hi Luis, Thanks for responding so quickly. I tried using top 1 however it didn't return the results expected. I've attached a *.png file to show what the data...

ajspencer (7/27/2016)

---

Hello,

I need some assistance with a code. I am trying to return the APPL_CURRENT_STATUS where the APPL_CURRENT_STATUS_DATE is the max(APPL_CURRENT_STATUS_DATE)

SELECTAPPLICANTS_ID,

...

SQLRNNR (7/26/2016)

---

Jack Corbett (7/26/2016)

---

Apparently the person I'm going to be interviewing shortly has access to and knows how to use DBCC TimeWarp since they started their current position...

Jack Corbett (7/26/2016)

---

Apparently the person I'm going to be interviewing shortly has access to and knows how to use DBCC TimeWarp since they started their current position in...

Awesome job posting ddl, sample data and desired output. I have been staring at this for several minutes and I can't figure out the rules here at all. A join...

TomThomson (7/26/2016)

---

Interesting question, but rather badly put together - it could have been a good question if it had simply included a statement saying that the four statements are executed...

BLOB_EATER (7/26/2016)

---

Hey guys I was wondering if someone could confirm if the experiment that I am doing below is what one would expect from enabling TDE:

Before enabling TDE I would...

There is certainly some potential issues with concurrency when using persistent tables to hold values that are only relevant for a given run. I certainly did not dig through all...

drew.allen (7/21/2016)

---

Sean Lange (7/21/2016)

---

drew.allen (7/21/2016)

---

Get rid of the ISNULL altogether. FOR XML automatically discards null expressions unless the XSINIL directive is specified.

SELECT DISTINCT STUFF(

(SELECT ', ' + t2.Name

FROM #Temp...

drew.allen (7/21/2016)

---

Get rid of the ISNULL altogether. FOR XML automatically discards null expressions unless the XSINIL directive is specified.

SELECT DISTINCT STUFF(

(SELECT ', ' + t2.Name

FROM #Temp t2

where t1.ID =...