Please help repated row - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

Transact-SQL (2012)

Please help repated row

Author

Topic

gokturk413
Starting Member

1 Post

Posted - 2014-02-05 : 03:21:57

enter-------------------intvalue-----out----------------intvalue
2014-02-05 08:56:51.237 1 2014-02-05 08:57:05.997 2
2014-02-05 08:56:49.320 1 2014-02-05 08:57:03.490 2
2014-02-05 08:56:45.097 1 2014-02-05 08:56:57.840 2
2014-02-05 08:56:42.640 1 2014-02-05 08:56:55.727 2
2014-02-05 08:56:42.640 1 2014-02-05 11:37:46.493 2
2014-02-05 09:19:18.167 1 2014-02-05 08:56:55.727 2
2014-02-05 09:19:18.167 1 2014-02-05 11:37:46.493 2
2014-02-05 08:56:47.163 1 2014-02-05 08:57:00.737 2

please help when intvalue value change between 1-2 new row inserted
and out time or enter time repeated with above time
i need when changed intvalue enter or out time must be null
here is my query

SELECT yuyi.[timestamp] enter,yuyi.[intvalue],yuyi.[carrierid],yuyi.[lastname],azx.[timestamp] out,azx.[intvalue],azx.[carrierid],azx.[lastname]
FROM [aeosdb].[dbo].[view_eventlog_online] as yuyi join dbo.view_eventlog_online as azx on
yuyi.carrierid=azx.carrierid where azx.eventtype=5 and yuyi.eventtype=5 and yuyi.intvalue=1 and azx.intvalue=2
and(azx.timestamp>=CAST( GETDATE()as date)) and (yuyi.timestamp>=CAST( GETDATE()as date)) order by azx.carrierid,yuyi.carrierid

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2014-02-22 : 11:58:18

Can you post the expected output?

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources