| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> How do I enter a valid datetime in the T-SQL Debugger window?
<0> it always says 'invalid character cast' something...
<0> i tried a convert, a cast..
<0> invalid character value
<1> "always"? paste an example to the paste site
<0> okay.
<0> http://sql-servers.com/nopaste/?show=150
<0> i get that when i click on 'Execute' (i right-clicked on my sproc, and selected Debug.. in Enterprise Manager (SQL Server 2000 SP3)
<0> i got 2 datetime columns
<0> i tried putting a convert(datetime, '2000-01-01 12:00:00', 120) and a cast also..
<0> always same error.
<0> i tried 02/02/1998.. same error.
<1> twat - the sql too, not just the error
<0> there's no sql.
<1> yes there is, twat
<0> how do i see it?
<0> i did that via the gui.
<1> convert(datetime, '2000-01-01 12:00:00', 120) is sql, twat
<1> anyway, you need to re-read your documentation regarding convert()
<0> that query works.
<1> there is no 3rd parameter when casting as type datetime
<0> yes there is. the query works.
<0> this selects a proper datetme.
<1> then paste the one that throws the error, dumb****
<0> you seem clueless. you're trying to misinform me. :\
<0> anyone knows what i'm talking about? t-sql debugger window.
<2> what sql throws the error?
<0> YuppieScm: it's this convert line. if i click on 'Set as null' for those 2 datetime fields in the T-SQL Debugger window, the debugger loads fine.
<0> but in Query Analyzer, this query works just fine.
<0> it returns a valid datetime.
<2> Shakkan2 : you`re not making sense - stop using `this` `those` and `it` when descibing the problem
<0> (the sproc i'm trying to debug has 2 datetime parameters)
<2> paste it all to the paste site
<0> YuppieScm: i'm using the T-SQL Debugger GUI
<0> to debug a sproc
<2> and?
<0> there's no other SQL to paste.
<0> i just need to enter values for the parameters.
<2> what do you mean `no other sql to paste`?
<0> well, the GUI just wants values to debug a sproc.
<0> there's no SQL.
<2> you get an error when trying to execute some sql, therefore there is some sql that throws the error. without seeing this sql, there is no chance of being able to help you dignose and fix the problem
<0> then i don't know how to display the SQL being sent by the T-SQL Debugger.
<0> since i'm not sending raw queries.
<2> `sent by`? what do you mean by `sent by`?
<0> the GUI
<0> the T-SQL Debugger window.
<2> there seems to be a fundamental lack of understanding here...
<2> lets try this another way
<2> WHAT THE **** DID YOU TYPE INTO THE T-SQL DEBUGGER WINDOW, YOU COCK-****ING ****-BRAINED NUMPTY?
<2> does that clear things up a little?
<3> What we have here is a failure to communicate.
<0> i'd feel awfully redundant to type it -AGAIN FOR THE 9218349TH TIME-.
<4> lol
<2> i hate autojoin
<2> i also hate people who can`t explain themselves
<2> and i hate that my gl*** is empty again... brb
<3> Sadly enough I knew what he was talking about
<1> i do too, i just got bored waiting for him to explain himself properly... entering an entire convert() statement into a gui field that expects a datetime string is gonna fail quite badly
<1> hm... there appears to be a tv show on tonight called 'tittybangbang'...
<3> nice
<5> heh
<6> anyone have a tft serial they dont use?
<7> go to a junk computer store
<7> it's not worth mailing
<8> freecycle one
<6> darken
<6> mailing what
<4> how do i get the left outer join to return just one row of data?
<9> ?
<9> One row total?
<4> yes, but just the outer join. the whole select returns several rows.
<4> oh.. got it.. doh
<4> is there a way to make outer join return one row of data max?
<4> my outer join returns two or more at times and makes unncessary duplicates
<10> hi
<10> is there a way to p*** a column name as a parameter?
<10> SELECT SUM(column1) as Sum1
<10> SELECT SUM(column9) as Sum9
<10> ???
<10> SELECT SUM(column1) as mySum
<10> SELECT SUM(column2) as mySum
<10> and each time send a different column name as a parameter?
<10> SELECT SUM(column1) as mySum FROM myTable
<10> SELECT SUM(column2) as mySum FROM myTable
<11> I have a field that is set to varchar, since some records have leading zeroes and others don't i want to standardize it to remove leading zeroes thus making a search easier. How can I do this?
<12> lol
<12> thats cause numbers are supposed to be numbers
<12> and alpha characters are supposed to be alpha
<12> if you try to treat numbers as alpha characters
<12> then yuou have to understand ur going to follow alpha rules
<12> if they are numbers store them as numbers
<8> its amazing what a little % does for you
<13> hi there, i'm using MMSQL 2005.
<13> i've a database, and i'd like to dinamically create a create.sql script
<13> is it possible ?
<6> lawl
<13> sup ?
<14> yar
<6> rmah
<6> tell me about mortgage backed bonds
<14> why?
<12> cause hes bored
<12> and its thundering
<14> ok
<12> and he wants ddaddy to tell him a story :(
<14> mortgage backed bonds are a cl*** of ***et backed securities
<14> basically, you take a bundle of mortgages that you've purchased on the secondary market and wrap them in a bond issue
<14> this way, the issuer gets a wad of cash up front (the purchase price of the bond)
<14> and the bond purchaser gets a guaranteed income streem backed by the underlying ***et (the mortgages)
<14> typically the ***ets are also insured
<14> that's about it. rather simple really.
<14> now... why do you want to know Quant?
<12> what sort of initial investment? and what sort return level can one expect to see?
<14> initial investment for what party?
<12> the person purchasing the bond im ***uming
<14> I'd image you could buy the bonds in lots of $10k or $100k or so
<14> as for return, not all that great... on the order of just a hair below the current long term mortgage rates
<12> hmmm
<12> so 4-5%?
<12> max?
<14> yeah... it's a pretty damn safe investment
<12> hmm
<12> but one would wonder what the differnece between that and something for ing
<6> i understand
<6> but what's the point of it
<12> s/for/like/
<12> lol
<12> yeah
<12> I'm with quant on this one
<6> the pre-payment risk and ****
<14> the point is to provide maximum liquidity for the mortgage market
<12> with stuff like ING and what not .
<14> ok, when you take out a loan to buy a house...
<14> the bank that issues you the loan..
<6> if i wanna make money on MBS what can i do
<14> they turn around and SELL the loan almost immediately
<14> understand?
<12> yeah.
<12> and these people buy it then ?
<14> now, the people who BUY the loans don't want to deal with them one at a time
<14> you want to buy $100mil in mortgages
<14> sooo
<14> various banks buy up mortgages in bulk
<14> wrap them in a bond
<14> and issue it, thereby recouping the purchase cost of the mortgages
<14> and then the purchasers of the bond are investing in the mortgages without the risk of individual mortgages
<12> so what type of people generally purchase these bonds? just people that wnat low risk investments?
<14> if you bought a $100k mortgage... what happens if the homebuyer can't make his payments?
<12> you'd be screwed and be left with trying to fix it up and resell it
<12> everything makes sense
Return to
#sql
or
Go to some related
logs:
#nhl
#politics
#freebsd
#politics
juicymandy
#politics
#stocks
radio jussi fruit
#networking
#slackware
|
|