Please don't cross post. It just fragments replies and makes it harder for you get a decent response.

Direct replies here.

http://www.sqlservercentral.com/Forums/Topic1494546-1550-1.aspx

lanky_doodle (9/13/2013)

---

Alan.B (9/12/2013)If I understand the original OP correctly (" If something has been credited, the billed item row should be excluded") this would not provide the right answer with...

There isn't enough information to provide an answer. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in...

ChrisM@home (9/12/2013)

---

paulcauchon (9/12/2013)

---

I see the hitch up here...you need to see the min date and max date from each of the consecutive color/ID group pairings.

Originally, we had been treating the...

What you have is a painful twist to an EAV type of system. This is going to be nothing but slow, tedious and nightmarish as the system gets larger.

We...

Glad you got it to work. What was the issue? There may be others who come along this...

wei (9/12/2013)

---

Hi,

I have a question and see if people can help me out in this, I was trying to sum the column number up, but somehow if I do select...

At least the trigger will now get the right data. 😉

OK in order to be able to help much we will need to...

Probably char(8). Then you will have to do some substring manipulaton to separate the date parts.

Yeah you need a calendar table. Check out this article. It is great explanation of what they can do for you.

http://www.sqlservercentral.com/articles/T-SQL/70482/%5B/url%5D

todd.ayers (9/12/2013)

---

Yeah... I'm pretty sure.... As a matter of fact this example database that I am creating comes from a book I am going through (Beginning SQL Server 2008 for...

db2mo (9/12/2013)

---

I have a text file with no delimiters and fixed width fields that I need to import into a SQL Server database. An example of the text file...

Alan.B (9/12/2013)

---

If I understand the original OP correctly (" If something has been...

Are you sure??? That is...

Take a look at the article in my signature about splitting strings. In there you will find a table valued function for doing this.

The code when you are done would...