Re: how to sum a text field with commas
- From: "Tony Rogerson" <tonyrogerson@xxxxxxxxxx>
- Date: Thu, 24 Dec 2009 06:23:38 -0000
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 said this...
"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, {querying} and transaction control.
IT has everything to do with database design 1nf, 2nf etc...
LOL! These days, I use a word processor or a spreadsheet most of the
time! I find that most one-shot jobs
Next time (later this morning) I need to bring in a 20MByte file with a couple of million rows in it and validate it, and then insert it into my database I'll be sure to try and do that with Word or Excel.
Right tool for the right job; often SSIS is over kill and takes longer for what you are trying to do; a lot of the time its easier, more maintainable, more cost effective to load the data into temporary tables within the database and use "T-SQL" to validate etc...
But, you'd not know that if you worked just with theory; its only by actually doing stuff you'd get to know this "experience".
For repeated jobs, we usually have an ETL tool in my "sheltered
existence" IT shops.
Cool - so, a lot of experience on a day to day basis doing that? Or is it, as I suspect; something you've only occasionally done
..
Perhaps one of these days I'll bring a lap top with some of the products you say you have used and put it in front of you and say "go on then, should me the basics of the product" - I've no doubt in my mind you'd be clueless.
--ROGGIE--
"--CELKO--" <jcelko212@xxxxxxxxxxxxx> wrote in message news:01905906-cbad-451f-a5a4-383330258424@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
.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.
- References:
- how to sum a text field with commas
- From: RedGlow06
- Re: how to sum a text field with commas
- From: --CELKO--
- Re: how to sum a text field with commas
- From: Tony Rogerson
- Re: how to sum a text field with commas
- From: --CELKO--
- how to sum a text field with commas
- Prev by Date: Re: loop between 2 datetime field values
- Next by Date: Re: INSERT INTO on CHAR fieldtype with auto increment?
- Previous by thread: Re: how to sum a text field with commas
- Next by thread: Changing linked server pswd on multiple servers
- Index(es):
Relevant Pages
|
