- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Collapse
You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:
- You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
- You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
- If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
Logging in...
Previously on "Converting Vertical DB Table to Horizontal Table"
Collapse
-
Thanks ScotsPine, i'll try that tonight... it is basically only for a one off migration away from the insanity of the existing 'virtual database', that then uses hard coded calls to a SQL generator compomnent that simply turns the virtual tables back in to 'real tables' for each query... it's a disaster really... nearly a minute for some people to log in...
-
Originally posted by scotspine View Postpublic DataTable TurnTable(DataTable source)
a. I remember that the CUK Admins do real work - sometimes.
b. I remember that MS-SQL is utter crap.
Leave a comment:
-
public DataTable TurnTable(DataTable source)
{
DataTable dest = new DataTable("Turned" + source.TableName);
dest.Columns.Add(" ");
foreach (DataRow r in source.Rows)
dest.Columns.Add(r[0].ToString()); // assign each row the plan name (r[0])
for (int i = 0; i < source.Columns.Count - 1; i++)
{
dest.Rows.Add(dest.NewRow());
}
for (int r = 0; r < dest.Rows.Count; r++)
{
for (int c = 0; c < dest.Columns.Count; c++)
{
if (c == 0)
{
dest.Rows[r][0] = source.Columns[r + 1].ColumnName;
} // the plan name
else
{
dest.Rows[r][c] = source.Rows[c - 1][r + 1];
}
}
}
dest.AcceptChanges();
return dest;
}
Leave a comment:
-
Originally posted by scotspine View Posti have some code
Leave a comment:
-
Ahhh, the Inner Platform Effect.
I've seen these a few times, and they were always broken beyond repair. I have pity on you...
Leave a comment:
-
SQL Server 2005...
The architecture for want of a better description is one where 'Virtual Tables' are defined in the database and some in-house generic sql generator (the calls to which are hard coded which totally defeats the object!) - I have extracted this meta data and created physical, horizontal tables...
Basically it's now a case of migrating the data into these new tables - I am thinking of creating Views on the vertical table and attempting to extract the data that way, but its the 'rotation' of a vertical table to a horizontal table that is a problem...
Leave a comment:
-
Converting Vertical DB Table to Horizontal Table
I have a database which I am migrating to a more useable structure, and one of the problems I have is that it was designed to be totally generic - performance and maintainability is appalling.
The structure of one table is totally vertical:
InstanceID int, Fieldname VarChar (255), FieldValue VarChar (255)
InstanceID is non-unique, The FieldValue can be anything, from a name to an email address.
For each InstanceID I need to extract the list of fields, and their values, and copy them into a new table structure (which I have already created programatically). The list of fields is different for each InstanceID...
Any suggestions...?Tags: None
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Streamline Your Retirement with iSIPP: A Solution for Contractor Pensions Sep 1 09:13
- Making the most of pension lump sums: overview for contractors Sep 1 08:36
- Umbrella company tribunal cases are opening up; are your wages subject to unlawful deductions, too? Aug 31 08:38
- Contractors, relabelling 'labour' as 'services' to appear 'fully contracted out' won't dupe IR35 inspectors Aug 31 08:30
- How often does HMRC check tax returns? Aug 30 08:27
- Work-life balance as an IT contractor: 5 top tips from a tech recruiter Aug 30 08:20
- Autumn Statement 2023 tipped to prioritise mental health, in a boost for UK workplaces Aug 29 08:33
- Final reminder for contractors to respond to the umbrella consultation (closing today) Aug 29 08:09
- Top 5 most in demand cyber security contract roles Aug 25 08:38
- Changes to the right to request flexible working are incoming, but how will contractors be affected? Aug 24 08:25
Leave a comment: