Nomvula (8/23/2016)

---

what I want is the record with the minimum date per asset, in the case of 1004 and 1005 the date is the same and 1004 is the minimum...

Nomvula (8/23/2016)

---

thank you for the quick response,

my question is now, I technically I don't have ROWId in my table, I've it there In the example so I can distinguish easily...

shagil.a.gopinath (8/23/2016)

---

Thanks for the reply,

According to given scenario I have time till end of June, % should be calculated by considering the scheduled date, Completed Date. In the row number...

shagil.a.gopinath (8/23/2016)

---

Hi Team,

I would like to find out the percentage for the delay only, I have the ScheduledDate and if do the activity on or before then i can say...

shot in the dark......whilst you have posted sample data it is not easily reproducable in SSMS......did you read the link I provided ? (eg CREATE TABLE / INSERT DATA...

ok...I think I understand what you want, but your description of the problem comapred to the limited sample data and expected results doesnt clarify it for me.

suggest you post some...

gjoye (8/19/2016)

---

Here is a sample of a couple rows of data in raw form.

SALES REP -- COMPANY -- TRANSACTION DATE -- PYEAR -- PMONTH -- Number Of Employees

Allen...

what version of MS SQL are you using?

james.stanich (8/18/2016)

---

The data would be displayed within a Telerik Winform Datagrid.

I would need the pivot to handle dynamic dates, but no more than 7 since the display is for weekly...

james.stanich (8/18/2016)

---

I know I can achieve the pivoted data result in Excel, however, my goal is to NOT use Excel. I am trying to get the same output from...

suggest you post the create table script and insert data scripts for your sample data please.

thanks

jssashank (8/16/2016)

---

J Livingston SQL (8/16/2016)

---

jssashank (8/16/2016)

---

J Livingston SQL (8/16/2016)

---

jssashank (8/16/2016)

---

J Livingston SQL (8/16/2016)

---

can I please ask you to explain why you wish to exclude rows where the first row is...

jssashank (8/16/2016)

---

J Livingston SQL (8/16/2016)

---

jssashank (8/16/2016)

---

Sure. My intention...

jssashank (8/16/2016)

---

Sure. My intention for adding that is...

can I please ask you to explain why you wish to exclude rows where the first row is a debit?