Viewing 15 posts - 31 through 45 (of 101 total)
im sorry if i wasnt clear.
Here are actuals records.
26,4069Caudal20-05-2010 1:02:12
26,5306Caudal20-05-2010 1:07:13
26,8398Caudal20-05-2010 1:12:16
26,8398Caudal20-05-2010 1:17:18
26,9017Caudal20-05-2010 1:22:21
27,1490Caudal20-05-2010 1:27:23
26,9635Caudal20-05-2010 1:32:30
27,1490Caudal20-05-2010 1:37:32
27,0872Caudal20-05-2010 1:42:31
26,9635Caudal20-05-2010 1:47:33
26,9017Caudal20-05-2010 1:52:35
27,0872Caudal20-05-2010 1:57:38
27,0254Caudal20-05-2010 2:02:41
26,8398Caudal20-05-2010 2:07:45
27,0254Caudal20-05-2010 2:12:46
26,7780Caudal20-05-2010 2:17:52
26,8398Caudal20-05-2010 2:22:53
26,5925Caudal20-05-2010 2:32:56
27,1490Caudal20-05-2010 2:32:57
26,8398Caudal20-05-2010 2:37:58
26,3451Caudal20-05-2010 2:43:05
26,8398Caudal20-05-2010...
July 19, 2010 at 12:14 pm
PaulB-TheOneAndOnly (4/14/2010)
Most probably you want to shows us the full statement as well as the full error, don't you? 🙂
statement
INSERT INTO srv-dev.labmger.dbo.analysis
SELECT *
FROM hades.labmger.dbo.analysis
error
Mens. 102, Level 15, State 1, Line...
April 14, 2010 at 4:02 pm
Steve Jones - Editor (4/13/2010)
You should post the code you're running, some sample data, and where the dups are occuring.I might change the "in" to an = as well
select *...
April 13, 2010 at 10:43 am
ps. (4/13/2010)
igngua (4/13/2010)
scenario;
col1 col2
ID1 datetime1
ID1 datetime2
ID2 datetime3
ID2...
April 13, 2010 at 10:36 am
Steve Jones - Editor (4/13/2010)
Or just a
select top 1max(date), col1, col2, col3
from mytable
group by col1, col2, col3
that´s the first thing a tried but it didn´t work...
April 13, 2010 at 10:18 am
ps. (4/13/2010)
igngua (4/13/2010)
scenario;
col1 col2
ID1 datetime1
ID1 datetime2
ID2 datetime3
ID2...
April 13, 2010 at 10:13 am
thanks!!
it worked!
select t1.cotnum, t1.codaux,
t2.cotnum, t2.codaux
from hermes.lab0708.softland.nwcotiza t1
left join softlandsoporte2.softland.nwcotiza t2 on t1.cotnum = t2.cotnum
where t2.cotnum is null
Now i´ve to update T2 with all the columns from 1 not...
March 23, 2010 at 10:19 am
CirquedeSQLeil (3/22/2010)
Looks fine to me. Is it not producing the desired results?
HI!
Im not getting the results i want.
t2 has less data than t1 and i´m getting no data.
select...
March 23, 2010 at 6:40 am
Ok!
I need to know where can i look for the specific date when data changes gets comitted on a table.
thank guys!
March 16, 2010 at 12:25 pm
Dave Ballantyne (12/30/2009)
Im guessing here...
Update yourtable set c3 = c3+' dont use'Is that what you mean ?
Yes, but i need to do that for every record in the column.
December 30, 2009 at 12:39 pm
Viewing 15 posts - 31 through 45 (of 101 total)