Re: UDF returns table to 'feed' a call back to itself ... how? (cross post)
From: Louis Davidson (dr_dontspamme_sql_at_hotmail.com)
Date: 03/26/04
- Next message: Vadim Rapp: "Re: Return only last dataset from involved SP?"
- Previous message: Anith Sen: "Re: Cascaded updates/deletes via SQL-DMO Key?"
- In reply to: Joe Celko: "Re: UDF returns table to 'feed' a call back to itself ... how? (cross post)"
- Next in thread: Joe Celko: "Re: UDF returns table to 'feed' a call back to itself ... how? (cross post)"
- Reply: Joe Celko: "Re: UDF returns table to 'feed' a call back to itself ... how? (cross post)"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 26 Mar 2004 14:30:54 -0600
> It is possible; I have posted queries that take apart of CSV in one
> statement. Just change the "|" into a "," with the REPLACE() function
> and then use mine or one of several other kludges.
Oh, I cannot believe that I didn't think about that. Got so excited about
trying to solve the problem as stated, didn't think about solving it with a
simple command.
> Would you mind taking a quick survey for me? I have to several hundred
> new SQL programmers in the next year. You have made a typical "Newbie
> Error" and I want to know what your underlying assumptions were that
> lead to the flaw -- your "logic of failure", as it were. You can answer
> to my email instead of on the newsgroup.
I would be amazed if you get a response. One question though, how can you
be so sure that this is a newbie error. In fact, the process that is being
used is taking denormalized data and making it more normal. It is not out
of the realm of possibility that this person has a normalized database and
is getting cruddy data from an outside source.
Don't get me wrong, I like to tear into arrogant newbies as much as the next
guy with an extra large hat holder but the problem is that it is not all
that certain that poor techniques are being employed.
Say this data exists in a different system, in this format. Is there a
better way to do this kind of thing? Should it be done in a functional
language?
-- ---------------------------------------------------------------------------- Louis Davidson (drsql@hotmail.com) Compass Technology Management Pro SQL Server 2000 Database Design http://www.apress.com/book/bookDisplay.html?bID=266 Note: Please reply to the newsgroups only unless you are interested in consulting services. All other replies will be ignored :) "Joe Celko" <joe.celko@northface.edu> wrote in message news:uBSgNz1EEHA.1092@TK2MSFTNGP12.phx.gbl... > >> What I'd like to be able to do is pass in a delimited string ... and > parse it .. I'm guessing that this may be impossible and I don't want to > use a cursor. << > > > Now, would you rather be a good SQL instead? If so, then normalize your > database, and get rid of that "auto-increment" and re-name your data > elements using ISO-11179 as a guide for starters. > > Would you mind taking a quick survey for me? I have to several hundred > new SQL programmers in the next year. You have made a typical "Newbie > Error" and I want to know what your underlying assumptions were that > lead to the flaw -- your "logic of failure", as it were. You can answer > to my email instead of on the newsgroup. > > 1) How many years/months have your been programming? Was your first > language a procedural language? Was your first language an OO language? > > 2) How many years/months have your been programming in SQL? > > 3) Have you used a sequential file system before? > > 4) Have you used a network Database before? > > 5) Have you ever had a course in Data Modeling? > > 6 Have you ever had a course in RDBMS theory? University or commercial? > > 7) Have you ever had a course in SQL? University or commercial? > > --CELKO-- > =========================== > Please post DDL, so that people do not have to guess what the keys, > constraints, Declarative Referential Integrity, datatypes, etc. in your > schema are. > > *** Sent via Developersdex http://www.developersdex.com *** > Don't just participate in USENET...get rewarded for it!
- Next message: Vadim Rapp: "Re: Return only last dataset from involved SP?"
- Previous message: Anith Sen: "Re: Cascaded updates/deletes via SQL-DMO Key?"
- In reply to: Joe Celko: "Re: UDF returns table to 'feed' a call back to itself ... how? (cross post)"
- Next in thread: Joe Celko: "Re: UDF returns table to 'feed' a call back to itself ... how? (cross post)"
- Reply: Joe Celko: "Re: UDF returns table to 'feed' a call back to itself ... how? (cross post)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
