| |
| |
| |
|
Page: 1 2 3
Comments:
<0> :)
<1> aww smack ... I don't know the structure of #temptable... it gets built in the SP...
<1> I need this to work:
<1> select 1 as nFid1 into #temptable; exec sp_executesql N'drop table #temptable; select 1 as nFid1 into #temptable'; select * from #temptable
<0> no
<0> as soon as you run drop table in sp_executesql you're hosed
<1> yeah...
<1> here is my real problem: sp_xml_preparedocument
<0> create #temptable (col1, col2) exec sp_executesql 'insert into #temptable (col1, col2) select col1, col2 from mysource....' select col1, col2 from #temptable
<1> client app needs to p*** in a few K or Meg of xml,
<0> ok
<1> problem is I don't know the structure
<0> yeah, that ****s
<0> bbias
<1> huh?
<1> be back in a sec!
<1> brinb back a sack lunch...
<2> somehow I allways have a flat taste when I see dynamic SQL or other self modifying code
<1> what is the local paste page?
<3> pastebin.com works
<2> ??paste
<4> For information about paste
<4> see http://rafb.net/paste
<1> thanks - http://rafb.net/paste/results/syQtj679.html
<1> given that VFP (client app) will force the @P1 parameter,
<1> how can I attach the FROM OPENXML(... to an existing #temptable ?
<3> I hear epoxy works nicely
<1> heh
<5> ok english majors, what tense do I use when naming database fields?
<1> singular
<1> I use singular for my table names too.
<2> tables too
<2> :-)
<5> like I have a field called testedsave
<3> which contains what sort of data, if I may ask?
<2> probably bool or timestamp ... but what is the meaning of it?
<0> singular is not tense, when talking about nouns (tense applies to verbs)
<3> and DBAs ...
<2> ah ... don't bother with meaningfull names, just name the tables t1, t2, ... and the columns c1, c2, ... will allways work and you never run into reserved word conflicts by accident.
<6> Makes maintenance really fun too
<2> crrj: if it was hard to write, it should be hard to read!
<6> Exactly.
<5> well should I call it testedsave or testsave or Ihavetestedthesave?
<6> Comments? We don't need no stinking comments!
<5> or thanks,yathisisthefieldnamedtestedsave
<2> ihavesavedthetest
<5> hahah
<0> some people use Has/Have
<0> and there, you would consider tense, as in "past tense" in using "Tested"
<2> havingtested
<2> or in a yodified database, testingIdid
<5> heh
<3> ithinkitestedthissavebutimnotsuresodontrelyonthistotellyou
<5> heh
<0> It depends heavily on the context
<5> how about Ihavebeenavoidingtheakwardnessofaskingyououtonadatewillyougoonadatewithmehavetest?
<0> Does the flag signify whether the entity "was tested" or whether the entity "completed a test"
<2> and the patience of the person doing the code review
<5> whether it was tested
<0> then you would likely use WasTested or IsTested
<2> just tested, no matter if the outcome was positive or negative?
<0> WasTested = "the entity was tested"; IsTested = "The entity is at a tested status"
<5> yes, I have a different field for that
<0> JanniCash, another excellent question
<0> what if the entity can be tested more than once, such as a resubmission to QA?
<0> For example
<3> desc testing >>>> myproj, mytest, myresults, mysavedtest, myothersavedtest, yetanothersavedtest, whatinthehellisthis
<2> yomommalovedmytesting
<5> JanniCash that would be fun wouldn't it
<5> we could specify a policy when naming database fields that must insult a persons mother
<2> is there anything that can invalidate an existing test result without the unit being modified?
<5> yes but I have other fields for that
<3> hmmmmm .... I'm not sure that 'yobitch' would be an acceptable column name ...
<5> well if everyone agreed it was it could be
<5> we could make it part of the hiring process
<5> what insults do you know for a persons mother?
<5> if they don't know very many, they can't get hired
<3> 'yomamaissofatwhenhercellphoneringspeoplethinkshesbackingup'
<2> ... my_other_ride_is_your_momma int references the_dudes_info
<2> xp_prg: the real issue I have with your test boolean is that it seems to be redundant information that can be derived from the other fields.
<0> youmamm***litwidth bigint
<2> and such redundant info has no earthly business in a normalized database schema.
<5> well, I have learned many things today about naming fields, I think we will adopt this new policy
<3> aww, but it's FUN to scatter the same data amongst 13 tables and have no mechanism in place to synchronise it all
<5> it is just a test harness it is not production
<3> ummm
<3> your test harness SHOULD mirror production
<0> "update anomalies..."
<5> how about this idea, a seperate database with havetested in it?
<5> you can't normalize one field
<0> is there a table with test rows in it?
<2> separate database is a bad idea ... unless you use an XA manager or another way to do 2PC, there is the chance the two DB's get outa sync
<0> or is this just a status flag?
<5> just kidding, I honestly wanted to feel elite using the right tense, and it turns out nobody knows/cares
<0> who is this 'nobody' you refer to?
<0> we sure as hell know, for example
<2> TheGambler: there is a "nobody" who has an account on many servers here ... but the heck, that guy never shows up for work and the accounts seem to be disabled for ages.
<5> steal his check JanniCash!
<0> :)
<5> say something funny hurry, I can't stand my work anymore
<0> your database is 3NF
<2> "something funny"
<5> oh the old "your database is 3NF" you caught me off guard with that joke
<5> how about this one, go write a non-trival rollback transaction scheme with webservices on a heterogenious grid using an election based control scheme in realtime
<6> But only on alternate wednesdays, if there is no full moon.
<0> considering most of who comes into this channel, "your database is 3NF" *IS* funny
<5> how about this one, go solve a turring complete computing problem
<5> in polynomial time
<0> go write an enterprise integration solution using best-of-breed practices and processes, leveraging core competencies of key stakeholders to achieve a rich feature set to meet defined goals for deliverables in a multi-channel environment.
<0> ...using XML
<5> how about this: research and deploy an opensource mrp package with full conversion of our current accounting/mrp package by yourself on linux in 1 month
<0> hah!
<2> go design and implement a synchronous multimaster clustering system that does not require either two phase commit or any sort of conflict resolution.
<2> and is fast
<5> JanniCash you can do it, I know it
<0> and it will be FREE SOFTWARE
<7> hi all! I'm doing this query "select sum(stock) as stock, branch_id from stock_view group by branch_id;" but I also would like to show the stock_view.id field, how can I do that?
<7> I know think I must use aggregate functions here, but how?
<1> beyond: max( stock_view.id ) as stock_view_id
Return to
#sql
or
Go to some related
logs:
gentoo python image library
mount ntfs vmware player kubuntu
#ubuntu
+Relay access denied; +cannot receive +postfix
uname -r ubuntu desktop
#css
php $_SERVER['REQUEST_TIME'] calculate
#web
tora fc5 rpm
#debian
|
|