| |
| |
| |
|
Page: 1 2 3
Comments:
<0> i scored 100 on their quiz
<0> muhah
<1> http://www.w3schools.com/sql/sql_functions.asp
<1> and that
<2> ohrlyz?
<0> ya RLY
<3> i guess i better read the sql tutorials again
<3> Arrakis:are you the same guy that is usually in asp.net and c#
<0> i am so sleepy
<2> yes
<2> i am "THAT SAME GUY"
<2> *** Arrakis is on channels: #asp.net #marketing +#opera +#sql @#html +#winprog #mscorlib +#c# #photoshop @#webdesign @+#programming
<2> ph43r
<3> whaddup ma nigger
<0> look this guy is either + or @ on most channels
<2> :p
<0> must be a cool dude
<2> so cool
<2> too cool for his shirt even
<0> oh so kewl
<0> i am so sleepy
<0> !*(&
<2> :(
<0> i am about to go to sleep
<4> my client disc-ed... did anyone respond to my previous question ?
<5> oh gosh, i cant type that all over again
<4> copy/paste ?
<4> via private message
<4> please
<6> paste to the url in the topic
<4> dfworking - can you copy paste the messages answering my previous question ?
<4> i didn't see them as irc client disc-ed
<6> i didn't see your previous question
<6> sec, i'll scroll
<6> which db
<4> postgreSQL
<6> try: SELECT age, COUNT(age) AS ageCount FROM tablename GROUP BY age HAVING COUNT(age) > 1
<4> wonderful thanks
<4> If i do a nested select statement... SELECT * FROM blah WHERE name IN (another SELECT statement)
<4> how can i display a field from the inner select statement ?
<1> You can't do it that way
<4> ok, how would i join the two relations ?
<4> over the name field
<1> Why not use a normal INNER JOIN?
<4> ok i'll look that up
<1> SELECT * FROM blah INNER JOIN blah2 ON blah.name = blah2.name
<4> whats wrong with the following: SELECT name, title FROM blah GROUP BY name HAVING COUNT (name) > 1;
<4> it's giving me group error
<4> Attribute blah.title must be grouped or used in an aggrigate function
<7> imdb uses mysql and postgres. I'm havign trouble understanding where mysql fits in.
<5> storing data
<7> That's what postgres does.
<1> They use pgres for the constistant data and MySQL for the inconsistant data.
<1> They use MySQL when a movie has to come out on February 31st
<5> mysql paid them to say that
<5> they don't really
<8> hahaha
<9> I have a table called Issues, and lots of SProcs that pull from this table. Each SProc is p***ed a userID. There's a complex set of rules that determine which Issues a user can see. Instead of having these "rules" scattered through all the SProcs I want to make a View of the Issues table and have all the SProcs pull from that View instead. But Views can't take parameters, so how can the view know which userID to filter against?
<9> SQL Server 7/2000
<7> sounds kinda interesting, though: http://www.imdb.com/help/show_leaf?jobatimdb#software
<2> hmm
<2> wonder what it apys
<2> oh
<2> seattle position not open
<2> :(
<1> Leep: Does it have to support 7?
<9> Halo_Four: Yes, so no UDFs. :(
<10> Arrakis you in seattle?
<7> Arrakis: the dev/db position is. Dev only isn't.
<1> Leep: Well, you can still use a view with a filter criteria.
<1> SELECT * FROM SecurityView WHERE UserID = @UserID;
<9> Halo_Four: Not sure that would help me. There may be hundreds of users, and each user has a vast amount of "attributes" that determine which Issues (s)he can see. The view needs to return only the Issues that the requested user can see.
<1> The server takes into account the criteria when expanding the view.
<7> You could also just write a stored function that returns a data set too if you're too worried about.
<1> This is true.
<9> Does SQL Server 7 support stored functions?
<1> no
<9> Halo_Four: Are you saying that if I do SELECT * FROM IssueView WHERE UserID = @UserID, I can access the @UserID from within the view? The View needs to know the @UserID to look up that user's attributes (and various other info about the user) in order to apply the correct filters to the Issue records.
<7> No, what he saying is you write the view so it returns a giant list of all the users issues, and when you run that query, mssql will basically merge your where clause into the view so everything uses indexes and runs decently fast.
<1> What Drk said
<7> If you can determine one user's issues, then you can do it for all of them.
<9> A single Issue may be viewable by 80% of the users... It's not a one-to-one relation...
<1> SQL Server doesn't run the view by itself and then filter the full results, it expands the view with the statement and merges the plans together.
<9> The subset of Issues that any given user can see vastly overlaps all other user's subsets.
<7> So?
<1> Okay, you would have been done this by now.
<7> You're overthinking it in a big way.
<9> So are you saying the view does the SELECT in such as way that it returns every users' subset of Issues? So there would be duplicate Issue records if I just did SELECT * from IssueView... ?
<4> if i do a inner join.. and get a joint relation over the foreign key between the tables... how can i then interrogate data in that joint relation ?
<4> i.e. SELECT * from blah INNER JOIn blah2 ON blah.name = blah2.name <-- that is my bigger join
<7> Leep: Kinda. There would be duplicates if you did select * from, but its not like the view goes out and keeps a copy of data (unless you make an indexed view), rather when you select from the view, sql server merges you query with the view's query to figure out what to run.
<9> Drk`Angel: Maybe I'm misunderstanding views, or maybe SQL Server is a lot smarter than I thought... You can do more than just a single SELECT in a view, right? This View would need to do a lot of IF ... BEGIN SELECT ... END ELSE IF .... BEGIN SELECT ... END ELSE IF ... There would be multiple different SELECTS that may run depending on the user's ID... but if I'm pulling everything for all users maybe it would be different...
<9> I really need to rethink how to pull the Issues if I'm pulling every user's entire subset... :(
<4> anyone have any ideas regarding my problems
<4> ?
<4> [rpblem*
<4> problem*
<11> what's an error that says it needs to "execute sp_addlinkedserver" in a DTS package? what's the job for addlinkedserver?
<10> why can't you script a diagram?
<12> ?
<13> tenfour: dunno :(
<14> when connecting to a remote server with SQL Server Management Studio Express, should I just connect to: IP\SQLEXPRESS ?
<0> lol
<0> the topic pwns
<15> there is a database interface system that is composed entirely of ASP pages. Does anyone know what it is called?
<11> ADO + vbscript
<11> =)
<15> I mean a premade thing that you can download and put on the web server
Return to
#sql
or
Go to some related
logs:
#beginner
Tekrad
spourt sex
drogendealer.de crack
#linuxhelp
flash stop javascript FLVPlayer_Progressive
RibbonForm
#beginner
#winvista
#solaris
|
|