| |
| |
| |
|
Page: 1 2 3 4 5 6
Comments:
<0> hi
<0> i do DECLARE @InventoryID int SELECT @InventoryID = InventoryID FROM Inventory WHERE UPC='060413221744' what will be the value for @inventoryid after query? i checked, its not null nor empty string using sql express 2005
<1> how am I supposed to know what it will be?
<1> what does your query return?
<2> the same as select InventoryID FROM Inventory WHERE UPC='060413221744'
<2> heh...what is pgsql, "Pugnatious Girl SQL?"
<0> sorry, i meant ***uming there is no row with that upc
<1> postgres sql
<1> then it would be null
<2> it would be null if that row doesn't exist
<0> i did if @inventoryid=null but it does not meet the condition
<3> actually
<3> it just wouldn't get set
<2> but if you print it, it'll be blank (I think)
<1> nothing can = null
<3> it would be whatever it was before the select statement
<1> not even null = null
<0> tenfour: i think you make sense
<3> i know i make sense :P
<2> right you have to say "is" null
<0> ah
<1> look at us working together.. its so cute
<0> Guest1: yah that solved it.
<0> thanks every one
<4> this ****en Guest1 guy is ghey
<2> Quant is looking for a tity so he can be a actualy Quantity
<2> BTW select this=null does work
<3> it depends on the dbms/ansi null option
<2> declare @this varchar
<2> select @this=null
<2> print '-'+@this+'-'
<2> that prints blank without the divots, though
<5> because you're trying to concat null with other strings
<6> divots?
<2> my terminology
<5> your rdbms is set to return null
<6> **** your teminology
<7> i have a field i wanna change
<5> i agree
<2> heh
<7> i have a field in a table where i want to change all it's values = x to values = y
<2> its kindergarten hour here on EFnet #SQL
<7> what is the statemetnt for that ?
<1> hour?
<8> Guest1 : null + anything = null
<2> heheh...right hour is being kind nice, isn't it
<2> heheh
<5> guest gets kicked one too many times
<5> i think he wants banned for a couple days
<6> no such thing as too many times
<5> he needs time to grow up
<5> han, you want `update`
<7> what is the syntax
<3> rtfm dude
<2> hey HaN: update thisTable set x=thisTable.y where {filtering}
<6> HaN : the syntax is in the documentation
<5> syntax is in your rdbms' manual
<6> http://www.rockpapersaddam.com/one.html
<6> http://www.overheardintheoffice.com/archives/001886.html
<6> pretty much my day...
<9> at oracle we had to have other peoples brats come in on shadow day
<9> a whole school would come
<10> :P
<2> you guys see this: http://www.imdb.com/help/show_leaf?jobatimdb#software
<2> imdb uses mySQL and postgres!
<3> cool i'm in seattle
<9> glad i have imdb banned at work.. one of our super duper coders may see that and leave
<9> ahahahah
<2> heh
<2> Experience in database interfaces such as ODBC/JDBC is helpful but not required
<2> hahahaha
<10> i wonder how many employees imdb has
<2> "IMDb is owned by Amazon.com, but we operate separately and have our own technology systems. When you join IMDb, you become a full-fledged Amazon.com employee - which means you enjoy the cohesive work environment of a small company while also gaining the bigger benefits of working for a Fortune 500 company. It's the best of both worlds.
<9> but you have to work with british idiots
<10> boo
<3> i live right by the amazon building
<2> I worked at Real.com for awhile in the late 90s
<2> they moved to that elliot bay building
<3> Guest1 you in seattle?
<2> no any more
<2> lived there for 12 years though
<9> i should go shooting tonight. try out the bow i bought last year
<3> cool
<2> I remeber all these kids going to work for amazon thinking they were going to do web stuff and ended up stuffing boxes!
<2> ...in the warehouse
<3> that's weird
<3> did they pay them dev salaries?
<2> well thats where they really needed the labor, apparently
<3> or was it one of those "i don't know what they're paying me... but i get to work for AMAZON!!!"
<2> no, and these folks were entry level web types too
<2> I also rented an aprtment from a guy who was apart of amazon when they were 10 employees, even in 98 he was already pretty rich...he owned the house I was renting, paid cash
<10> Ok I have a question and I posted in here to make it easier - http://pastebin.com/658572
<3> select project_type, sum(employees_***igned), max(date_***igned) from t group by project_type
<2> earliest dat or latest date?
<3> oh oops
<10> earliest, so min right?
<3> min(date
<2> right
<10> hmmm
<2> tenfour's got it
<10> odd
<10> ok one sec
<3> you can tell i don't want to work today :(
<3> i am writing code to export a linked msaccess table to excel :(
<2> w00t
<2> heh
<10> heh, just for fun?
<3> are you nuts?
<2> "All software positions require a minimum of a bachelor's degree in computer science with three plus years of industry programming experience. In particular, we're looking for applicants who are skilled in Perl and able to develop systems, not just programs. "
<10> yes!
<2> Perl is bolded...heh
<10> fun!
<6> hahahaha
<6> degree-qualified people who can write "systems" exclusively in perl
<6> ffs
<3> changing the world one punctuation symbol at a time
<6> reminds me of a job i was offered a couple of years ago - they (the client) wanted 5 years experience of visual studio 2003
<6> i told them they were a bunch of cunts
<3> haha
<10> Ok new question, more explained :D - http://pastebin.com/658603
<10> actually same question, more explained
<6> no-sweat : wrong paste site, cunt
<10> what am i suppose to use
<10> i just googled that
<6> the one in the rules
<10> well whats the difference?
<10> there it i!
<10> s
<10> k
<10> here http://sql-servers.com/nopaste/?show=542
<6> the difference is you used the wrong one
<6> ok, first of all, 'project_type' should be normalised
<6> plus the design is broken if it only has a date_***igned and not a date_un***igned column
<10> yeah i know im not done with it
<6> date_***inged col in the sample/required output s also proken
<6> broken
<6> on what basis would it be the same value for all?
<6> seems like your fundamental concepts are fatally flawed
<10> why
<6> [23:13:47] <10> why <- is that a question?
<10> no
<6> good
<6> so answer *my* questions
<10> whats the question
<11> HYZ
<6> [23:12:51] <6> date_***inged col in the sample/required output s also proken
<6> [23:12:55] <6> broken
<6> [23:13:10] <6> on what basis would it be the same value for all?
<10> it would be the same value if it did what i wanted it to, which is take the earliest date for each project type
Return to
#sql
or
Go to some related
logs:
samie.pm
libapache2-mod-perl2 10MB
#worldcup
slow speed debian samba
#politics
openssh ssh2 sftpd debian
tia carrere tie domi
samba encrypted credentials file
#politics
salvia divinoroum
|
|