Reputation: 1 Apprentice
- Active Posts:
- 44 (0.03 per day)
- 15-December 11
- Profile Views:
- Last Active:
- May 22 2015 12:19 AM
- Dream Kudos:
Posts I've Made
Posted 21 May 2015Because LeadIDs doesn't exist yet. First:
SELECT rhs.AppointmentNo AS RunningNo, (CASE WHEN rhs.CustomerLeadID IS NOT NULL THEN rhs.CustomerLeadID ELSE rhs.MemberLeadID END) AS LeadIDs FROM ReservationHS rhs
Actually, stop here. In this particualar case, there is a handy function:
SELECT rhs.AppointmentNo AS RunningNo, IsNull(rhs.CustomerLeadID,rhs.MemberLeadID) AS LeadIDs FROM ReservationHS rhs
select a.RunningNo, a.LeadID, b.LeadFullName from ( SELECT rhs.AppointmentNo AS RunningNo, IsNull(rhs.CustomerLeadID,rhs.MemberLeadID) AS LeadID FROM ReservationHS rhs ) a inner join Lead b on b.LeadID = a.LeadID
However, since the IsNull makes this pretty trivial, you can simply do:
select a.AppointmentNo AS RunningNo, IsNull(a.CustomerLeadID,a.MemberLeadID) AS LeadID b.LeadFullName FROM ReservationHS a inner join Lead b on b.LeadID = IsNull(a.CustomerLeadID,a.MemberLeadID)
Hope this helps.
Thanks so much for your helps, baavgai
Posted 13 Aug 2014Please help me .
At least give me the links that teach how to do that ?
Posted 12 Aug 2014The tutorial there , there show gridview which load data from one table.
But in my case , I have created gridview which have 3 column.
1 column for checkbox, 1 column load data from another table, 1 column have dropdownlist which datasource from another table.
Below is the illustration image
Sorry if you found resource, you can recommend link here. I am newbie
Posted 12 Aug 2014Thank you modi123_1 for help me.
The language is C# , ASP.Net WebForm
The zip file contains 2 images screenshot
Posted 10 Aug 2014Thanks for your help Skydiver
- Member Title:
- New D.I.C Head
- Age Unknown
- Birthday Unknown
tokei hasn't added any friends yet.