| |
| |
| |
|
Page: 1 2 3 4 5 6
Comments:
<0> anyone here familiar with function dependencies ?
<1> just ask the question
<0> if a->b can you write a->ab ?
<2> he is actually a psych major and taking a poll is his final thesis
<1> haha
<2> by ab do you mean a*b?
<0> no
<1> sql doesnt have a operator ->
<3> tenfour : no
<1> ?
<3> tenfour : ignore that - saw your last post and misread it as a question
<3> [22:43:09] <1> sql doesnt have a operator ->
<4> Is that no MySQL and no Homework or no MySQL-Homework ?
<1> no to both
<1> #mysql
<4> Thanks...
<3> jadz` : why, do you have a mysql question that is not homework related?
<4> Yes. Is there any reason that you can't use the same table in a subselect as in the main select ? http://sql-servers.com/nopaste/?show=229
<3> too bad - we don't do mysql here
<4> Indeed. I was hoping there was a way to do that type of query without a sub-select and without having to do it in two queries but I don't think it is possible.
<4> I want to return all fields from rows with a MAX() date and grouping by a category. From my limited understanding the problem is that not all my fields are in the GROUP BY.
<5> from my limited understanding its a failure to
<5> a) read
<5> b) understand
<5> c) comprehend
<5> d) seek help in the appropriate channels
<6> ugh no mysql...
<6> is there a channel for mysql specifc questions?
<1> heh
<5> see
<5> thats why epople hate mysql
<6> heh
<1> i'm beginning to understand
<5> its not because its a ****ty database that still to this day doesnt impelemnt half the ****ing stuff dbs 5-7 years ago
<6> ya i know
<1> but i still think the onjoin should tell them where to get mysql help
<5> its beacuse they are soooooo ****ing stupid and in capable of reading directions or comprehending
<5> or even taking a solid guess at something
<5> no
<5> i think that anybody stupid enough not to realize where to get it
<3> MrMr[iCE] : the channel you want is called #mysql
<5> should just plain and simply be that stupid
<3> who'd have thought?
<6> thank you.
<3> dumb****
<5> <34
<5> <3
<7> does anyone know where the import/export optionsn went in sql server 2005?
<8> (http://sql-servers.com/nopaste/?show=232) Hi, I'm new to SQL and I'm getting some starnge errors and such from a couple of queries...
<1> in mssql2k5, how do i group by a cluster of columns? like if the table is {{a,1} {a,1} {a,2} {b,1}} how can i group it and get back {{a,1} {a,2} {b,1}}
<9> is 'cluster of columns' a data type in sql2k5?
<1> no, i just mean multiple columns
<9> cause ... col1, col2 ... if it is {a,1}, {a,2}, {b,1} ... order by col1, col2 ... is sufficient
<9> and has nothing to do with 'group by'
<9> if you want all of your 'a,1' to group together ... group by col1, col2 ...
<9> fairly simple and basic practice ...
<1> if i group by col1, col2 then i will only get back {a,?},{b,1}
<9> no ...
<9> you get back ..
<9> {a,1},{a,2},{b,1}
<9> you'
<9> you get a group of col1's ... with sub-groups of col2 inside
<9> tenfour: try things, before you knock them ...
<1> trying now
<1> hehe of course... makes sense to me now
<1> thanks for the help
<1> (mssql2k5) what is the syntax to do something like select a from (select ... union all select ...) group by a
<8> I want to delete an entry from a table, but another table is referencing to that entry, so I have to delete the entry in the referencing table first. How can I do that if the criteria for deletion is not in the referencing table? =P
<9> tenfour: the same as it is with sql2k ... or any other system
<9> BlueCafe: the referencing table has the criteria ... heh
<9> it's using to enforce the constraint ...
<8> so what is the syntx for that?
<9> table A has 'id' and table b has 'id2' ... table a has what you want to delete ... so you know your deleting everything from table b where it's 'id' column matches the same as the 'id' column in table a
<9> BlueCafe: you could have just setup your references properly, and done cascading deletes ..
<1> MoZ i figured, but i don't know the syntax on any system
<9> tenfour: you had it ... lol
<9> select a from (Select ... union ... select ...) group by a
<9> lol
<1> hmm i tried; gave an error
<9> just have to make sure there's a column named 'a' in the select list of the union statements ;)
<1> lemme try with something simple
<9> try adding 'as t1' after the (select ...)
<1> yea the union works by itself
<9> alias the derived table
<1> but when i stick it in a surrounding select it won't take
<9> or better yet
<9> WHATS THE ERROR
<1> i'm chekcing now
<9> why does everyone ***ume being vague is a good thing?
<1> i didn't
<1> i actually closed up shop at work
<1> so i'm opening my rdp session back up to see the error
<8> MoZ: here's my paste...isn't that what I'm doing? http://sql-servers.com/nopaste/?show=233
<9> BlueCafe: read the topic, we don't support homework ... and that SCREAMS 'homework' ;)
<8> yeah it does lol
<1> http://sql-servers.com/nopaste/?show=234
<1> if i run the code between the ( and ), it works as expected
<9> tenfour: the errors' self explainatory ...
<9> fix your **** ;)
<1> just when i try put a select around it
<9> you've got a syntax error near a ')' on line 42
<1> i don't see it
<9> select * from ( )
<9> is all you did to it ?
<1> yes
<9> http://sql-servers.com/nopaste/?show=235
<9> try that ;)
<1> hah
<1> weird
<9> I already suggested it ...
<9> but you must be ignoring me ;)
<1> oh sorry i didn't see it
<1> must have been BlueCafe's homework causing interference
<1> :P
<9> :)
<9> BlueCafe: with proper references, your issue isn't an issue ...
<8> hehe
<9> talk to your instructor ;)
<9> if they won't let you use cascade's ... then the cl*** your in is out-dated and won't get you anywhere in life ;)
<8> so they're not proper right now?
<9> if deleting from a master table, that has references ... fails because items reference it ... then you need cascades ...
<9> cascades are only necessary if such operations as deleting from the master table occur ... otherwise, they should not exist, to prevent master table deletion by idiots ...
<9> otherwise ...
<9> but you also said that your second table that has the reference, doesn't have the criteria ...
<9> but your criteria is 'where gpa < 0.5' or whatever
<9> and you use that GPA column in both delete statements
<9> if GPA doesn't exist in one of the tables, you have to work around it...
<9> something like ...
<9> delete table B from table A inner join table B on a.id = b.id;
<9> delete table B from table A inner join table B on a.id = b.id where a.gpa <= 0.5;
<9> and thats the end of the lesson for the night, no more questions from you ;)
<8> k...that's like 10 times more than they have in my book and the notes....
<10> I'm using SQL Server Express in a .net program. I have been using the query builders to do all the db stuff - keeps my sql stuff separate from the code and logic of what needs to get done. I'm trying to figure out how to p*** in an array as part of a sql query. In other words i'm running a query like: SELECT * FROM MyTable WHERE ID IN (@list_of_ids);, but I'm not sure how (or if it's possible) to specify @list_of_ids as a collection and not
<11> you cant p*** array as param
<10> Quant, oh ok.. is there a way to do a similar thing as a stored proc? I've never written a stored procedure before but if i have to do that I don't mind
<11> you have a few options
<11> actually i am not sure whether you could p*** arrays in sql express
<10> Quant, how would I do it in sql server?
<11> http://msdn2.microsoft.com/en-us/library/ms160951.aspx
<10> Thanks quant
<10> says that sql server express is a valid pre-req, so it should work :)
<10> ok i can't find these dumb samples lol
<10> ok this is all way over my head lol
<11> dude dont be noob
<11> research your **** get it to work
<12> anyone know of a good sql performance monitor ?
<13> mssql? profiler? performance counters, execution plans
<12> for ms-sql sorry
<12> im looking for a third party program
<13> google can probably help you there
<12> yeah i'm looking around, but i thought someone might have a favourite recommendation
Return to
#sql
or
Go to some related
logs:
#beginner
#gentoo
mmsave flash 8
flash attachmovie +flower animation
#politics
Jet DSN 0xe20 Thread
#nhl
#beginner
#windows
#mirc
|
|