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 TouchToneTommy 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: roena26
  • Content: Threads
  • Order by date
  1. roena26

    How to format numeric field into varchar while maintaining some decimal places

    We're using SQL Server 2008 R2. I inherited an automated process that sends data to a third-party outside vendor via an interface and the data is generated through a SQL query. I need to update the query and provide an unique identifier by concatenating three fields: id, package_size, and...
  2. roena26

    Show a line of data for all days in a month even if there is no raw data

    I have a report that I created in Crystal Reports 2008 which connects to a SQL database. I am reporting on dollar amounts over a one-month time frame and a summary of the total is displayed by date. I would like to display all 30 days in June, even if there is no raw data for the date. For...
  3. roena26

    Finding original date over a series of rows

    I'm working in Crystal Reports 2008 and SQL Server 2008 R2. I need to find the original date an order was placed when the parent (original) record isn't carried throughout the updated records. Order_ID Order_Written Prev_Ord_ID 10847685 3/15/2013 NULL 10847686 4/12/2013...

Part and Inventory Search

Back
Top