Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rp1504
  • Content: Threads
  • Order by date
  1. rp1504

    How to use order by clause for a column not in select list

    Hi, I have to order the query by a column that is not in select clause, but exists in the table structure. Pls. let me know any solutions.
  2. rp1504

    truncate the time stamp

    How to truncate the time stamp from DATE in sql server I did try to use CONVERT function but did not work?
  3. rp1504

    Filter records based on latest timestamp for a partcular DATE

    I have DATETIME stamp in columnB. I want all the latest rows for a particular date. ColumnA ColumnB ------------------ NJ 2003-06-30 10:22:02.700 CO 2003-08-04 09:49:13.247 NJ 2003-08-04 09:51:47.667 CO 2003-08-26 11:01:58.743 FL 2004-10-09 11:48:13.610 FL 2004-10-09 11:50:13.610 For e.g...
  4. rp1504

    Getting nextcol value using 1 query

    In Sql Server, if I want to update a column based on the next row data from another column in 1 query how is this possible ? e.g. : I have a data like this : I want to populate ColumnC with ColumnB next row data. Can I write a dynamic query that would be used to populate ColumnC otherwise I...

Part and Inventory Search

Back
Top