RE: Contruct grid with stored procedure

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John Bell (JohnBell_at_discussions.microsoft.com)
Date: 10/14/04 

Date: Thu, 14 Oct 2004 01:39:07 -0700

Hi

Sounds like you need a dynamic pivot table!

Did you check out:
http://www.sqlteam.com/item.asp?ItemID=2955

In general you are better leaving this sort of thing to the client.
e.g.
http://www.rac4sql.net/

John

"Mark Gilbert" wrote:

> I'm trying to work out the best way to store tables of data in SQL. By
> tables i mean, the data is intended for a grid of data (a html table).
>
> The tricky thing is, the tables are going to vary in number of columns
> and datatypes (some string, some numeric).
>
> Currently i have setup db tables similar to the following...
>
> tblColumn
> =========
> ColumnID - numeric (key)
> CellProdID - (The product the table is for, will tie everything
> together)
> ColumnNumber - int (column position)
> ColumnTitle - varchar
> ColumnType - bool (string or int)
>
> tblCell
> =======
> CellID - numeric (key)
> CellColumnID - (Column it falls under)
> CellLineNumber - (line number, to tie the cells for this line in the
> table)
> CellText - varchar (if type is string)
> CellNumber - int (if type is int)
>
>
> Is it possible to create a stored procedure which will construct a
> table of rows suitable for binding to a dataview?
>
> I can't get my head around it, at the moment i have a load of messy
> code in vb to do it.
>

Relevant Pages

  • Lennons "Cake & Eat It" writing style
    ... There are other songs where John is not afraid to sabotage the sincere ... lyric contrasts with the frat boy chorus of "tit tit tit tit". ... And in "She's Leaving Home", Paul gives a narrative assessment, sort ... When John comes in, it's in the voice of the parents, taking it from ...
    (rec.music.beatles)
  • Re: sorting by last name
    ... of the file being the LastNameFirstName and then use a macro to recombine ... Dim Counter As Long, Source As Document, Target As Document ... >I have 150 pages in Word that I would like to sort based on client LAST ...
    (microsoft.public.word.mailmerge.fields)
  • RE: Sorting Data by a Range of Dates
    ... I have a database with 5 fields. ... All I want to do is sort the info in the ... database for our client Stone Ridge. ... Dim stDocName As String ...
    (microsoft.public.access.reports)
  • Re: OT Charging Clients For SBS Support
    ... Its just that the sort of support mentioned is if you are available full time for the clients - doing this part-time doesn't really work unless they are very close and/or stable or low key. ... I was asked the other day to install sbs 2003 & 8 client PC's by a new client, the install is now complete and fully functioning but the the client has asked me to provide ongoing support. ... Monthly support fee, with all monitoring email sent to me so I can keep an eye on potential problems, remote administration as and when needed as well as telephone support for the desktop users - the users are all fairly technical and I only envisage calls if there are issues with the server or hardware. ...
    (microsoft.public.windows.server.sbs)
  • Re: Frappr beta from Google
    ... lacks the sort of precision necessary to navigate successfully to "The Great ... Technically, John was not a newbie.....he had been there, ... After the obligatory fishing of the pool at the base of the falls, ...
    (rec.outdoors.fishing.fly)