| |
| |
| |
|
Page: 1 2 3 4 5 6 7
Comments:
<0> anyway to lock a table from rows being added, even if a user has permissions? (MS SQL 2005)
<1> yeah http://www.google.com/search?complete=1&hl=en&q=mssql+lock+table
<2> Heh. Why no MySQL? (Not that I care... I use Interbase and MSSQL)
<3> *shrug* but you have to follow the rules. If you don't... well you should watch the movies Saw & Saw II to understand.
<2> I have a column in a table that has a very small range of integer values, and it's a column that will likely have an index on it. Would it be better performance-wise to make it an int instead of a smallint, tinyint, etc.?
<2> In this case, I'm talking about MS SQL 2005.
<2> wo0twoo: It's like the channel I help run... we don't help people who come in wanting help writing yet another stupid chat program.
<4> wo0twoo: i watched saw for the first time a few weeks back, excellent excellent movie
<5> in postgresql pl/pgsql, how can I check eof in a fetch inside a while loop ?
<6> coj!
<7> yar
<7> yar, I say... YAR!
<8> yar
<7> what's shakin' quant?
<8> my nuts
<8> you?
<9> hrm, why am I getting an error when trying to do getCatalogs() on a jdbc db meta data on db2... this worked before, apparently
<7> pfn, something changed
<9> you're right something changed, just can't figure out what I need to do to make it work again
<7> change whatever changed back to what it was before it changed
<8> Halo
<8> you there?
<9> well, I don't know if I can downgrade the fixpack now that it's installed and updated the instance
<9> maybe I should just create a new db, but that's going to be such an *******ing pain
<7> yes, *******ing is painful
<10> rmah: Is it?
<7> Sabba: so I imagine
<8> have you tried anal fux0ring rmah?
<7> nope
<7> have you?
<9> I hope to never try it as well
<4> i saw this license plate frame once that read "happiness is being too big for anal"
<4> ... just felt like sharing that.
<7> thanks for sharing
<8> heh
<8> rmah, so how do you know that it is painful?
<7> Quant: I don't know for sure, but I imagine it would be
<8> you sounded so sure :)
<4> he was drunk at the time
<8> it's like he knows for sure but doesn't know where he knows it from
<8> rmah: do you have any idea what penii taste like?
<7> Quant: no, please enlighten us
<8> no
<8> i mena
<8> can you imagine?
<7> hmm...no, not really
<8> then how could you imagine *******ing :)
<8> anyway
<7> heh
<8> sup sup
<11> hi
<8> yo
<8> how's it going?
<7> it's hangin'
<8> how low? :)
<4> okay wait..
<7> I refuse to participate in this childish discussion any further!
<12> ok
<11> ..
<7> sigh... taxes
<4> chaching
<7> yeah, for the IRS
<13> someone can help me with ms access ? i am stuck trying to generate a report from one table containing data represented in various ways
<11> " someone can help me with " is not a grammatically correct english sentence. Please try again
<13> can someone help me please
<11> nice
<11> i see no question
<13> ok well
<13> i have all my data in one table
<13> name, level1, level2, level 3, level 4
<13> name is always filed, and level 1 is the minium to be filed
<13> level has a number
<13> so you could havbe somehting like :
<13> fruits, 1
<13> then :
<13> cirturs 1,1
<13> citrons 1,1,1
<13> orange 1,1,2
<13> all i want to do is to generate a report showing my data properly, in a tree style way
<13> there are more levels for example"
<13> bakery 2
<13> and so on ...
<13> if the field is empty that means it's a the top of the others
<13> and of course if you have 1,1 and 1,1,1 it means that 1,1,1 is underneath 1,1
<13> ?
<13> i need some help please ?
<2> Does anyone know whether SQL Server has a date-only data type? All I see is datetime and smalldatetime.
<14> I have a basic problem. I'm creating a simple report where I distinct the result, although I want the count of rows being distinct. http://sql-servers.com/nopaste/?show=387
<14> It shows 1 on the count, although I know there are several instances with more than one
<15> use count with group by, not with distinct
<14> In that case I will receive dupes because one or more of the columns are unique (the date ones)
<14> I want to distinct by username and count by username
<14> oh well
<14> nm
<15> and using subselects?
<14> I see the problem
<14> I was thinking stuid
<14> date is not relevant in this context
<15> ah then removing that field solves it then?
<15> -then...
<14> yes ofcourse :)
<16> #vbhelp
<16> oops
<15> #pinkriders
<15> oops
<16> hey tor
<15> hey
<16> how's things?
<14> hiya Yuppie
<14> never been better
<16> hey pose
<15> great, just started brainstorming with my fellow programmer about rebuilding our website engine
<15> which will take a couple of months
<16> nice... i just ordered another beer
<14> hehe
<15> I hope that doesn't take a couple of months to deliver
<16> nope - already arrived... beer 2.0
<15> sweet
<15> so it has good dataflow?
<16> well, it deployed cleanly
<16> input is great... i'll let you know about output after the processing is done
<15> frequent dumps needed?
<15> or flushes
<14> yeah flushing is important to clear the instruction cache
<16> yah - cache coherency becomes an issue
<15> bet it influences invironmental variables a lot
<14> I usually get a blue screen when I drink to much beer
<16> damn - 70 year-old guys should NOT wear speedos
<16> sitting by the pool has its downsides
<15> haha
<15> especially when all the fembots are working at the office and only old timers are there ...
<13> i have a querry that i would like to display in a report, how can it be done ?
<13> it's with ms access
<15> using the wizard should do it I guess
<15> waving your mouse around
<17> Hello everyone! Is there an easy way to step thru a lots of rows in a table, eg. i want to find first non filled row in my table with 10000 rows, and as i do it know i loop it within php and check with a query every loop if that row is filled, but is their a way to optimize this with native sqlqueries?
<15> you just make a query that selects your "non filled row"
<15> select field where otherfield is null
<15> or where otherfield = 0
<15> or where otherfield = ''
<15> depending on what you need
<15> and as for "the first", that depends on your rdbms
<13> no it does no do it ....
<13> i want the querry to be process
<15> but there is a report wizard isn't there, Zoroxstar?
<13> ie go in order from top to bottom
<13> yes but i don't want the fiels to be displayed straight underneath each other
<13> let's say i have :
<13> text1, 1,2,5
<13> and text 2 , 1,2,5,6
<13> well i would like text 2 to be displayed not underneat text 2 but in tab further
Return to
#sql
or
Go to some related
logs:
#politics
#fedora
#nhl
#politics
missing episode book of daniel
#winxp
#stocks
#politics
#beginner
#freebsd
|
|