Hello,

When requesting a date range, one must remember the time part of the date.

So whenever requesting a date range use code like this :

select *

from tablexyz

where...

Hello,

You should also check the permissions on the data base and the tables involved. If the .Net is accessing the data via a system login or ODBC definition it...

[font="Arial"]Hello,

In DTS when you are sending data it defaults any varchar field to 8000 in length. Why? Who in the world knows what Microsoft was thinking. However,...

[font="Arial"]

A little more clues are :

A varchar(8000) is the default value you are prompted with in DTS. That doesn't mean you have to use all of that.

Typically text files...

[font="Arial"]

Hello,

This error :

Could not get the data of the row from the OLE DB provider 'SQLOLEDB'.

[OLE/DB provider returned message: Row handle referred to a deleted row or a row...

[font="Arial"]

For a 40 million row process, I would create a single column table of the unique customer names/id's. Create a clustered key of those customer names/id's and...

[font="Arial"]

Hello,

I don't have a solution but I do have a couple comments and questions that might help.

In the UPDATE you are updating ad. It should be the first table...

[font="Arial"]

Hello,

If I understand your issue correctly, you have a driver table and a related table.

Let's say:

create table #driverTable

( rowId int identity

columnOne varchar(10) null,

column99 int...

[font="Arial"]

Hello,

You could use bcp or DTS for this process. There are more ways to do this process too. But these two are the simplest and some times the...

[font="Arial"]

The IsDate function does not support the date format entry in the order you presented it.

-- select ISDATE('13012008')

-- returns 0

Instead you should use some thing like this which all...

[font="Arial"]

Hello,

Are you restricted to using bcp? Could you use DTS instead as this would be an almost no brainer there.

If you pull the .fmt file up in an editor,...

[font="Arial"]

Hello

There are several ways to go about this problem. However, it would help to know if there are any other fields in T2.

For example, does T2 have an...

[font="Arial"]

Hello,

Your post is some what criptic.

If I understand correctly, you want to have a sproc create dynamic SQL into an output file with the extention of .sql on the client...

[font="Arial"]

May I suggest use set rowcount 1...for example:

create table tlb_test

( tname varchar(20) null,

tother int null )

insert tlb_test

select 'this', 1 union all

select 'This', 2 union all

select 'this',...

[font="Arial"]

Hello,

You should be using the bcp utility to output the data from the table built by the isql programming.

Regards,

Terry

[/font]