Please help

• gokturk413

  Newbie

  Points: 7

  More actions

  February 5, 2014 at 1:10 am

  #283275

  enter------------------------------intvalue--------out----------------intvalue

  2014-02-05 08:56:51.230 -- 1----2014-02-05 08:57:05.990--- 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

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  February 5, 2014 at 8:14 am

  #1686217

  gokturk413 (2/5/2014)

  ---

  enter------------------------------intvalue--------out----------------intvalue

  2014-02-05 08:56:51.230 -- 1----2014-02-05 08:57:05.990--- 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

  Hi and welcome to the forums. I would love to help but you seem to have forgotten to post any information that would let me help. Please take a few minutes and read the first article in my signature for best practices when posting questions.

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/