Sorry I meant to post the code. Man I am glad it is Friday.

SELECT DISTINCT A.Class,

CAST( CONVERT( CHAR(8), A.Origdate, 112) AS DATETIME),

SUM(A.totalpaid) As AmtPaid

FROM dbo.ad A

GROUP BY A.Class,CAST( CONVERT(...

Sorry about that I knew I was missing something. The problem is that when you display the date it has the time stamp and there for the nano secods...

this almost seams to simple of a question so I feal like I am missing somehting but.

select Class,OriginalDate,sum(AmtPaid)

from insertyourtablename

group by Class,OriginalDate

If you want to be able to use a temo table across sessions then you must create it a little differently. Now this is very tricky so I will...

Try select @query

print @query depending on how you are running this would only show up in the message line. It is possible it is working but you do not...

I would think having to join to a Dim table to query date would take more resources then storing the date as a date.

There are a few ways to output to a file so the first question would be how are you out putting this to a file. with ssis, sql statement,...?

I would think not converting it to date format would simply mean more work in other areas. I would assume you already deal with these things but it is...

I currently have 2005 and 2008 installed on my system at the same time. I have not had any issues at all with 2005 stince installing 2008.

It is not a Query but here is a link to an article that describes this very thing. I explains how to use a CTE to do this as well...

I guess I am a little confused by what you mean by refresh? based on the query you are running I would suspect that it would take so little...

We use 2005 mostly we are only using 2008 in test at this point but I do not beleive it would make a difference at all. Again I think...

I would talk to your SAN Admin to verify but there should be no reason for him to take down the LUNS when expanding them. As such there should...

Unless the SAN admin does something odd then increasing a LUN should not affect a thing. We often increase the size of a LUN and it has never had...

When I am editing a report that some one else desinged I make it a habit of grabbing the report directly from the production server. If you use some...