| |
| |
| |
|
Page: 1 2
Comments:
<0> http://pastebin.com/718863
<0> but i think that selects just orders below 50, and doesn't check if the user has EVER bought anything above 50, then that user shouldn't be in the list
<1> never use alias.*
<1> like c.*
<1> never ever
<1> and distinct c.* make sno sense
<2> yikes
<0> i'm just using it to see everything returned. i'm changing it later on
<1> and you shouldnt need client as c
<1> it is most likely client c, orders o
<0> we're required to use msaccess here, and access rewrites it as that
<1> dont use *
<1> no it doesnt
<1> it does that because you are stupid
<1> and letting it
<1> type out the table and column names
<1> and distinct for every column is a bad idea
<1> learn to use group by or having
<0> how nice, don't you feel manly now, you got to call someone stupid. you probably are one yourself
<1> yes that must be it
<3> d
<4> hello ladies
<5> my gawd, it's been so loI've forgotton how to turn off logging in MSSQL2000, maybe the last time I did this was in SQL6.5 or 7
<5> I thought there was a setting in Enterprise manager, but I can't seem to find it
<5> I've got this read only db whose tables are truncated every night and reinserted and I sure as hell don't need the logs on all those inserts
<5> anyone remeber where the log settings are in enterprise manager?
<2> Yeah, they don't exist.
<6> lol
<6> that could be any number of "log"s, a lot of which em has settings for
<5> well jeez, from the context you might have "guessed" transaction logs, huh
<5> no, actually I was talking about the system logs, heh
<5> yeah how do I truncate the system logs from EM
<7> Hi all, using MSSQL here and building a stored procedure...can anyone tell me why this is giving @catid a null value? SELECT @catid = COALESCE(catid, 0) FROM categories WHERE cat = @catname AND parent = @catpar
<2> It's not finding any records.
<7> yes, but isn't the nature of coalesce to return the first non-null?
<7> isn't that the entire point of the function?
<2> Sure, but you're calling the function within the SELECT statement and that will only work if the catid field returns NULL.
<7> hmm..I'm not sure I follow you, do you have any suggestions as for a proper way to do this?
<2> The SELECT isn't setting the variable to NULL, it's not setting the variable to anything and as such it retains it's previous value.
<2> SELECT @catid = catid FROM categories WHERE cat = @catname AND parent = @catpar; IF @catid IS NULL SET @catid = 0;
<7> hmm i swear i've used coalesce in that method before but maybe not... ok i'll try that way hehe thanks
<8> using MSSQL 2000 - anyone know a way to export/capture row data where Ntext was used and the length of data exceed 500 chars? i've got it as a basic query now by unfortunately every time i send to CSV or similar, it trims the data value to 254 or somewhere in that.
<9> how are you sending to csv?
<8> from Access ADP front end
<2> Try DTS
<8> no luck
<9> wow that was fast
<8> yeah well... not that difficult ;)
<8> dts to text file CSV format, still strips the data to less than 255 chars
<2> Sounds like you have NULs or newlines in there or something
<8> this is the query... no nulls http://sql-servers.com/nopaste/?show=665
<8> its ordering it via len(compensation) desc so I can see that the end of each line in notepad and it trims at exactly the same location for each record > 255
<5> unignore Darken|
<5> heh
<8> any other ideas guys?
<8> **** and damn... can anyone think of any other method to extract data with a greater length than 255 to a text file? i've tried DTS, COPY/paste, QA as text and grid.
<9> I can do it in oracle :)
<8> heh..
<9> well you asked :)
<8> do you ever finding yourself asking....how in the hell could a system have even allowed this creator to **** this up so bad.
<10> Sure, write some code.
<11> Everytime I see my code i'm like "how could I have ****ed this up so badly"
<12> I have 3 MS access tables. Each contains a user name and 1 attribute. I want to combine the 3 tables into one table that looks like user name, a1,a2,a3. How can I do this efficiently?
<2> Look into CrossTab queries. I do believe that is something that Access has designer support for.
<13> does access have view?
<13> thats bad structure anyways
<12> cross tab queries wont work
<12> it says you need 3 columns to use them
<2> Try full outer joins then.
<12> thanks i'll try that
<14> (MSSQL) I'm writing a stored proc for website user login, is it worth sending result codes and/or text back from the db, or just hadnling it in asp, i.e. no results returend = not registered.
<4> whoopla: i would send result codes back
<4> because you can change it later if you want
<4> all that logic would be on the mssql side
<4> but then again you might want to keep on asp side
<4> it depends on how exactly you are doing it
<14> like just 'RETURN(0)'
<4> possibly
<4> either way works
<14> coolio
<4> just gotta find whats going to get you better design
Return to
#sql
or
Go to some related
logs:
#hardware
hackedxxxpasses
#netbsd
#politics
#worldcup
Im still in love, but not with you
how to turn off fastwrite
#nhl
#firebird
#cisco
|
|