Search results for query: *

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...

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...