Recent content by lagazetta

don't forget to ask them what they are doing and why they are doing it and what their primary objective is. then you may get a better offer. i use sql for data manipulation purposes and feed my econometric software, not for executing queries in 5 seconds rather than 4 seconds.

thanks bborissov, I am trying your code and hopefully it works. and,thanks SQLdenis for your comments. whether or not this design is non-sense is out of the question here. econometric theory suggests that this should be done and time/resource efficiency is not something that is targeted here.

i would like to run a regression at the end if I can complete the table in the way that I described. i want to test whether an hour of the day has a significant effect on my dependent variable. the most convenient to do this is to define a dummy variable that takes the value 1 if the...

hi there, my table looks like: prime-------date_value----------------h1-----h2---h3........ h24 1-----------7/1/2001 1:00:00 AM------null---null--null......null 2-----------7/1/2001 2:00:00 AM------null---null---null.....null 3 4 5 6 7 8 . . . . . 30720 I would like to insert the number "1"...

hi there, i have a script that looks like the following: select m.date_value, m.he, m.poolp, m.bpat, r.kinbasket from merged4 as m join reservoir as r on m.date_value = r.date_value the query gives a result table on the lower pane. how do I save that results table as a table within the...

i tried: insert into merged2 (ustie,abtie) select ustie, abtie from actual_flow i got: Msg 515, Level 16, State 2, Line 2 Cannot insert the value NULL into column 'KEY', table 'CABREE.dbo.merged2'; column does not allow nulls. INSERT fails. The statement has been terminated. it tries to put...

hi there, when i use the below script to insert 2 columns of a table(named actual flow) into an already existing table (named merged2): insert into merged2 select ustie, abtie from actual_flow i get the following error message: Msg 213, Level 16, State 1, Line 2 Insert Error: Column name or...

hi there, I am using MS SQL 2005. i have an name.xls file (has 3 columns in one worksheet) that needs to be uploaded as a table with 3 fields (corresponding to the columns in my excel sheet) into my database. i ran the following: select * from openrowset('microsoft.jet.oledb.4.0', 'Excel...