| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> they allow irc at microsoft?
<1> Plenty of MSers IRC.
<2> hmm lets do alittle test
<2> startkeylogger
<0> oh now i remember.. some of the PowerShell developers stopped by frequenly on PowerShell channel...
<1> MS has a very lax internal security policy which probably explains much of their problems.
<1> RJ: The DCC one is much more immediate\
<2> stopkeylogger
<3> what kinda problems?
<3> hehe
<2> stopspy
<2> aww no one with norton firewall
<1> Give it a couple. That one causes ping timeouts eventually.
<1> The DCC one knocks 'em immediately.
<3> lol
<3> norton is a **** company
<3> the only good thing they had was Norton Commander
<3> i was like wow, holy ****, it can't get better than this
<2> them buying veritas pissed me off
<2> first ghost
<2> then this
<1> I think Norton had a deal with Intel and AMD to make systems appear slow as **** in order to drive sales of new hardware,
<2> how many good companies can they ruin
<3> haha yea?
<3> i think just **** code
<4> huhu
<0> Arrakis:: whenever you say "huhu", do you actually mean "w00t w00t"?
<3> lol
<3> whaT?
<0> i am lost.
<4> if that lets u sleep bettersure
<3> sleep with males or females?
<0> Quant:: why did you have to leave out trannies?
<4> cuz we dont like narbs
<4> duh
<0> bah ;)
<3> oh where's that faggooot?
<5> I have a table with a primary key field and another field with ID values that point to that primary key
<5> select id, name, parentid... I want to display both the name of the employee and the name of the parent employee kind of thing
<5> I'm stuck :( Using sql server 7
<6> so join it
<5> with itself?
<6> sure
<2> but thats sqlincest
<6> and its ***y!
<5> hahah
<5> so select name, [what to put here to get the parent name] from emps inner join emps on emps.id = emps.parentid?
<5> I imagine I can't just put select name, name :(
<2> i think you are the first person ever to need to do a parent child query
<5> well... how does everyone else do it?
<5> I want to keep one table with employees, and the parent represents the person that that person reports to
<5> you know?
<2> select grandparent.name director , parent.name boss , child.name brat from employees inner join employees as parent on employees.grandparent.id = boss.employeeid inner join employees director on parent.bossid = director.employeeid
<2> 3 levels of examples for you. paypal@uglyduck.com
<5> how much?
<2> how ever much it helped you
<5> well lets negotiate... how about $15.00?
<2> http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=14099
<2> http://www.dbmsmag.com/9603d06.html
<2> http://expertanswercenter.techtarget.com/eac/knowledgebaseAnswer/0,295199,sid63_gci978892,00.html
<5> haha
<4> heh
<7> YAY ARRAKIS
<7> you're following me!
<8> Hi - I'm using MySQL 5.x - my table has 2 columns - LOGTIME (DATETIME) and ACTIVE (INTEGER). I'm trying to make a query that will return a single result containing the average # in 'ACTIVE' in the last 1 hour...
<8> I tried "SELECT AVG(ACTIVE) WHERE LOGTIME > ?" using a Java PreparedStatement and replacing the ? with a Timestamp that is equal to 1 hour prior to current time... but it returns a result of 0
<9> make sure your time format is the same
<8> it's the same as how it was used to populate the table... not 100% sure how the PreparedStatement decides to format it though... but I used a Timestamp object to populate and a Timestamp to try to do the select
<8> so the query itself looks ok?
<9> try it in your client first, then figgure out how to format it in java
<8> query works in the client... I'll have to sniff around with what Java is doing then - thanks - at least I know where to look now
<8> hmm - timezone difference issue between the reporting client (remote) and the data collector (local to the server)...
<8> ok - gotta figure out which part of this is losing GMT and picking up the local timezone
<8> cya
<10> hi
<10> I have this query... I have a table let's say countries that has an id, and a name. Then I have another table that has a column country, and that column can be Null... I want a query that returns this other table, with the country name instead of the number if it's not null, and a space or a "not ***igned" if it's null... can that be done?
<9> Milkk sure use a case statement
<7> anyone have any idea how to convert: 241364272840798443 to a datetime? i pulled it from a foxpro database..
<9> heh
<11> owned
<11> wth i am supposed to be zZzz
<12> i dunno, i can just look at that and see april 3, 1983
<12> i'll tell you the time for a quarter
<12> it's a simple robbins 2-part julian (with the check digits)
<13> anyone know how to get your SQL 2005 maintenance plan to delete old backups from disk
<13> each backup has it's own datestamp, it would be nice if it got rid of backups more then a few days old
<13> There was an option for it in sql 2000
<13> Oh, I see
<14> morning
<14> I've got a table1(ID[primary key], name) and another table2(ID, date)... Table2 contains many dates for one ID(same ID's used in table1) I'd like to SELECT all entrys out of table one with the latest date column according to the id out of table2.. is it possible with mysql?
<15> MSSQL 2000: In a couple instances when I've tried to replicate one of my DBs or use DTS to copy it to a remote server, I've received errors that seem to indicate bad object references but in some cases, the object does exist, in others, I can't find out where the object is being referenced from. This tells me I need to do some sort of audit that I'm not sure exists. That make sense? Any suggestions?
<16> is there some action that needs to be taken for sysobjects/syscomments tables to be updated?
<16> seems to be returning incorrect results when i query them
<15> Question restated: With MSSQL 2000, how can I identify/remove invalid object references systematically?
<17> Sabba: define "invalid object reference"
<3> yo
<17> yoyo
<17> dude been tryin gto get in touch with ya
<3> lol
<3> no irc from work
<15> SicWork: Any reference to an object within a given DB which does not exist. IOW, maybe i've got an old UDF that depends on a table, view, or another UDF which no longer exists. How could I identify that UDF/view/SP?
<15> I'm not even sure that's my trouble, but I'm getting errors with DTS such as "Invalid object name 'dbo.fBatchStudentStats_SOURCE'." when that object very clearly exists and by that name. That makes me think I'm just not seeing a spelling difference or something along those lines. That got me thinking it might be a good idea to clean up anyhow.
<18> sabba, maybe its not dbo?
<19> Im having a problem with fulltext index in ms sql 2000, when storing html/xhtml, wordbeaker for <strong>fat</strong>
<19> how to deal with that..
<19> I have neutral wordbreaker now
<15> dfworking: It is dbo. I'm leaving room for the possibility that I'm not seeing what right in from of me, but DTS is choking on 3 objects so far that clearly exist. What's more, is that if they didn't exist, why would the DTS wizard allow me to choose them (or it choose them itself when 'all objects' is selected)? It makes no sense.
<18> well, there are plenty of instances where sqlserver allows you to do things at design time that eat **** at run or compile time, so no surprises there
<18> can you add an actual check to see if the object exists
<15> Hmm, just realized that I'm using the "Include all dependent objects" option (it's a default).
<15> Gonna try again w/o that. Maybe dependancies are being identifies by an object Id (or some sort) instead of name?
<18> possibly
<15> Like when a view uses SELECT * and the referenced table changes, the view must be re-build/altered?
<18> yes
<18> i don't use dts enough to know how it may need to be 'recompiled' though, but it could be similar
<15> I'm thinking that's my trouble now. I think all the objects giving me trouble so far have been views come to think of it. Maybe other views are referencing them by sysobject.id instead of name so I see the object existing by name, but that's not the same object.
<15> So the question now would be, how do I detect these references and update them?
<18> do you expect the views to be changed often? its something you need to include in the package?
<18> lol, holy ****
<15> I don't expect them to change much if at all.
<15> ?
<18> exec sp_refreshview 'viewname'
<18> someone got something right i guess
<15> LoL
<15> Now if I just find sp_foreachview (not sure there is one, but there is an undocumented sp_foreachtable or similiar)....
<15> sp_MSforeachtable and sp_MSforeachdb exist. Maybe I can adapt
<18> you want to list the views you have?
<18> i can give you that
<20> yoyo
<15> Please. I'm looking at sp_MSforeachtable and it's not as straight-forward as I had hoped.
<18> sec
<15> exec(N'declare hCForEach cursor global for select ''['' + REPLACE(user_name(uid), N'']'', N'']]'') + '']'' + ''.'' + ''['' + REPLACE(object_name(id), N'']'', N'']]'') + '']'' from dbo.sysobjects o ' + N' where OBJECTPROPERTY(o.id, N''IsUserTable'') = 1 ' + N' and o.category & ' + @mscat + N' = 0 ' + @whereand)
<15> That ugly or what?
<18> SELECT ltrim(rtrim(s.name)) AS name, ltrim(rtrim(s.type)) AS type, s.status, ltrim(rtrim(su.name)) AS owner FROM sysobjects s INNER JOIN sysusers su ON s.uid = su.uid WHERE ltrim(rtrim(s.type)) = 'V' AND s.status >= 0 ORDER BY name
<18> if you need the object id, you can add s.id in there as well
<15> Thank you
<15> hehe, just adapted sp_MSforeachtable changing the IsUserTable to IsView and now I can run:
<15> sp_MSforeachview @command1="print '?' exec sp_refreshview '?'"
<18> nice
<15> This errors out on any view referencing a non-existant object and tells me which view it was!
<18> not sure why they didn't include those kinds of catalog procs other than sp_tables
<18> sp_views, sp_procs, etc
<18> would have been useful
<15> Dunno, but if I can figure it out, can't be hard to do them all ;)
<15> Wow, had a lot of bad references.
<21> sql2k5 cluster, i've got both the data and transaction log drives that are visible in management studio, how do i make another shared drive, say for indexes visible?
<10> Hi I have this table, say country, that has id and a name, then I have this other table, let's say customer, that has a column countryId that has the id from that table, or null if the country is not set... I want a query that returns the customer with the name of the country if it's not null, or null (or a '') when the country is null... I have no idea how to do that
<22> query it as normal it should always return null if its null :P
<22> null being nothingness and abyss
<22> or use a left outer join
Return to
#sql
or
Go to some related
logs:
#windows
#solaris
#computers
#gentoo
#delphi
#sendmail
neil cavoto
msn messenger has made several failed
Application server is busy. Either there are too many concurrent requests or the
#worldcup
|
|