Re: how to sum a text field with commas

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

SQL is querying - nothing more. <<

Actually it is DDL, DML, DCL and transaction control. This is one of
the major problems that cowboy coders have; they think SQL = DML, and
fail to create integrated systems.

You also show a sheltered existence, really, have you never had to chop and refine data - would you honestly write a separate one off program in C when in a fraction of the time you could cut and massage the data into a structure you want and conforms to proper database design principles? <<

LOL! These days, I use a word processor or a spreadsheet most of the
time! I find that most one-shot jobs have the data I want on a
website for download. Most of the cleanup work is with text --
squeeze spaces, change case, run a macro and stick it into a CSV file
for BCP or some INSERT INTO statements.

For repeated jobs, we usually have an ETL tool in my "sheltered
existence" IT shops.

.

Relevant Pages

  • Re: how to sum a text field with commas
    ... "BY DEFINITION a column has scalar values, this is not a valid value in SQL" ... Holding "1,2,3" in a column has nothing to do with DDL, DML, DCL, and transaction control. ... IT has everything to do with database design 1nf, ... I find that most one-shot jobs have the data I want on a ...
    (microsoft.public.sqlserver.programming)
  • Re: A10 Multiwertfeld im Backend - funktioniert im Frontend nicht
    ... Mach's per DML. ... Du bist doch eigentlich nicht so neu in SQL. ... Und irgendwie standardisiert ist das überhaupt nicht, weil es eben keinen Sinn macht. ... Das hat doch mit dem Nonsens, den die Access Programm Manager hier fabriziert haben, überhaupt nichts zu tun. ...
    (microsoft.public.de.access)
  • Re: About MS-Access RDBMS
    ... > Access has a pretty complete implementation of SQL DDL and DML; ... so this is a fail. ... Jet has DML, DDL (CREATE TABLE, CREATE ... I assume the same applies to Validation Rules in the MS ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Early and late binding.
    ... > With a SQL DBMSs one is forced to separate DDL from DML which may or may ... To relate your last point back to binding, ... where the model is static between DDL transactions. ... not coded as DML, but as something else. ...
    (comp.databases.theory)
  • Re: SQL vs. VBA
    ... anything you can do straightforwardly with a DML query/SQL statement will be more efficient than looping records in VBA. ... Personally I find it better to put the SQL string in the VBA rather than use a saved query. ... The SQL standard also includes DDL, for manipulating the data schema This is too restricted in Access to be much use, e.g. you can't set some important field properties this way. ...
    (microsoft.public.access.queries)