Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1458916-392-1.aspx

I suspect you were not clear on how difference works. To be honest it is pretty limited.

http://msdn.microsoft.com/en-us/library/ms188753.aspx

What exactly are you trying to do?

And why all the NOLOCKS?

http://www.jasonstrate.com/2012/06/the-side-effect-of-nolock/%5B/url%5D

dwg23 (5/31/2013)

---

i would like to thank everyone for being willing to help and will be back in the future if I get stuck. I have figured out what I needed...

Sure.

case when age > 45 then 'here is a sign' else 'no sign here' end as SomeKindOfSign

dwg23 (5/31/2013)

---

First off I do apologize for the way that I responded.

And I need to be more clear in what I am asking for.

The query as posted works. ( I...

Stefan Krzywicki (5/31/2013)

---

Sean Lange (5/31/2013)

---

Stefan Krzywicki (5/30/2013)

---

Sean Lange (5/30/2013)

---

Lowell (5/30/2013)

---

GilaMonster (5/30/2013)

---

[nitpick]

The factors of 21 are 7 and 3. The product...

amar_kaur16 (5/31/2013)

---

I have a table with studentId, decision and Finishdate

Where studentid is the primary key and there could be none decision earlier and the aacept/deny later or vice-versa for a...

GrassHopper (5/31/2013)

---

Sorry, I forgot to specify I only need the units and the amounts. ie

comments:

5321063 HOLLAND BL 90X210 10 Unts ...

Stefan Krzywicki (5/30/2013)

---

Sean Lange (5/30/2013)

---

Lowell (5/30/2013)

---

GilaMonster (5/30/2013)

---

[nitpick]

The factors of 21 are 7 and 3. The product of 7 and 3...

You really need to post ddl and sample data. I posted it for you this time.

You can use a tally table here to fill in the "missing" months. You can...

You're welcome.

Hi and welcome to the forums.

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

dwg23 (5/30/2013)

---

Wow, I am so sorry! I thought I had posted in the Newbie section were not following whatever rules you think are important might be over looked.

I believe I...

You didn't provide a whole lot to go on here. The best we can do is take...