So you have duplicate ID and name. Which dateinserted do you want to keep?

jcrawf02 (4/1/2014)

---

Sean Lange (3/31/2014)

---

Ed Wagner (3/31/2014)

---

rodjkidd (3/31/2014)

---

I do like paying it forward.

Got an email from friend who was stuck on working out how many days old a debt is at...

SQLRNNR (4/1/2014)

---

jcrawf02 (4/1/2014)

---

Sean Lange (3/31/2014)

---

Ed Wagner (3/31/2014)

---

rodjkidd (3/31/2014)

---

I do like paying it forward.

Got an email from friend who was stuck on working out how many days old a debt is...

A cross join?

SELECT t1.Col1, t1,Col2, t2.Col1 as Col3, t2.Col2 as col4

from Table1

cross join Table2

So you have a temp table with 400 million rows??? Even if it is actually a persistent table why do you have a table that large with no primary key?...

Using some aliases here makes this query far less painful to read.

SELECT ISNULL(DATEDIFF(MM, cs.SavingsStartDate, @FYStartDate), 0) AS InYearMonths

FROM dbo.ContractBenefitReporting_SharesInReport sir

INNER JOIN dbo.ContractBenefitActuals cab ON sir.BenefitVersion = cab.Version AND sir.ShareID =...

Yep that's where I keep it. 😛

It may be a good thing your are the FNG. At least that means your resume is current. That place sounds like a nightmare and one to avoid. :w00t:

Ed Wagner (3/31/2014)

---

rodjkidd (3/31/2014)

---

I do like paying it forward.

Got an email from friend who was stuck on working out how many days old a debt is at the end of...

ramana3327 (3/31/2014)

---

Hi,

I have a parent stored procedure which is calling the child stored procedure. The procedures are using table valued parameters. Before calling the child sp, I want to put...

tresiqus (3/31/2014)

---

Thanks, but the problem description I get doesn't have anything specific, typically just a "dropped connections - you need to check the indexes on the server" request. The...

It is pretty tough to offer much advice here because we really dont have any details to look at. Do you know what query(s) are timing out? Have you examined...

JK 80940 (3/31/2014)

---

Hi Guys,

I have a sql server 2005 table that stores a list of small pdf articles, there are over 1900 of them, I have a Title, Author and...

Toreador (3/31/2014)

---

Sean Lange (3/31/2014)

---

as posted the user absolutely does NOT belong to sysadmin because it was not in the code provided. If it is ok to assume that somebody added...

Toreador (3/31/2014)

---

Nor is there anything to say that it...