Sound

Episode VII is too dependent on nostalgia. Most of us were there to see what happened with beloved characters from the original trilogy and identified lots of similarities with the...

Jacob Wilkins (4/26/2016)

---

John Mitchell-245523 (4/26/2016)

---

Steve Jones - SSC Editor (4/26/2016)

---

Phil Parkin (4/26/2016)

---

As a general rule, it's better to put IsNulls inside Sums rather than outside. This avoids the warning message...

You might need to use a recursive CTE if you can nest more than one level.

WITH postmeta AS(

SELECT *

FROM #postmeta

...

Are you able to change your database design? This design will give you nightmares and will also cause poor performance. Please consider this before building additional functionality on this system....

I remember that I was born in the 80's 😀

I only remember the Friday...

Does this gets you what you need?

SELECT

QueryID,

DatasetID,

ISNULL (SUM(mm.XMLResults.value ('(./MM)[1]','varchar(100)')),0) AS MEDICAL_MM

FROM OVT_RESULTS

CROSS APPLY...

What happens when there's the name of an object but it's not referencing the object? Or when it's commented?

Getting object names is easy. Validating that the objects are actually used...

ishaan99 (4/26/2016)

---

Theres dependency on DBA team to get the database restored to point of time recovery. Turnaround time could be slow , as a result I m looking for...

For more news, you could also go to the source. http://www.microsoft.com/SQLServer?

An interesting place to get news about SQL Server along with events and training (mostly free) is http://www.sqlpass.org/

There are lots...

If CROSS APPLY option is too slow (as I understood from the previous post) you could try this one:

SELECT DISTINCT

S.SiteNumber,

PA.ID,

...

Wild shot in the dark.

SELECT

FromDate,

enddate,

Shift,

ShiftType

FROM dbo.ShiftScheduler

WHERE EndDate BETWEEN '20160401' AND...

ishaan99 (4/25/2016)

---

How do I automate a process which will

a) select all tables from my database. some tables have auto identity columns.

b) generate insert script that will turn on/off identities and...

TomThomson (4/25/2016)

---

I've just got to remember to try that next time I'm in P del C! :-D...

Check the remark on my previous post. It can bring inaccurate results if you use your query.