Comments by Shajee Afzal

Shajee Afzal 1-Apr-14 9:25am View

I see, but I don't get how to call dispose on forms if not in form closed event.
This is how I show another form (in click event of a button):

Form12 frmExO = new Form12();
frmExO.FormClosed += new FormClosedEventHandler(childForm_FormClosed);
frmExO.Show();
this.Hide();

In childForm_FormClosed function, I have :

this.Refresh();
this.Visible = true;

Shajee Afzal 31-Mar-14 2:52am View

Sorry my bad, I didn't knew posting images were against the rules. This will not happen again.
Engineers were assigned to all the tickets. Anyways my problem was solved by adding "PARTITION BY TD.TicketID" in ROW_NUMBER call.
Thank you again.

Shajee Afzal 31-Mar-14 0:40am View

@losmac
Thank you sir. You have been most helpful. This was driving me crazy all week. Just one problem, if I remove the WHERE clause from the statement, I get nulls in "1, 2 and 3" columns (There are no nulls in either tables). I am just trying to display all the tickets generated.
Picture for reference :
http://s28.postimg.org/wrldv2fp9/pivot.png

Shajee Afzal 29-Mar-14 8:12am View

tblEngineer has 2 columns : EngineerID(PK) and Name
tblTicketDetail has 3 columns : TicketID(PK) and IssuerName & TicketDescripton
tblTicket_Engineer has 3 columns : PID(PK), TicketID(FK) and EngineerID(FK) --- Junction table

Comments by Shajee Afzal (Top 4 by date)