| |
| |
| |
|
Page: 1 2
Comments:
<0> can anyone help me with this? http://pastebin.com/662141
<0> hello? anyone not idling here?
<1> "user"='EDC48C6D6A727CE78FB3F48244B984AC' ?
<1> and which table does the userid field belong to?
<2> where did you get it from?
<2> Phyx I dont understand the problem
<0> ok
<0> userid is section9
<2> thats really not what you want to do
<2> you want an outer join
<0> yeah, i figured as much, but i don't know how to do it with 3 tables
<2> http://www.devx.com/dbzone/Article/17403/0/page/3
<3> http://tinyurl.com/lvaxu
<0> ok
<0> taking a look
<1> how can I p*** a NULL to smalldatetime var? Currently it gives me an error, saying it couldn't convert it to datetime type
<4> hi
<4> help on this query ? http://sql-servers.com/nopaste/?show=543
<5> hi
<6> greets dudes happy easter! I have just installed sql server2005 ent on win xp home ed but can't seem to get a server name. can some1 help, thks
<7> can anyone help with http://sql-servers.com/nopaste/?show=544 ?
<8> SELECT daysAged, SUM(NoOutstanding) FROM (yourpreviousquery) GROUP BY daysAged;
<7> doesnt work..(using mssql)..i get the following :http://sql-servers.com/nopaste/?show=545
<7> nm works
<7> stupid t-sql
<7> gotta alias the from with a table name
<7> SELECT daysAged, SUM(NoOutstanding) FROM (yourpreviousquery) p GROUP BY daysAged; works ok
<8> yeah
<7> thanks for your help regardless :)
<9> i would like to know what is a good book to get to learn about oracle (database administration,pl/sql,etc...)
<10> well Alexi5, everything you need to know about oracle database administration is on oracle office webpage documention -> http://tahiti.oracle.com/ | http://www.oracle-base.com/articles/10g/OracleDB10gInstallationOnFedora2.php | http://www.oracle.com/technology/documentation/database10gr2.html | http://forums.oracle.com/forums/index.jspa
<10> http://www.ilook.fsnet.co.uk/ora_sql/sqlmain2.htm
<10> just google
<11> Can I ship my app using a Access database
<12> you asking from a licensing standpoint? yes.
<11> ok, so it's free?
<12> i didn't say that
<11> k.
<11> do you know if it's free?
<12> but you can include an mdb with an application you develop without paying any additional licensing fees
<11> can that MDB execute stored procedures
<12> i think the later versions of access have stored procedures, or something like then
<12> them
<12> been years since i've used it personally
<11> ahh
<11> I'm trying to convert a Web App (that used ms sql server) to a Desktop app..
<12> did you consider sql2005 express or msde?
<11> I don't want to ship with 2k5 express because it's 53mb installer and 500MB space
<2> I think you need a access run time license
<11> my app won't be as appealing if users have to download m***ive files and it takes almost a gig of space
<12> i don't develop apps like that, can't really suggest anything
<11> how would you suggesst converting a web app to desktop
<11> i was thinking about xml searliaztion for storing objects
<12> which language dude
<2> http://office.microsoft.com/en-us/***istance/ha011208861033.aspx
<3> http://tinyurl.com/m4zlr
<11> but i already have the sql code..so the conversion would take no time at all
<11> language = C# .NEt 2.0
<12> not my realm, i'll shut up now
<13> Jet databases have no licensing. You can create and ship MDBs for free.
<13> You only need an Access runtime license if you're using the Access front end.
<11> can i execute stored procs
<11> via access mdbs
<13> Access doesn't really have sprocs.
<13> It has queries which can execute simple DML statements.
<14> personally I wouldnt downgrade to access
<11> what would ya use
<14> express...but thats me
<11> even if it's 500MB+ installed on the users pc
<13> Express doesn't take up that much space.
<14> pfft
<11> 525 MB of available hard disk space
<14> access runtime is fairly big too
<13> Probably a recommendation for the possible growth of tempdb and whatnot
<14> and then there's the .net runtime as well
<11> Godo point Halo
<11> yeah..I have to install .NEt 2.0 runtime...then the sql express
<13> Don't need the Access runtime to query MDBs.
<13> And a webserver
<13> Your app wasn't designed to be a single user desktop app.
<11> soi could load up a MDB via JEt and execute a SPROC on it
<14> you need jet at least
<14> which is a seperate d/l
<14> from mdac
<13> I do believe Jet comes with WinXP
<11> yes Win2k and XP
<14> I just dont think shipping an extra runtime on top of the .net one is a big deal
<11> would make my life a lot easier
<14> not if you have to port stored procs
<13> Yeah, Jet and SQL don't really speak the same language.
<13> Not unless you stick to a fairly strict subset of ANSI SQL.
<14> jet speaks a dialect of sql
<14> and you need lots of () too
<15> evening
<16> yuppie :)
<9> yuppie, waazup dawg
<0> hello, i have another question can someone take a look at http://pastebin.com/663508
<17> you need to do a left join
<17> with =
<17> and in the where clause
<17> where tableb.id is null
<0> left join on both joins?
<17> you could just do not exists() also
<8> zomgz zews
<17> ?
<0> do not exist ? how do i use that?
<17> select * from a where not exists(select * from b where b.id = a.itemid)
<0> ohh, lemme see is postgre has it
<17> or you could do a join
<0> well, that query in the bin, you said, use left join
<17> select a.* from a left outer join b on a.itemid = b.id where b.id is null
<0> should both be left join?
<0> ok, lemme rewrite and test
<8> no just one
<0> i'm guessing the second one
<17> the one you want to exclude
<17> the where clause checks if exists or not
<0> ok, lemme take a stab at it
<0> must be doing something wrong, i'm getting nothing back
<0> http://pastebin.com/663536
<18> the part %D20060415% ... what can I use to make it todays date -1?
<18> http://sql-servers.com/nopaste/?show=546
<18> its MSSQL
<15> jrbob : that sql implies a really ****ty db design
<18> not my design :/ ... i just joined this company is their stuff is allll over the place... i'm just trying to get this temporarily running till I can revamp everything
<15> jrbob : i'd spend some time adding extra fields to hold the date itself and the vsubstring values
<15> jrbob : how is that date value being generated?
<18> right now its manually being keyed in every time we run the query
<15> so how *will* it be done?
<18> its just the days date -1
<15> so it this a stored proc?
<15> embedded sql?
<15> called from php? c#?
<18> yes... i'm writing a vb program to run this query... and i can't just hardcode the date in there
<18> run from sql query analyzer
<15> yes you can - create the odd date string in vb
<15> doing it in sql is too much work
<18> so where %D20060415% is... i replace it with a vb variable that will contain the date -1 and it should work fine?
<15> that will contain the result of a datadd of -1 on today's date, formatted inthat way...
<18> thanks yuppie
<15> make it a parameter for a stored proc or something
<19> why not make it a udf?
<19> GenerateOurDumbDateFormat(@d as datetime) returns char(...)
<20> Yoda has good relations with the wookie
<21> ugg brain fart
<21> if i have a list of Items and then i have another table that maintains relationships that certain objects have with those items. e.g.
<21> a list of states . a list of vendors and a list that shows what states each vendor operates in
<21> if i want to pull a complete list of states and for a specific vendor then show which states those vendor operates in
<21> ooh got it
<15> tenfour : because formatting strings in sql is wrong
Return to
#sql
or
Go to some related
logs:
#firebird
with a spoon hurt more you twit
#computers
tranvestitie
#freebsd
who will be playing horrid henry
#gentoo
#politics
#beginner
#freebsd
|
|