Ans while looking for something else I stumbled upon this article, explaining bcp quite well:

http://sqlfool.com/2008/12/bcp-basics/

Have you tried using bcp? This is the most common way of exporting data to a text file, pick the bones out of this article:

http://www.sqlservercentral.com/scripts/BCP/65710/

BrainDonor

'Did not work'. Did it run without errors but have nothing in the temporary table, or did it show an error? Try removing the variable and hard-coding the filename first...

An entertaining question, but the formatting codes are all over it, making it difficult to read. I've seen this a few times now, so assume its a problem with posting...

The 'strong' tags means that there is an error, which needs correcting before it will run. Then when it runs it gives the warning, so it either has two answers...

So does your VB even need the first record set, or is the ultimate aim to have the second record set within the VB?

1 Charlotte Field Service 12

2 Hickory Main...

Your query can return two different recordsets, and then both can be extracted within the VB.

NextRecordset is the method that you'll need:

http://www.freevbcode.com/ShowCode.asp?ID=3058

http://msdn.microsoft.com/en-us/library/ms677569(VS.85).aspx

BrainDonor

Do the Regional Settings of that Client machine match the Regional Settings of the Server?

I used to work for a company that had customers across Europe and USA, so we...

There are two types of triggers within SQL Server 2005 - DDL triggers and DML triggers. Basically, they require something to happen to the database to actually run them.

DDL triggers...

It sounds like you're effectively trying to store several different Primary Keys in one table, which isn't the wisest thing to attempt. A table for each type of transaction would...

http://www.sqlservercentral.com/scripts/Miscellaneous/65769/

This should provide a starting point - it only searches one database.

It will certainly work, but every time the SQL requires a change you'll have to update the code, recompile and re-distribute it.

If you have the stored procedures then you can...

http://www.sqlservercentral.com/scripts/BCP/65710/

Using bcp and xp_cmdshell.

I've just looked at the data that the query is looking at and the time part of the datetime fields are always zero, so there's no need to do this...

Thanks Gail. I suspected that, and thought using a CAST and CONVERT wouldn't be too helpfull either.

If a selection is required on the date part of a datetime field what...