OK I thought I would show my hacked answer. Thanks

declare @ClassID int

set @ClassID = 2

declare @runTime datetime

set @runTime = (select GetDate())

declare @rowCount int

declare @rowsToAdd int

declare @constRowCount int

set @constRowCount =...

Thanks all for the insight. I think that I am going to go ahead with the virtual deletes and just make sure all child tables records are marked as...

Ya, Crystal Reports is the client and I just don't know how to do it there. I think I will just use a cursor and be done with this.

If there are less than 17 I need to print blank rows like

15 John

16

17

Thank you Steve.

If I may ask another question please?

The table I am going to mark records deleted in has many child tables with one or more records in them. ...

All,

I wasn't trying to start a fight. I was just wondering if there was a good hearted individual that would be willing to help me learn to think through...

Because I want to get to know the person and go deep with the topic. Here people may or may not answer and only will work against a small...

Los Angeles area of California.

Outrageous? I created a new DB from my DDL and used the inserts and still get the wrong answer on SQL EXpress 2005. I am really lost now...

How do I get the transDate back on the query? or limit the query by the TransDate? Sorry I am very new to T-SQL.

I have them all in the same year and used your conversion so the query is now:

declare @StartDate datetime

declare @EndDate datetime

set @StartDate = '2/1/2010'

set @EndDate = '2/20/2010'

select convert(datetime, convert(char(10), TransDate,...

Ahh you would think it does but it does not.

Ya I knew that but I need those other values too?

One new tidbit is that if the time portion of the TransDate is different it sees the whole thing as...

You are correct in what you say you get. The problem is that I am getting multiple rows for a TransDate. The data I provided only had one...

I have never been able to find a way to use Group by without specifying all of the select fields. I only want to group by the TransDate and...