Viewing 4 posts - 1 through 4 (of 4 total)
Christopher Stobbs (11/20/2008)
You can't use ROW_NUMBER() in SQL 2000 or SQL 7 you need to use another approach.Try my solution or try reading lynn's post about running totals!
Thanks
Chris
Sorry but i´m...
November 20, 2008 at 10:37 am
Christopher Stobbs (11/20/2008)
DECLARE @Tmp TABLE
(id INT IDENTITY(1,1)
,fechahora DATETIME
,m3salida DECIMAL(15,8))
INSERT INTO @Tmp
(fechahora,m3salida)
SELECT '2008-11-17',569512.00 UNION all
SELECT '2008-11-17',966786.00 UNION all
SELECT '2008-11-17',465119.00
SELECT
[1].ID
,[1].fechahora
,[1].m3salida
,[2].m3salida
,[1].m3salida- isnull([2].m3salida,0)
FROM...
November 20, 2008 at 10:23 am
/*------------------------
select
a.fechahora
,a.m3salida
,a.m3salida- coalesce(b.m3salida,0)
...
November 20, 2008 at 10:18 am
Hi all,
I´m newbie in T-SQL and i´m learing about create cursor and it´s very dificult to me create one cursor for one function I need.
Here is what I need.
I have...
November 20, 2008 at 9:22 am
Viewing 4 posts - 1 through 4 (of 4 total)