So, it looks like you helped me out once again but I am unable to create this as a view. I get an error "Incorrect Syntax near the keyword "DECLARE'....

OK, this is what I have to work with:

This first table below has the shifts and the data I need but the problem is, there can be multiple records for...

I don't know if you will see this but I was wondering if you may be able to help me out again:-D .

So I am now getting the data results...

Oh yes, this is what I need!! I posted my last reply before I saw your latest IF post Seth. Thank you so much!! I really appreciate your help; very...

Yes, my apologies. Here is the table syntax:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[tblTransactionDetail](

[ProductionDate] [smalldatetime] NULL,

[Shift] [tinyint] NOT NULL,

[LineNumber] [tinyint] NOT NULL,

[Cart] [smallint] NOT NULL,

[ProgramNumber] [smallint] NOT NULL,

[CavityPosition]...

OK, I changed it...but I'm still having an issue and am a bit confused. Excuse my "newbness" but how can I now create such a query that would get the...

Hi, Thank you! This looks like it is what I am looking for. However, I forgot to mention that I am using SQL Server 2005 and I don't believe the...

Sorry I haven't responded in a while. I had a death in the family. But I wanted to check back in because I do still really need a solution and...

Wow, thank you so much. I am going to try what you provided as soon as I can. Yeah this database probably is a mess. But like you said, this...

Thank you for your quick replies. Here is some more information.

I tried to use forum etiquette, sorry; I think I might of failed. I don't think I did too well....