Advertisement

10.03.2008 at 03:26AM PDT, ID: 23784483 | Points: 500
[x]
Attachment Details

SQL Select Statement Join fields

Asked by jay_eire in MS SQL Server

Hi Guys,
I'm using ASP.NET membership to create and store user information in my database, the users details are saved to a table called
aspnet_profile there is two fields in this table called: PropertyNames and PropertyValues below is an Example of the string stored in each field


PropertyNames
Class:S:0:7:FirstName:S:7:7:Surname:S:14:7:Group:S:21:5:Address1:S:26:4:Contact:S:30:5:Address2:S:35:21:

PropertyValues
7D1TimSmithFalseClass71FalseBlock 5

The information is stored as above i need a select that will join up both fields so the end statement will look like this

FirstName:Tim
Surname:Smith
Group:False
Class:7D1
Address1:Class71
Address2:Block 5
Contact:False

Thanks
Jay EireStart Free Trial
 
Keywords: SQL Select Statement Join fields
Title
1 LEFT join not returnng leftmain table val…
2 SQL Help
3 production virtual directory versus test…
4 ASPNET Authentication
5 aspnet_regsql –S error
6 Dateformating
 
Loading Advertisement...
 
[+][-]10.03.2008 at 03:29AM PDT, ID: 22632489

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.03.2008 at 03:38AM PDT, ID: 22632526

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.03.2008 at 03:48AM PDT, ID: 22632564

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.03.2008 at 04:10AM PDT, ID: 22632665

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.03.2008 at 05:56AM PDT, ID: 22633340

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20081112-EE-VQP-44 - Hierarchy / EE_QW_2_20070628