Please help

  • 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

  • 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/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply