Oh, you could try downloading Toad for SQL Server and see how that works.

I agree.  I had to wait for SP 2 to be released to load the SQL Server 2005 client tools on my Vista laptop, but I use it a lot...

Oh, and a few years ago I would have done it with nested cursors.  learned some tricks at a couple of interviews that have paid off nicely!

We are building a data warehouse.  Part of it includes what I will call an ODS (operational data store) even if it doesn't really fit that definition.  It will be...

I have loaded and patched the SQL Server 2005 client tools, and they work fine.  If you need to and can, install a virtual pc and load XP as the...

I don't have any documents to show you, all I can tell you is what we do.  Where I work now, our servers are rebooted weekly.  At my previous employer,...

I found a problem, my cut and paste was incomplete.  Here is the full code:

set nocount on

declare @SQLCmd varchar(max),

        @schemaid int,

        @objectid int,

        @loopcnt int,

        @DestinationDB sysname,

        @SourceDB sysname

set @DestinationDB...

If the database was setup with the wrong collation, a backup and restore won't fix that.

Try this code (I would comment out the exec statements first and see what the output of the print statements are first):

use DWODS /* probably want to set this to...

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)