| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> walbert i don't support and no one else supports that ugly hack
<0> please look into getting it fixed the proper way if possible
<1> yay union
<2> :shrug: it's by design
<0> :/
<3> yes, the force will be imbalenced if you don't
<2> blank row = creates a header in table A
<1> broken as designed
<0> who says you must continue to use broken designs
<4> heh
<2> populated row = creates a detal row linking to header row just created
<2> the VP of operations that made the ERP system purchase decision :p
<2> hah
<0> walbert at least you don't work for the hoover dam
<0> "the concrete is leaking, let's get some duct tape"
<2> yup
<2> sadly, this whole task is my way of fixing an even bigger hack
<0> who should they fire?
<0> you or another guy for doing the first hack
<2> well, i'm sitting in his chair at the moment
<5> you it is
<0> i'd fire you if i could and replace you with a small script
<0> :(
<0> then give you a tshirt "I got fired and replaced with a small script"
<5> Darken|: be nice man
<2> replacing people with small scripts is my job description
<0> that shirt is funny SicLuDe
<2> you can buy those?
<5> if everyone was doing everything properly... id lose my job
<5> :)
<0> yea something like that one walbert
<2> i could have them in stock
<2> we had one girl who's entire job was to look up what certain customers paid for certain SKU numbers
<0> 10 liner
<5> we have one here who's job is to just yell at people ...
<0> fired
<5> shes the project manager
<0> SicLuDe motivational speaker
<0> manager
<0> not fired
<0> manager fires you :(
<5> she motivates me to shoot her
<5> and shes not even my PM
<5> i just wnat to kill her on general principle :)
<2> hrm, hard to use UNION with date fields
<5> walbert: i mentinoed that
<5> you can select NULL
<2> hm
<5> and have your special app handle null differently
<5> bt theres no real such thing as a "blank" date
<5> or a blank integer
<5> well i guess there is.. its NULL :)
<0> i can write a blank integer, you tell me how you wish to interpret it
<0> integer: <blank>
<5> ...
<6> Quant: thanks! your UDF idea worked beautifully, and 2 orders of magnitude faster
<5> lol
<6> :)
<7> hansbrix what lang did you use?
<7> oh nm i thought you meant ext sprocs
<8> is there a function in sql that will add up all the values in a particular field in a table ?
<7> dmss select sum(****) from crap
<8> orit eok
<8> thanks
<9> you need a britta water filter
<9> they work!
<2> camofrog: filtered water, bleach, and infant urine are still filtered water, bleach and infant urine
<10> and not just infant urine
<10> fat guy urine too
<9> BUT, with filtered water, your taste buds are ****ered into believing that you are just drinking normal water
<9> which allows you to keep it down
<2> what are the benefits of your brita filter over say, LSD?
<9> price
<5> LSD is illegal?
<11> wouldn't lsd be cheaper? ;)
<9> don't know. how easy it it to find lsd?
<9> you can't walk into safeway and pick some up
<12> I don't know... how easy is it to find depression and suicidal thoughts?
<13> i'd like to have a function that receives a string with multiple numbers (eg "50 20 30") and returns all the rows in which the key matches any of the numnbers. is it possible without multiple queries?
<5> eg: you would need to parse the string
<13> ok
<13> I know
<5> what rdbms?
<13> one solution is to generate a query with multiple conditions - where id = 50 or id = 20 or id = 30, etc, etc. but it seems to be wrong
<3> replace the spaces with commas and do and a where with an ID in (@mynewlistwithcommas)
<5> @sql = 'select * from table1 where somevalue in (' + replace(@searchstring, ' ', ', ') + ')'
<5> exec @sql
<3> I think so
<13> i can have commas in the first place and save the replace function. let me try. thanks
<3> heh
<3> don't throw those commas out
<14> use them in a salad
<13> thanks!
<1> heh
<14> you know... identify theft cost 6b$/year... but illegals on social services support, and also millions of felons in jail cost us 200b$/year.
<14> interesting.
<14> but the hippies love their felon illegals and dont let us get rid of them.
<15> Hi using msde, Suppose i have a sproc with @parameters @1 @2 @3. If i use these parameters in the where clause, but no in the same order as i declared them
<15> would it show same results ?
<15> instead of where @1 and @2 and @ 3. i use where @2 and @3 and @1
<5> ifreezeu: define "use"
<5> do you mean that you call the sp with diff. parameters?
<15> oh no sorry
<5> give example
<15> u know on the top of sproc , u define parameters as @weekday nvarchar (10) = 'ALL',
<15> @product_category_id int = 111,
<15> do i have to use them in the same order in the where clause
<5> no
<5> heh first stored proc?
<15> no actually over few hundereds :)
<15> but the reason i asked, cos when i change the order of those parameters in my sproc
<15> the results differ ?
<15> i mean order in the where clause
<5> shoudlnt
<5> well do you have an order by clause?
<15> Oh no
<5> if you dont have an order by clause, then the order is not gauranteed
<15> k sorry i dont mean sql query order
<5> ok how are your results differing?
<15> @weekday nvarchar (10) my first parameter , 2nd @product_category_id int = 111
<15> I shoudlnt get any records insted i get 4
<5> and if you change hte order of hte parameters you get no records
<5> ?
<15> k when i do this
<15> when AND (@weekday = 'ALL' OR DATENAME(dw,TblOrder.endtime) = @weekday)
<15> AND (@product_category_id = 0 OR BPC.product_category_id = @product_category_id)
<15> i get 4 rows
<15> but when i do, when (@product_category_id = 0 OR BPC.product_category_id = @product_category_id) AND (@weekday = 'ALL' OR DATENAME(dw,TblOrder.endtime) = @weekday)
<15> i get no rows , as i should
<16> I think you are not showing us your whole story
<5> ya
<15> oh k
<15> let me paste the whole of it
<16> and stop pasting pointless querys in here
<5> what you are saying does not make sense
<5> i was thinkig some sort of short circuit but i highly doubt it
<15> i know, but i swear it keeps on happening to me with most of the sprocs
<16> sounds like a pebak error
<15> guys appreciate your help , time and advise
<15> mrs shouting for food, be back
<5> im out
<3> so is there a brokeback error in sql2005?
<3> well good
<17> the water prolly did
<17> whats the name of hotel its at?
Return to
#sql
or
Go to some related
logs:
#worldcup
#beginner
yapiee
I aint got no body
#computers
#netbsd
#gentoo
#stocks
#photoshop
debian 82573 supported
|
|