Select G.Email,g.name,(D1.DateSelected+ T1.TimeSelected) AS [session1],
(D2.DateSelected+ T2.TimeSelected) AS [session2],
(D3.DateSelected+ T3.TimeSelected) AS [session3]  
From dbo.Guest G
Inner Join dbo.[session] S1 On G.session1ID = S1.SessionId
Inner Join dbo.[Time] T1 on T1.TimeId = S1.TimeId
Inner Join dbo.[Date] D1 on D1.DateId = S1.DateId
Inner Join dbo.[session] S2 On G.session2ID = S2.SessionId
Inner Join dbo.[Time] T2 on T2.TimeId = S2.TimeId
Inner Join dbo.[Date] D2 on D2.DateId = S2.DateId
Inner Join dbo.[session] S3 On G.session3ID = S3.SessionId
Inner Join dbo.[Time] T3 on T1.TimeId = S3.TimeId
Inner Join dbo.[Date] D3 on D1.DateId = S3.DateId

quote:

---

Originally posted by rinky30

Hi Vikash
In my project i have to import a excel sheet data in sql server. From that imported data i create two tables named
tblRequest(MSISDN,CURRENTUSER,SUB_CATEGORY,STATUS,TAT,CIRCLE) and tblComplain(MSISDN,CURRENTUSER,SUB_CATEGORY,STATUS,TAT,CIRCLE)
in these two tables data are releted to call schemes of request and complain type.then from each table i created views to show final output . but i have to create all the above for each day data. How can do all this using asp.net(c#). The output is a report
within the first column is sub category name for complain then request then next column is MTD(Monthly Transaction Data) with sub columns (TotalClose,ATAT,WTAT,Pcercentage),Then there are 30-31 columns for each day data. And MTD should be updated according to each day data. I have a final output data in excel sheet. How can all the above process would i do in asp.net such that my output
come as required

rinkySingh

---