| |
| |
| |
|
Page: 1 2 3
Comments:
<0> jLo: thats the better of the options
<1> heh
<0> as it also allows for growth in the application ... where more settings are most likely going to be available as the app grows into a larger item
<2> ok
<2> how does that perform under heavy load, im going to potentially have a few thousands objects
<2> my app will constantly be updating these values
<0> jLo: it should not update the settings when the setting changes, it should update them during unload ...
<0> and it should not query the database everytime it wants to know what a setting is, settings should be brought into a Configuration object ... and that object should be queried, not the database
<1> hahah
<1> this is weird
<1> sql generated 1, 4, 5, 6, 7 as
<1> identity numbers
<1> without me entering or deleting deleting
<3> maybe some rollbacks in there
<3> jLo : performance will be fine as long as proper indexes are used, and maintenance is carried out regularly
<3> jLo : plus, as you're only using it as persistent storage, rather than actively, performance shouldn't be that big a deal anyway
<3> hahaha
<2> whats the difference between persistent from active?
<3> jLo : about 7
<2> great
<1> hes just going to come back
<1> :-/
<4> then the 'k' will become a 'kb'
<1> hehe
<4> w00t
<5> heh
<1> hhe
<5> tagteam!
<4> hahaha
<4> mine was more of a precision strike - you just nuked the whole subnet
<5> screw em all
<6> Is it possible to write a query that will return me 4 id's of the 4 latest dates most closest to today date?
<7> do you mean 4 or 16 rows?
<6> The query will search the DATE field and look for the most 4 recent dates and return each 1 ID..
<6> 4 rows
<7> for each date, is there more than one row in the table(s) relevant to this query?
<7> you say "most recent", isn't this just a MAX query
<7> ?
<6> you know what.. i'll just get the 4 last rows...
<6> they have the most recent dates .. if i think about it now
<1> who u talking to?
<6> now i need to get the ID'S of the last 4 rows in the database
<7> SELECT ID FROM tablename ORDER BY ID DESC
<7> then grab the first 4 rows, if your database engine can do something like TOP (x), then use that as well
<6> its sql 2000 ..it should have top i guess
<7> yes, it does
<7> SELECT TOP 4 ...q
<7> minus the q
<6> can't i do , SELECT ID TOP 4 From TableName ?
<7> what would be the difference between that and: SELECT TOP 4 ID FROM tablename ?
<6> The TOP 4 should be before the ID field in the query?
<7> yes
<6> okey LVK, I am going to use that, thanks for the ***istence
<6> What i am trying to do is, get the 4 top ID'S which i know how to now. after that i check if each ID exist in another table for the USER ID I provide the query..
<6> the query gets the 4 last ID's from table1 and checks in table 2 if all 4 ID's exist for a specific User ID i provide ..if they exist i return true if not i return which id's did not exist.. is it possible to make this in 1 query?
<6> table 2 contains ID and UserID fields
<6> anyone ?
<8> can someone tell me i have a stored procedure that i want to optionally allow one of the paremeters to be null for an address line 2
<8> when i run the sp
<8> it woln't run because it says it expected a value for that column
<8> how can i adjust the sp to allow nothing to be sent for that input
<8> ?
<9> what's an address line 2?
<8> sorry
<8> thats just the column name
<9> and DBMS?
<8> its just a varchar column
<8> sorry SQL 2005
<10> CREATE PROCEDURE Blah @Variable1 VARCHAR(255) = NULL, @Variable2 ...
<9> you are basically calling sproc multiple times and in some cases you want one of ts input to be null?
<9> darn it Halo_Four
<8> yea
<9> well there is your answer
<8> declare them as null
<8> ?
<9> the default value is set to "null"
<8> ok...so if a value comes in it will not set it to null
<8> otherwise it will
<9> yeah
<8> ok thanks
<9> thank Halo_Four instead
<8> thanks halo_four
<9> god dammit. i hate drinking beer and coffee at the same time
<9> my stomach is all messed up
<6> u drink beer at work? :)
<9> why not?
<9> :)
<6> in the office where u work?
<9> sure~
<9> moreover, it's Saturday and i am the only on in the whole building
<9> s/on/one
<6> haha.. so no problem, but would u drink beer in monday?
<9> yeah. well CEO and CFO sometimes "forces" employees to drink
<9> during lunch time that is
<6> that looks like a fun company :)
<9> nah... that's the best they can do for us at least
<6> why u at saturday at work
<6> ?
<9> drinking
<9> and listening to Leo Larpote
<9> the Tech Guy~
<6> but u could drink at a bar or at home, isn't it better
<9> i am gonna meet up with some of my friends and will be drinking near my work place so...
<6> u are from the uk?
<9> ah, nah. NYC
<9> lol
<6> well, u sould like england i guess. they like to drink beer's
<9> but i prefer drinking liquor though... that's what i will be doing later on tnight
<9> s/tnight/tonight
<9> getting my stomach ready for some alcohol with beer and then will be exercising my stomach with hard liquor later on
<6> yeah man, just don't work too hard now :)
<9> hmm. i am only on my 3rd 12oz can... :)
<6> in anycase, is it possible to do the following thing
<6> i am doing "SELECT TOP 4 ID FROM table1" to get the 4 top id's of table1....
<6> after getting the result i wana check if the 4 order id's exist in table2 for a speicfic user (@USERID)
<6> if it exist i return true . if not- i return false
<9> to get the top 4 ids, use order by id desc
<6> top 4 is the last 4, right?
<9> yeah if you order the table1 in descending order
Return to
#sql
or
Go to some related
logs:
emily18f
#politics
3ds pbrt
#vmware
C preprocessor /lib/cpp fails sanity check
mobile 4000+
#heroin
THX-Tokyo
#beginner
#stocks
|
|