Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Server.Transfer and
Response.Redirect? Why would you choose one over the other?
- 26 Answers
- 34949 Views
- Syntax Softtech, I also Faced
- E-Mail Answers
Answer Posted / x
select Distinct [Subject ID], [Date of Birth],[Gender],
[Race] from
(
select vm1.spid as [Subject ID],
(case when objd1.objectdesignationtypeid = 4 then
vmd1.fieldvalue end) as [Date of Birth],
(case when objd1.objectdesignationtypeid = 8 then
vmd1.fieldvalue end) as [Gender],
(case when objd1.objectdesignationtypeid = 9 then
vmd1.fieldvalue end) as [Race]
from Recon.dbo.AAA999809_Visitmodule
vm1,Recon.dbo.AAA999809_Visitmoduledetail vmd1,
Recon.dbo.recon_objectdesignation objd1
where vm1.vuid = vmd1.vuid and
vmd1.objectid = objd1.objectid
and vmd1.objectid is not null and objd1.objectid is not null
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How can we identify that the Page is Post Back?
What is request and response in asp.net?
How can you ensure a permanent cookie?
How can I configure asp.net applications that are running on a remote machine?
what is loosely coupled solution? How it can be used?
In ViewState How much lifespan items stored?
How can you display all validation messages in one control?
What is session management in web application?
How can we Validate a Controls in ASP.NET page using JavaScript?
What is ashx file in asp.net?
Explain how is the asp.net mvc architecture different from others? : asp.net mvc
What is the file through which you can customize your asp.net application?
What is a proxy in web service?
How do I know asp.net mvc version? : Asp.Net MVC
What is the recommended approach for asp.net mvc to globally intercept exceptions? What other functionality can be implemented with the approach? : Asp.Net MVC
