| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> so, i guess it could include writing 'data' on napkins
<1> is there a method to output a group by say 'manager name' on the first line, and then all the staff under that person on the next lines? output as text
<2> That is a WHAT
<0> WHICH THE **** DID YOU SAY?
<0> w***a, not really
<2> yes
<0> you can just simple include the manager with the staff and format the output in your front end
<2> no
<2> thats stupid
<1> ok that was what i was ***uming...
<0> i know nothing.
<2> both of you are wrong
<2> Rollup
<1> you talking to me rjarret_?
<0> not sure if that will be useful if he's not outputting via qa or something
<2> theres many ways to do it
<1> i would like to output via QA
<2> dont do in the frontend what sql can do
<0> doesn't rollup output the summary line after, not before?
<3> http://www.mrchewsasianbeaver.com/?wm_login=videovault
<1> as the values are all text or varchar, I understand that i can't use compute, what I want though is the 'effect' of the lines
<2> cube rollup or a connect by join will do what he needs
<1> its all on one single table
<1> ok ill bol rollup
<2> w***a http://www.sqlteam.com/item.asp?ItemID=8866
<2> thats almost like what you want but the join method
<0> where are you in the states rjarett_
<2> What state am I in?
<2> I am in pa at the moment
<0> yes, whacht state
<2> in 2.8 hours ill be in nj
<0> my dad was born in scranton
<1> of course it can't be easy
<2> scranton is the ghetto of upper mid pa :P
<0> yes, its the right armpit of the u.s.
<0> the left armpit being pacoima, ca
<4> I thought that was LA
<0> pacoima is 'la' kinda
<2> only thing scranton is, is a walmart, and 50 highway overp***es
<4> pooper must be houston :)
<0> yes, the big gaping rectum of the u.s. is texas for all intents and purposes
<2> miami.. since there is a long turd hanging out below it
<2> texas is only looking like the rectum because of the illegals
<0> well isn't that a pleasant image
<0> heh, running across the borderline
<2> we are plopping on cuba
<0> who knew you could learn so much geography in such a short period of time
<0> they should make schoolhouse rocks using these creative teaching methods
<0> well, i have to go be with people that don't respect me in the least now.
<0> am i still here?
<4> you're working with the french?
<0> touche
<2> maybe if you didnt complain about their proper use of 'what' they wouldnt disrespect you.
<0> i think they say 'quoi'
<0> ****ing french
<5> MS-SQL, if i do a select min(Col), account FROm Table Group by account, what will it return if one of the Col Rows has a NULL in it ?
<2> nvl the column as 0
<2> done
<0> later
<5> ah that works too ;)
<5> th
<5> x
<6> ismellWRK: did u try it out?
<7> I have a field "Day", a field "Month" and a field "Year" in my table and I need to select only users which are 20-30 years old. What's the easiest way to do this considering that I can't modify the database (a unix timestamp column would have been better maybe..) ?
<7> (of course Day, Month and Year are the birth date of every user)
<8> convert that to a sql date
<9> What is the best way to test for the presence of a row? (SQL Server)
<9> i.e. I have a userid, I just want to find out if that userid is in the table at all.
<7> how?
<10> anyone tested Toad for mssql?
<9> I'm thinking something like: SELECT EXISTS (SELECT * FROM usertable WHERE userid = 12345)
<8> november select count(*) from usertable where userid = 12345;
<9> OK yeah that works too
<9> However,
<9> that will go through the entire table, instead of stopping when it finds one match
<11> unless you never heard of an invention called "indexes"
<9> does SQL server support specifying a bit constant?
<12> november2 : what do you mean by "constant"?
<9> like this:
<9> SELECT CAST(1 AS bit)
<9> except without the cast
<12> ms-sql doesn't have the concept of constants
<12> rather, t-sql doesn't
<12> you could do it if you wrote your stored proc in c#
<12> under ms-sql2k5
<9> ah ok
<9> that's kind of neat
<6> november2: y do u need constants?
<13> in sql 2005... when I save an import ssis package, where is it saved to? ie where can i find a list of all my packages within management studio?
<6> Kaine[]: prolly in the msde database
<6> i think thats the one
<6> its one of hte system databases and its not master
<6> :)
<6> i dont have it installed on this computer to check
<13> well i ***ume theres some sort of "package manager"
<6> its stored in a table i think
<13> w/o having to go into the actual db where they are stored
<6> what do u want to do with it?
<13> i just want to see which ones i have already created
<6> blah read in bol
<6> im sure they have it in there
<13> yeah been looking for past 15 mins
<13> ;p
<6> its from teh IE
<6> sorry not IE
<6> from the manager
<6> management studios
<13> ahhh figured it out
<13> you have to "connect" to integration services
<13> and it creates a different object in the object explorer besides the db itself
<13> kinda odd
<13> and from there u can manage your packages
<14> in sql2k is it possible to update an identity column?
<14> i know i can insert using indentity_insert on but can i update?
<15> no
Return to
#sql
or
Go to some related
logs:
#narcotics
#delphi
#politics
qmailrocks intranet@
#politics
#beginner
#sunos
lamers globs
1941 14th Academy Awards: Best Actress In A Leading Role Was won by Joan Fontain
#nintendo
|
|