>>Bulk insert data conversion error (truncation) for row 10001

That error has nothing to do with the batch size... it has everything to do with the column size of your target...

Oh no, no, no... not true... check Books Online... every single example where a join is involved has the target of the update in the FROM clause, as well.  In...

Like I said... make a function using the SELECT examples I gave... then just do a joined select and use the function passing the date from one table...

Mike C,

Man, nice job.  I absolutely agree with Tim's assesment of the "AA" he speaks of.  The real fact is "NULLs Happen" ...

Speaking of "no clue"...

select(field1) + sum(field2) from #table1

... will yield ...

Server: Msg 8118, Level 16, State 1, Line 1

Column '#table1.field1' is invalid in the select...

I just love the fact that there's an average of more than 16 bytes of structure for every byte of actual data   It's...

Lot's of folks will do a calculation like this...

--===== A way without the WorkDayCountColumn

SELECT c.Date

    FROM #Calendar c

    WHERE

        c.IsWorkDay = 1

    AND 4+1...

I see you're online right now, Jeremy... gimme a couple minutes more and I'll show you one way to do this...

I want to avoid temp tables..trying to get in a simple select if possible from system functions.

Can you...

So, basically, it's a data model change with a cleanup script to boot and not a permanent stored procedure?

If that's true, then just add a GO on a separate line...

Thanks, SW...

Peter is correct, though... if all of the values for a given account number are <= 0, the account won't print (dunno if you want that or not).  Peter's...

Sam,

You took a good first step by defragging the DB.  Now, about that "slow query" and "insufficient memory" problem... "slow" normally means "resource hog" for CPU, IO, and Memory.  If...

I believe the training kit will give you a good idea... wait for the training kit before you book the exam...

This should do it...

--===== Setup a table to test with

 CREATE TABLE #MyHead (AcctNo VARCHAR(10), Month1 INT, Month2 INT, Month3 INT)

 INSERT INTO #MyHead (AcctNo, Month1, Month2, Month3)

 SELECT 'A',  -1,  ...

Since you're trying to print a PDF file, is Acrobat Reader or a print driver for PDF's installed on the server?