select T.ID, T.Amount, Y.Amount as Yesterday_Amount, T.InjectedDate

from Transactions as T

left join Transactions as Y

on cast(Y.InjectedDate as date) = dateadd(day,-1,cast(T.InjectedDate as date))

order by T.InjectedDate, T.ID;

If join performance...

Miles Neale (3/17/2015)

---

Eric M Russell (3/17/2015)

---

Miles Neale (3/17/2015)

---

Eric M Russell (3/17/2015)

---

It seems we need to better define what it means to "witness" a crime. For example, if a city clerk...

Miles Neale (3/17/2015)

---

Eric M Russell (3/17/2015)

---

It seems we need to better define what it means to "witness" a crime. For example, if a city clerk manually reviewed each photo of...

Charles Kincaid (3/17/2015)

---

...

A traffic violation is a misdemeanor (minor crime). A charge like that has to be brought either by an officer or citizen. But that individual...

This would be an excellent interview question for those situations where someone has a personal grudge against the candidate. :crazy:

Gary Varga (3/17/2015)

---

Part of me believes that in this century we may move to a model where ownership of data is considered "so 20th century", however, where value can be...

Microsoft Team Foundation Server has a feature in it's source control where you can compare one version of a source file to another past version, and it will highlight all...

SQLRNNR (3/13/2015)

---

I have seen a couple of comments in this thread about the type of comment that states the obvious.

I don't necessarily take issue with a comment that states the...

The absolute worst type of comment is when a developer encloses a pre-existing block of code within /* */ brackets without an additional comment stating why, when, and who.

Another type...

Hey JeeTee,

So which of these ponies runs fastest?

I'm placing my money on the INSERT #S EXEC() AT method I described earlier.

:satisfied:

Xavon (3/12/2015)

---

One thing I would like to add to this:

namely:

"or is saddled with...

You can successfully ping remote server name from client?

GoofyGuy (3/11/2015)

---

I'm actually beginning to question the relevence of in-house database engineers. It's not that we can't make a real difference, it's just that circumstances beyond our control marginalize the...

pbyrum (3/11/2015)

---

I have SQL Server 2012 installed and when I run this command:

sc query mssql$MSSQLSERVER

I get this error:

[SC] EnumQueryServicesStatus:OpenService FAILED 1060:

The specified service does not exist as an installed...