| |
| |
| |
|
Page: 1 2 3
Comments:
<0> but it depends on the database engine and the version
<1> tapped : so, a select statement you haven't shown us doesn't return a value...
<2> im display the value in another place
<0> displaying how?
<2> in an email
<0> are you sure that code is correct?
<2> it's displaying everything but @var1
<0> go somewhere and paste your code
<1> if you're trying to display @var1, why bother us with the concaenation above?
<2> the displaying is not the problem
<2> forget about that
<0> go and show us some code
<2> am i using the right function is all im asking
<2> and using it correctly
<1> well, if it works, it's right
<2> ok
<3> SQL 2000 SP4: Can a SCALAR function include TSQL (eg DECLARE and SET statements)?
<0> isn't that:
<0> 1. easy to set
<0> 2. something which should be documented one way or another?
<0> *set = test
<1> indeed
<1> Sabba : go work it out for yourself...
<3> GuntherX: Ok man, relax. :)
<3> It was a sanity-check question.
<1> hmm... sanity check & asking on irc?
<4> arghhh fiscal date tables don't have 06 crap in them
<4> i do this every year :P
<3> GuntherX: Good point.
<5> anyone up
<5> ?
<1> no
<5> nice.
<1> don't ask to ask - it's in the rules
<5> the notices came in delay, sorry
<5> is there a way, i dont care how at the moment, to duplicate a row's data into another row as in something like:
<4> i htink thats a new feature
<5> i have 2 rows with diffrent data, and a diffrent id value
<5> and i wanna duplicate the data from into another
<5> yet not touching the id
<1> ducch : yes.
<5> ok, can you give me a direction on how to do that?
<5> mssql/mysql
<1> update
<1> mysql?
<5> k, thanks
<5> i dont mind which of them
<5> theyre both pretty much the same
<1> so, you didn't read the rules after all
<5> i did.
<5> its just mysql has a better manual so i rather search it there
<5> YuppieGTB mysql > mssql =\
<6> bye
<4> haha
<7> hahaha
<8> feh
<8> im rapidly growing to dislike working for people....
<9> what happend
<9> where have you been all this time :)
<8> working...
<8> just annoyed at a new boss...
<8> tried pulling the 'martyr' bull**** on me today, but i called him on it.
<8> the old "I had to work all weekend" routine...
<8> my response was "Well, if you had called me I would've offered to help (in fact I offered LAST TUESDAY)".
<8> bwhahahaha
<8> goddamn developer ran one of the qa servers out of space...
<8> "Why is unlimited autogrow bad?"
<8> 45GB tempdb...
<8> idjiots
<8> bbk, i need a gl*** of ice to go with my bottle of bourbon...
<9> meh
<8> mmmm
<8> ice
<8> and bourbon
<8> just the thing every prod. dba needs to wind the day down with.
<4> i fancy a bongload and a couple beers
<8> bonghits are always good
<8> screw the beer, good liquor is where it's at...
<9> you;'re a ****en drunk
<9> http://www.planetdan.net/pics/misc/georgie.htm
<9> i am jelous
<4> neat
<9> hmm
<9> when i p*** a connectionstring to an OleDbConnection is it possible to have somethin like %ExecutiblePath%\mydb.mdb
<10> http://sql-servers.com/nopaste/?show=155
<10> any ideas how this can be done?
<9> insert into table2 select cast(hh as varchar) + ':' + cast(mm as varchar),average from table 1
<9> you also need a function to pad mm with zeroes from the left i guess
<11> does .net have a namespace or whatever for working with zip files?
<11> Quant: doesn't .net have something similiar to like App.Path (which is VB6's 'application directory' property)
<9> the connectionstring is in my config file
<11> ConfigObject.ConnectionString.Replace('%ExecutablePath%', App.Path);
<11> :)
<11> replacing, of course, App.Path with .NET's equiv of VB6's App.Path
<11> otherwise, no ... there's no built-in shortcuts that I'm aware of
<9> that's what i dont want to do
<9> i am asking whether OleDb has **** like that
<11> not to my knowledge, no
<11> besides, how would OleDb know what your apps path is? :)
<9> hmm
<9> i am selecting BuildAction: Content for a file and when I build it's not being moved itno bin/debug wtf
<11> that'd be a .net enhancement to the OleDb libs
<11> oh and, apparently ... I'm gonna be a .net developer now ... haha
<10> k Quant going to try that
<9> zoul: new job?
<12> Using 10g i have a probelm getting a query out of my head and onto screen
<12> i want to find all the question_id,user_id,section_id which do not appear in a table callled user_answered where the question_id and section id appear together in a table called section_questions but only if the user has other entrys for the section_id in the user_answered
<12> basically looking for missing entrys
<12> any ideas?
<0> do it in pieces, first grab all the rows, then add "do not appear in user_answered", then get that working, then add "appear together in ...", etc.
<13> if you want to insert into a view in MS sql, is there a smart why to fix so FK is IDENTETY (PK) on insert ?
<13> or do I have to update one table i a time in my SP ?
<0> _chip: you can only update one table at a time
<14> LVK: not if its a partitioined table
<14> partitioned view
<14> _chip: so your view consists of multiple tables containing similar data that can be differentiated via a constraint?
<14> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_06_17zr.asp?frame=true
<13> my view is two joined tables...
<13> with a relation of course
<13> I thought there was a smart why to insert rows to the view, where the FK table got PK automatic...
<13> otherwise I have to update the PK table first in my SP and then the FK table... then the view only serves for selecting..
<15> You're using partitioned views incorectly. So no, they don't do that.
<15> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_06_17zr.asp
<14> _chip: there is, that's a partitioned view
<14> Drk`Angel: reposting my link, thanks
<14> lol
<14> _chip: you can't just make a view and expect it to be partitioned
<15> heh, sorry. :)
<14> seems to me that partitioned views need to have schema binding to the underlying tables
<13> thx, Ill check that out, and do it the right way..
<14> and each member table must have a constraint
<14> i remember my first partitioned table was a pita
<14> in fact making one today would prolly hurt too
<13> so my senario should be pretty simple...
<13> If I get it right, I only need to fix the constraint
<13> the view is only based on two linked tables..
<15> Are you joining or doing a union all?
<16> Is it possible to set the decimal separator used by mssql?
<15> If you're joining, then you're not using partitioned views, and I'm not sure why you think you are.
<0> JohnD^: no, it uses "." always
<0> what would you like to use?
<16> LVK: ","
<0> what does this sql mean then: SELECT 10,20,30
<0> is it: SELECT (10,20) , 30 ?
<13> http://sql-servers.com/nopaste/?show=158
<0> or: SELECT 10, (20,30) ?
<16> good point. I mean in the result set, but i guess it is the same thing
<0> there's a reason it's ., it's syntax, it has nothing to do with regional settings
<13> Im using join
<0> the result set returns floating point values
<0> it's the client software that will have to format it for display
Return to
#sql
or
Go to some related
logs:
#beginner
#computers
Who recorded the 1996 alburn, Older
#freebsd
#firebird
#flash
aapm.pk
remove whole motherboard northbridge cooler
mirc activate timer
#beginner
|
|