TheSQLGuru (1/4/2016)

---

1) UDFs existed at least as early as SQL 2000: https://technet.microsoft.com/en-us/library/aa175085(v=sql.80).aspx

2) This article fails to mention an EXCEPTIONALLY important flaw (among many others that aren't covered such as preventing...

robert-819720 (12/30/2015)

---

Thank you so much Alan. A fascinating concept. I might be overly tired but just cannot figure out how to apply the concept to my situation. But will continue...

Luis Cazares (12/30/2015)

---

The following code should be removed for it to work.

SELECT CONVERT(date,[dates]) AS Dates

FROM DailyDates

OPTION (maxrecursion 0)

),

However, there's a major problem. You have a rCTE that counts which...

You can use the Quirky Update method discussed here: http://www.sqlservercentral.com/articles/T-SQL/68467/%5B/url%5D

That END statement will cause an error if there is not a BEGIN statement somewhere before it within the same transaction. I'll just assume, however, that you have a BEGIN...

You've come to the best place for people that are learning SQL IMHO.

Depending on what you are trying...

I'm guessing you would add this to the end of your query:

WHERE Parent1_Gender = 'F' and Parent2_Gender = 'F'

Eirikur Eiriksson (12/28/2015)

---

Alan.B (12/28/2015)

---

The most common/easiest to fix mistakes:

Someone beat me to it but NOLOCK table hints are the #1 mistake I have seen. I would go so far as...

The most common/easiest to fix mistakes:

Someone beat me to it but NOLOCK table hints are the #1 mistake I have seen. I would go so far as to say it's...

The AD account is a member of an AD group that gives 'datareader' to this particular database. Would this be enough to execute the SP's that it does not have...

Giorgio Vidali (12/17/2015)

---

One final thing I'd like to ask is.... considering that I will have to get more and more familiar with XML data... what is the best resource to...

I'm doing my first adjacency list to nested sets conversion and building out a rather complex hierarchy table for a new project (something I've been anxious to do since I...

Eirikur Eiriksson (12/16/2015)

---

Alan.B (12/15/2015)

---

another way...

DECLARE @x XML = '<?xml version="1.0" encoding="UTF-8"?>

<StaffingOrder>

<OrderId validFrom="12/31/2015" validTo="12/31/2015">

<IdValue>JNJNJP00040440</IdValue>

<Status>Submitted</Status>

</OrderId>

<StaffingPosition>

...