Eugene Elutin (4/17/2012)

---

You never know for...

Perhaps I took some latitude, but I was making the assumation (bad thing to do at times) that the OP was talking about joining tables together on multiple columns. ...

Greg Edwards-268690 (4/17/2012)

---

capn.hector (4/16/2012)

---

Sean Lange (4/16/2012)

---

Lynn Pettis (4/16/2012)

---

With "the one", do you think it time to tell him the following?

1. Get out a blank piece of paper.

2. Put your name...

As this is a SQL Server 2008 forum, the filtered index is available. If you have any SQL Server 2005 systems, though, it is not available there.

Yes.

Evil Kraig F (4/16/2012)

---

Lynn Pettis (4/16/2012)

---

Evil Kraig F (4/16/2012)

---

So, annoying news. My contract which was supposed to run till end of year is getting popped in about 2 and...

dfarina (4/16/2012)

---

sorry, here is the data

CREATE TABLE sample(id int identity(1,1), s_date datetime, amount int)

insert into sample

select '20100101', 1

union all

select '20100102', 1

union all

select '20100103', 1

union all

select '20100104', 1

union all

select '20100111', 1

union...

Evil Kraig F (4/16/2012)

---

So, annoying news. My contract which was supposed to run till end of year is getting popped in about 2 and a half months. Ah...

If you provide the DDL (CREATE TABLE statement) for the table(s) involved, provide sample data (as a series of INSERT INTO statements) for the table(s) involved, the expected resutls of...

SQLRNNR (4/16/2012)

---

Sean Lange (4/16/2012)

---

Lynn Pettis (4/16/2012)

---

With "the one", do you think it time to tell him the following?

1. Get out a blank piece of paper.

2. Put your name and today's...

Direct further replies here.

Matt Miller (#4) (4/16/2012)

---

SQLCrazyCertified (4/16/2012)

---

Lynn Pettis (4/16/2012)

---

SQLCrazyCertified (4/16/2012)

---

Mike John (4/14/2012)

---

If a column is defined as a primary key, then by definition it cannot be null, so you cannot do anything...

Ask the people you work with. If they can't tell you, you are straight out of luck....

With "the one", do you think it time to tell him the following?

1. Get out a blank piece of paper.

2. Put your name and today's date at the top.

3. At...

hbtkp (4/16/2012)

---

i dont know what is cumulative formula.

but this is how i am getting my final data in report.

so based on how they calculate , i need to do implement...