Jeff Moden (11/15/2012)

---

I hear ya!!! If the final PreaggregatedHierarchy table is the source of information for a 24/7/.999999999 web site or application, then you really can’t afford even the...

Brandie Tarvin (3/18/2015)

---

GilaMonster (3/18/2015)

---

Jack Corbett (3/18/2015)

---

That was an interesting read. I can't disagree with any of it, but I...

In order to...

Robert-378556 (3/18/2015)

---

Good article. It highlights the most common mistake made in triggers by developers coming to sql server from other databases which usually have row level triggers.

However, the example is...

N_Muller (3/17/2015)

---

Very good article. I would like to point out my preference for INSTEAD OF triggers on views. The view could be as simple as SELECT * FROM ....

alen teplitsky (3/17/2015)

---

do people really write code where they insert data like that with the status and the code not part of the insert operation and you have to update...

brett 41274 (3/17/2015)

---

Good article however this point appears to not be true

• Normally if you execute a standalone (“atomic”) INSERT, UPDATE, DELETE or MERGE statement you don’t really need to...

PHYData DBA (3/17/2015)

---

Nice article Dan. I understand the Pain you mention of RBAR triggers all to well. We have an OLTP database that uses 7 of them to...

CELKO (11/14/2014)

---

When you're a carpenter making a beautiful chest of drawers, you're not going to use a piece of plywood on the back, even though it faces the wall and...

Is it possible that we are overlooking the possibility here that there's a FOREIGN KEY constraint relationship between table A and B.BCol1?

Do you really want those fractional amounts to not add back to the totals?

That can be fixed you know.

Financial Rounding of Allocations [/url]

There are various ways to do this. The concept is similar to Creating a Date Range from Multiple Rows Based on a Single Date [/url] except you want to...

Use CONSTRAINTs to prevent overlaps and gaps in the first place:

Self-maintaining, Contiguous Effective Dates in Temporal Tables[/url]

This is more what I had in mind.

SELECT CancellationDate=SUBSTRING(s, CHARINDEX('Cancellation Date', s)+20, 12)

FROM

(

SELECT s=b.TextOfActivityDescription.value('@value[1]', 'VARCHAR(8000)')

FROM DC_Bil_ActivityLog a

CROSS APPLY...

maruthasalam (3/13/2015)

---

Still I am getting the same error as below

Msg 512, Level 16, State 1, Line 6

Subquery returned more than 1 value. This is not permitted when the subquery follows...