[dba-SQLServer] How good are you really?

Well, I am not writing a VB.Net (or ASP.Net) module to do this.  Not there
yet on the .net front.  I purchased XMod and an add-in for that called
DataFeed or something like that, which makes it pretty trivial to pull data
out of SQL Server and put it up on a grid control.  However this data is not
normalized.  I have no idea whether Xmod allows me to communicate directly
with the DNN methods, or map controls to such values.  

What I am trying to do is to list potentially the entire User attribute set
- Name/Address/Phone/Email in a grid.  Preferably with a sort mechanism.
Built as a control which I can place on any page.

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Haslett,
Andrew
Sent: Sunday, November 20, 2005 5:29 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] How good are you really?


Do you need to work with the database directly?

If not, you can use the built in dotnetnuke methods to retrieve these
values.  Its quite easy to use..

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John Colby
Sent: Friday, 18 November 2005 3:20 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] How good are you really?

The challenge:

DotNetNuke stores it's user info in a denormalized field in a table in SQL
Server.  One field has the definition of the data, for that record, at that
instant:

Website:S:0:0:TimeZone:S:0:4:PreferredLocale:S:4:5:Region:S:9:7:FirstNam
e:S:
16:6:PostalCode:S:22:5:Street:S:27:22:LastName:S:49:11:Unit:S:60:0:Telep
hone
:S:60:12:Country:S:72:13:IM:S:85:0:Fax:S:85:0:City:S:85:8:Cell:S:93:12:

With the data itself as follows:

 -480en-USMontanaLouise82637918 Keller Dr. Box
642Hammersmark307-436-9731United StatesGlenrock307-259-8423

As you can see, the data is really a set of fields, with the field names
embedded in the definition, then a start position within the data string,
and the length of the data actually in the string.

Is it possible to build a query or SP to pull the data out of the data
field, using the formatting data and return a table of the data with field
names and the data available?

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/