It sounds to me like it's your video driver.

However, in SQL Analyzer there is an option as to setting the length of results lines. Is yours set to exceed...

Hello,

Concatenating strings is no problem but you may have to get a bit creative to avoid the limitations on text lenghts.

Look at the spec difference between varchar's and...

Hello,

There are several ways to go about this.

One way is to build a working table with a row id and a column of say 500 characters.

create table workTable

( rowId int...

Hello,

When you have two values you want to compare and either one may be a null, then you use the IsNull function with a default value that's meaningful.

For example:

select count(a.*)

...

Hello,

The 3 could be referring to a third column in a table or select statment.

For example,

select 1, 2, 3

from table_xyz

order by 3

The engine will list the first, second, and...

Hello,

He might be referring to creating more stored procedures that are called by a main program. Each of the called stored procedures would have a definable segment of the logic...

Hello,

DTS has capabilities in this area. I wonder though why you want to avoid using BCP.

I would guess we should know more about your operational environment conditions. Are...

When the stored procedure is executed is it focused on the same data set as when you use the query window?

ie.. use mydataset

exec my sproc

I think the problem lies with the '1998-12/31'....shouldn't it be 1998-01/01 ?

WHERE MEM.MBR_BIRTH_DT BETWEEN '1995-01-01' AND '1998-12-31'

Regards,

Terry

Hello,

Turn off the shipping in the job scheduler.

Check MicroSoft's website with log shipping 2005 and it gives you some guideance.

Regards,

Terry

[font="Arial"]

Hello,

I'm not sure I understand your needs clearly however there are a couple of approaches you may want to try.

There is a batch variable called @@error that you can use...

Hello,

Another way to do it is to use a .bat command file and use bcp to out the data and bcp in to load the data to the other server.

Renaming...

If these data bases are on the same machine you might try something like this:

declare dnameStr varchar(30)

set dnameStr = 'ts2_' + @site + '_app'

select custid,...

You may have already done this...but I would recommend you change the table definition for this column that should not allow nulls.

Hello,

Something like this should work

where convert(varchar(10),EffDt,101) >= '06/01/2020'

and convert(varchar(10),EffDt,101) <= '06/30/2020'

I confirm, the 101 is the Convert format for MM/DD/YYYY.

However, consider these results:

select count(*)

from statement

...