There are also the ISQL and OSQL tools that will run your query from the command line.  They will generate a CSV file as output by default.

I have always found it to be easiest to import stuff from whatever file source into a temporary import table that has all the columns defined as varchar(big enough).  import...

Your external server will need to have permissions to read from the directory where the image file is stored.  Or depending on how the report is rendered, the whole world may need read permissions...

You have data quality issues in your input, that means you are going to have to do more than just BCP data.  I'd suggest a process something like the following:

1) Truncate...

I have to agree with Scott, in my evil developer hat there isn't anything you can do to stop me from using whatever access I have.  I can download shareware, trial versions,...

A long time ago, we had something similar to what you are looking for.  We set up a table and had the jobs update it when they started and when...

I had an issue with a report trying to process 2.4 million records.  it turns out that ADO will try to cache the data in ram and when it exceeds...

if this is a stored procedure parameter you can specify the default value

create procedure dbo.myproc(

    @bookid int = 0,

    @bookrate decimal(18,2) = 0

    )

make sure your application is clearing out the parameters from the previous stored procedure call before adding the parameters for this call.

is the sorting in Union an artifact of the implicit Distinct?

Union does an implicit Distinct on the recordsets being joined, Union All does not - you get All records.

you could use XSLT to transform your results into the format you want.  but i don't know of a way to add attributes to what SQL Server generates.

I had a similar problem.  I was working in SQL Reporting Services and had a very large dataset.  every time i ran it, the ASP reset itself, it takes about 15 minutes...

sounds like you're running a process to create a file to work on.  I's suggest have that process create a second file after the first is complete, then set your...

put an explicit cast on the assignment

dr.appt_time = (datetime) System.DBNull.Value