I would agree that creating a mapping table for ProductApplication sounds like a good approach. That is how I would probably do this.

Consider a typical query to get all...

This doesn't help us understand the issue here. We can't see your screen, we are not familiar...

mbigatti 28497 (5/3/2013)

---

In the scenario described it wouldn't matter which payment was meant for each subscription Id because the assumption is that the subscription doesn't capture any information besides the...

I think this is right. I am kinda tight on time so I didn't have time to look super close but this should at least get you close.

You can find...

Motz (5/3/2013)

---

Thanks for the reply, the output u have copies is half.. please check thr is also PRJ_ID = 2 and have data till sept12

the data I want is for...

Excellent job posting ddl and sample data. I am a little uncertain what you want for output. In your original post this is what you had for PRJ_ID 1

The output...

Motz (5/3/2013)

---

The first records set is the table data which is cumulative data, but i need to populate the data for the missing dates as well and insert new record...

mbigatti 28497 (5/3/2013)

---

Thank you for the reply!

In my haste to post the question I entered one row too many for subscriptions.

The scenario is that the two tables are populated with...

You are going to need another table in order to do this. Probably a tally table will do the job but it is difficult to know for sure based on...

Not a problem at all. Maybe you should...

Isn't this the same as your other thread? http://www.sqlservercentral.com/Forums/Topic1448705-391-1.aspx

If you split your threads you will also split your responses.

TryingToLearn (5/3/2013)

---

I figured it out....Thank you,

I would like to return all the data for a single empnum, but this query is returnng data for ALL empnum's. any suggestion would be...

maxlezious (5/3/2013)

---

Thanks for your reply Lynn.

We have this working php code and i am trying to convert this into sql

$db_name = "DB_admin1" ;

$conn = mssql_select_db($db_name) or die('Connection to the Database...

It sounds like maybe you are wanting to update those rows where the SerialNum is NULL and insert when the row is not found? You should take a look at...

For the first time in 106 years it is snowing in Kansas City in May with anticipated accumulation. How bizarre!!! They are saying we should expect anywhere from 1 -...