I could put together a script that will build your insert into commands and run them dynamically if you would like.  I have built several scripts that dynamically build some...

How many tables in the database?

See post above yours.....  I just Editted it. 

Could you post the code you are using for your INSERT INTO?  Also, where are you running it from and where is the original database?

Try this:

declare @startdate datetime,

@finishdate datetime

select

    RM.fldPriorityCode as 'Priority',

    sum(case when datediff(day,RM.fldRequestDate,RM.fldComCanDate) <=5

        then 1

        else 0

    end) as 'Closed Calls 0-5 Days',

    sum(case when datediff(day,RM.fldRequestDate,RM.fldComCanDate) between 6 and 10

        then...

Try this:

select

    Case.CaseID,

    Borrower.BorrowerID

from

    dbo.Case

    inner join dbo.Borrower on (Case.CaseID = Borrower.CaseID)

It is my understanding that you can go either direction without any problems.

Tempdb is used during query processing for sorts, joins, unions, etc.  If you have enough poorly written code and a number of users, it is possible that tempdb is getting...

Okay... You will need to elaborate on that one.  Not really sure what you are talking about regarding "forms".

Since you have a backup, just restore the database.  When you do that, the database will be in 2000 compatibility mode.  You will need to go into the properties and...

After doing the above, restart SQL and then delete the original tempdb data and log files, as they will still exist in their original location.

Also depends on indexes as well.  If the datefield is indexed it should still run well, but I guess we'd have to find someone willing to test it on a...

Got beat, oh well!

Or you can try this:

select

    a.dtDate,

    datediff(dd,(select min(b.dtDate) from dbo.testtbl b where b.dtDate <= a.dtDate), a.dtDate) as AccumTime,

    datediff(dd,isnull((select max(c.dtDate) from dbo.testtbl c where c.dtDate < a.dtDate), a.dtDate), a.dtDate) as...

Why do you need the result returned as a comma seperated list?