sorry...YES.  I do want to display all 3 status counts for each day regardless if there 0 counts for that status or 50 counts for that status.  If there are no...

I am having trouble with your post...could we try something more simple for me to get the underlying logic?  Maybe we can do a select of 4 days and keep it...

If I use as suggested with "left outer join on" then none of my where statements work correctly.  I get 18,000 results instead of 26.

Thanks Brendt, Peter, DAVNovak...all of your similar code DID accomplish what I was looking for.  I feel like a newbie that I did not think of using multiple case statements instead...

Thanks to both of you, I really appreciate your time and assistance.  I will take the above TSQL and start exploring.  I am an SQL 2000 newbie so I will...

yes, I am going to change them all to dbo

Thanks, that worked perfectly....

Thanks For your continued Help.

Thank you that worked Just great!!

Thanks For your continued Help.

how to I find out the size of the tran log in 6.5?

Thanks For your continued Help.

Thanks....

Tempdb is on it's own since I set it up.

Truncate Log on Checkpoint has always been selected, I learned that one a while ago.

I dropped all tables and stored procedures...

I know, I know....we are finally going to SQL2000 in June. I have been pulling my hair out with the limited functionality of 6.5. Thanks for the suggestion....

Nevermind. I was able to develop the correct syntax. the below worked well when length of field is 3:

update table_name

set field_name = ('00'+field_name)

where len(field_name) = 3

Thanks For your...

Thanks for all the help...there is no "cast" in 6.5 I am just going to re-create the column and re-enter the data...this is way too time consuming. I...

Thanks Greg...I was able to find out that there are NO constraints for my table. If this is the case I should be able to just insert the data...

what are the steps to drop the constraints?

Thanks For your continued Help.