User Profile

Collapse

Profile Sidebar

Collapse
ctlscteb
ctlscteb
Last Activity: May 1 '08, 12:44 PM
Joined: Feb 28 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ctlscteb
    replied to t-sql query
    in SQL Server
    Hi Delerna,

    Thanks for all the help in the previous post of mine and I need help again. Current output is showing results as given below from previous query and posts which we communicated but I need some modifications (i want to count 0 as "daysinbetw een" if "dte" repeat itself for "ab" and "id" combination) to put 0 for duplicate dates in "daysinbetw een" -

    current results...
    See more | Go to post

      Leave a comment:

    • ctlscteb
      replied to t-sql query
      in SQL Server
      Hi,

      Thanks for the help! After small tweaks this works as I wanted....
      See more | Go to post

        Leave a comment:

      • ctlscteb
        replied to t-sql query
        in SQL Server
        Hi CK,

        I want results like this

        If this is the data in table (while days in between is output) -

        id ab dte days in between
        14 ab 1/11/2007 10
        14 ab 1/25/2007 14
        14 ab 2/1/2007 6
        15 cd 3/13/2007 12
        15 cd 3/24/2007 11
        15 cd 3/28/2007 4

        I want output like this -

        id ab dte days in between

        1/01/2007
        14 ab...
        See more | Go to post

          Leave a comment:

        • ctlscteb
          replied to t-sql query
          in SQL Server
          Hi CK,

          everything looks working except one thing that how should I catch first day of month in this if NextDate is not first of the month when ab is changing to cd and same at the start of data....
          See more | Go to post

            Leave a comment:

          • ctlscteb
            replied to t-sql query
            in SQL Server
            Thanks for posting, your suggestions are on right track but I think that I confused you

            This is what I am trying to do, if id, ab changes in view then the whole process run again and counts the days in between from start of month if start date is not 1st of month and if it is 1st then skip that part (in this case days in between would be 0) and count the days in between with next date under same id, ab. The query given by you is showing...
            See more | Go to post

              Leave a comment:

            • ctlscteb
              replied to t-sql query
              in SQL Server
              This thing I know but I want to know that how I can use that with 2 views where multiple rows exist and how to add some functionality to catch the first day of month if first record day is not that....
              See more | Go to post

                Leave a comment:

              • ctlscteb
                started a topic t-sql query
                in SQL Server

                t-sql query

                Hi Everyone,

                This is my first time here and I want to tackle the given below problem. any insight would be great

                I have 2 views and want to calculate days in between 2 dates(under same column) for approx. 500 rows.

                Data is like this

                view 1

                14 ab 01/03/2007
                14 ab 11/03/2007
                14 ab 23/04/2007
                14 ab 30/04/2008


                view 2

                ...
                See more | Go to post
                No activity results to display
                Show More
                Working...