Search results for query: *

Thank you, gmmastros, that worked for the straightforward items. I appreciate your help.

That's a very good question that I'll have to bring back to the team as I don't think the decision to concatenate fields was thoroughly investigated. Thanks for the heads up.

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...

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...

I guess additional data examples would help explain why I can't just take a minimum as a client can have multiple orders: Row C_ID Order_ID Ord_Write Prev_Ord_ID 001 0001 10847685 3/15/2013 NULL 002 0001 10847686 4/12/2013 10847685 003 0001 10847689 8/16/2013 10847686 004 0001 11981012...

That was my first thought but I don't see how I could get the minimum date for the group of records when there's nothing tying the first record that has the date that I want with the order ID of the last record except for the two records in between. Row Order_ID Ord_Write Prev_Ord_ID 001...

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...