Re: Using the result of a function as a column name.

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

But why using CHAR(15) instead of VARCHAR(15)? <<

Why not? Fixed length names are easier to put on a report or screen,
to write check() constraints for, etc. But the point is that this was
a skeleton and that was just a number; in a real schema, the length
would be determined by some internal group (probably accounting or
marketing) and so would the CHECK() constraint.

What if I want to change the name of report later on do you think you did not produce a fragmentation? What if during a transaction JOIN ON period_name you change the name of report? <<

You are being absurd. First of all, what new names would you give the
first fiscal quarter of 2009? I might change my name to a different
format ('2009-Q1' instead of '2009-Fiscal_1') but it is an entity
would have to maintain its identity (in the sense of logical
identity). Next, reporting periods are usually fixed by law; or if
they are historical, th4ey are fixed by reality (i.e. I cannot change
Ramadan 2000 to anything else). But let's keep being silly -- What if
I want to change the value of pi in a look up table?


.

Relevant Pages

  • Re: Using the result of a function as a column name.
    ... to write checkconstraints for, ... Fixed length names are easier to put on a report or screen, ... a skeleton and that was just a number; in a real schema, ... What if during a transaction JOIN ON ...
    (microsoft.public.sqlserver.programming)
  • Re: asp.net report DbSource
    ... DataSet with DataRelations that provide foreign-key constraints? ... being used in the report. ... the base query is used by SQL'05 reporting ... DataColumn is causing the trouble and fix the schema. ...
    (microsoft.public.dotnet.general)
  • Re: ISE 10.1 - Initial experience
    ... improvements, mainly concerning GUI (like report, for cross probing to ... at first I was quite frustrated: many timing constraints not ... I'm just worry about LUT and FF increase after map: ...
    (comp.arch.fpga)
  • Re: Xilinx Timing constraint problems
    ... in the UCF file. ... One of the constraints ignored comes from Xilinx's ... constraint seems ignored and looking in the timing report it is these ... report and check the path coverage. ...
    (comp.arch.fpga)
  • Re: Need to print Cover Sheet for report.
    ... This caused the last paragraph in the Report ... Is there any way to prevent Access from allocating the page footer space on ... Use code in this group footer's Format event to adjust its height to fill ... Private Sub GroupFooter0_Format ...
    (microsoft.public.access.reports)