Facing problem with Select Query… | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Facing problem with Select Query…

Hello friends, I am facing problem with "select" query.
Actually I want to select the rows from same table having same FormId but diffenent ApplicantType(its column name in table). For eg. ApplicantId | FormId | ApplicantType | Name | Surname 01 | 01 | 1 | R | K
02 | 01 | 2 | S | K and I need the result as FormId | Name | Surname | Name | Surname
01 | R | K | S | K Plz help. Thanks and Regards, Simmyk
Check this out:http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs

]]>