| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11
Comments:
<0> wow
<0> $25,000 per processor
<0> for a crosstab function
<0> in sql server 2005
<1> OLAP ships with versions less than Enterprise
<0> not fully featured
<0> whatever. i dont need microsoft products to do data mining
<0> www.r-project.org
<2> I dont need your advertizing
<0> yes you do
<3> heh statistical versus data mining
<4> Obviouslly, the only thing sql server 2k5 ent edition does is crosstab. So, yeah, you should apply the whole price just to that.
<1> <cough>He's gone</cough>
<4> Yeah, I saw. Just a general rant aimed at stupidity.
<5> what's the syntax for selecting the first N bytes from a database field? or is there this capability?
<6> ngDev : what sort of database field? which rdbms?
<5> currently it's just a "longtext" field, on pgsql database
<6> "longtext"?
<5> actually it's "varchar"
<5> character varying
<6> then "substring()"
<5> hmm, let me try that
<7> good afternoon people
<7> MSSQL 2005... with the msdb.dbo.sp_send_dbmail... the parameter @Query=N''... How can i execute this @Query with parameters
<7> any takers?
<8> concactenate your dynamic query into one value
<8> then execute that
<8> or call a stored procedure...
<7> right
<7> if you call the mail it has a parameter @query
<7> lol
<8> yes, i know
<7> it doesnt have like an execute (Query
<7> it is simply a parameter
<7> it execs everything together
<7> as in so:
<7> http://sql-servers.com/nopaste/?show=346
<7> i creat the body early
<7> before this
<7> witha query also
<7> but i want an attachment
<7> with a seperate query
<9> When I have a query as simple as this "SELECT DISTINCT ReleaseYear FROM Games", what would cause it not to select the first distinct value?
<7> ordering
<10> maybe your forgot to commit the change?:P
<8> QmAIlpadi, i dont think that will work.
<7> hmm
<7> you dont think the @Query parameter will execute as the attachment?
<7> or you dont think i will be able to p*** in parameters like a stored procedure there?
<8> i dont think it will execute it as an attachment.
<7> hmm
<7> thats ucks
<8> not with the body already created
<7> right
<9> If I have records with years 1990 through present, it will return the correct result except 1990 will be missing - if I then create a record with the year set to 1989 I get 1990 too, but not 1989.
<8> no, your abusing it.
<7> exactly
<7> i hear ya
<3> DaveJ|UK - you tried ordering by the column you want first in the proper ascension?
<8> wtf...
<8> ive got a simple query that uses NOT IN with a subquery. it works with IN but returns nada for NOT IN...
<9> Arrakis: I'm only selecting one column and it orders by that, but yes I have tried setting ir manually.
<3> SELECT DISTINCT ReleaseYear FROM Games
<3> well that query doesn't
<9> Arrakis: : But then if I order it the other way, using DESC, it misses off the one at the other end.
<3> have anyorder by lol
<9> ye I have tried it, that was just an example
<9> When I use DESC it misses off the last year
<9> it's just weird
<9> access db btw
<9> asp.net
<11> I am looking for help with: I am running an Access Database, that I am accessing through ASP.
<7> try converting to 112 and check it with a greater than sign date > 19980101
<11> I am looking for some hel on how to opulate my tables that are linked together
<7> CONVERT(int, date, 112) > 19890101
<11> Can someone eihtepoint me to a website that could help, or if someone is willing to get me started in a PM? Thanks
<9> QmAIlpadi: to me?
<7> yes
<6> yonahs : would you like to ask a specific question?
<7> is it 4 digit distinct YEARS or the whole date
<7> and is year a varchar or char?
<7> or is it an int
<11> no, not really, I am looking for a starting oint on the SQL statemt,
<6> yonahs : your starting point should be "F1"
<7> ;)
<12> If I have this: http://sql-servers.com/nopaste/?show=347
<11> When I have hte data to populate 2 diferent tbales, but htey are linkedd to each other, HOw do get it that htye are using the right rimary Key as the link, when Acccess only creates it when the record gets created
<11> Where is there an F1 when writing AS code?
<12> there are 14 types i want to select only the newest by date
<12> how can i accomplish this?
<11> sorry, thats should have been ASP code
<6> yonahs : F1 is available while ms-access is open
<11> I'll try there and see what happens
<7> ORDER BY [date] DESC
<12> right but if i want only the top 1 from each type?
<7> from each?
<12> 14 types
<7> tblPUBTYPES.type = 1
<7> lol
<7> you want all?
<12> i want to select only the most recent document from each type
<1> heh, pubes
<12> Halo: I should have let Purple tell me.
<9> QmAIlpadi: I've tried it as an integer and a text field - exactly the same
<7> hmm
<13> is there anyway in sql server to provide criteria against a derived field?
<4> Hello, I have never used sql before. Could someone please help me write a query that will cure cancer?
<9> ima reboot
<9> brb
<1> UPDATE persons
<1> SET cancer = 0 WHERE cancer = 1;
<13> update
<13> oh missed first line
<6> ron_frown : you mean "where field_a + field_b = 'wibble'" ?
<7> whats your pk GmOney
<7> whats distinct here
<7> is this [ID] unique
<13> or perhaps a better inquiry would be, can I provide criteria in a join to say pull the top 1 record from this joined table
<13> avoiding a subquery alltogether
<13> I do a select top 1 ISNULL(termination,expiration) from table)as terminated
<13> then in my query I'd like to use that terminated field as criteria
<13> and terminated >= specified date
<7> set the select top 1 as a dervied table
<7> then a = b. whatever
<7> oh you do
<7> lol
<4> Halo: You da man.
<7> select * from (select top 1 date = isnull(termination, expiration) from table) as terminated, [table] as whatever WHERE whatever.specifieddate < terminated.date
<7> lol
<9> QmAIlpadi: when i skip the DISTINCT and just write out the whole lot, it displays all the dates OK
<9> or all the years rather
<7> what datatypes are the years
<9> i've tried integer and text
<9> exactly the same result
<7> what are the native
<7> are they char.. or datetime
<9> it just misses off the first distinct value
<7> or what
<9> in access i've tried setting the field type to text and also number (integer)
<9> ah bastard
<7> what is your filter again....
<7> >
<7> <
<9> i think i've found the cuase
<7> or >-
<7> >=
<9> im not filtering at all
<9> when i was checking if there was data retrieved, it was skipping the first record
<7> <8> .... the @Query parameter does execute as the file attachment if @attach_query_result_as_file=1... but still am unable to figure out how to p*** parameters into that @Query variable... It execute perfect with a static select statement
Return to
#sql
or
Go to some related
logs:
#gentoo
americafromfreedomtofacism
#qmail
#red
#politics
#beginner
#nhl
#nhl
python iterate over dictionary
#politics
|
|