If your client is connecting to server1 and server1 is doing a distributed query on server2 (linked server) then you need to test connectivity from server1 to server2 (ie ping,...

Have you the rest of the error message which shows the library and protocol used. Has this ever worked? If so what has changed? Is the server behind a firewall?...

use either

SELECT @ProjectID,t.taskID,1

FROM tblTask t

or

SELECT @ProjectID,t.taskID,s.statusID

FROM tblTask t

CROSS JOIN tblstatus s

WHERE s.statusID = 1

First option will be faster as you do not need extra join but the second will only...

1. No. The data types are int and you can do what you like with them. IDENTITY is only used to create new number (int) when a row is inserted.

2....

create table #a (ID int,Year int)

insert into #a values(1,1993)

insert into #a values(1,1994)

insert into #a values(1,1995)

insert into #a values(1,2001)

insert into #a values(1,2002)

insert into #a values(2,1995)

insert into #a values(2,1996)

insert into #a values(2,2000)

insert...

declare @CT int

set @CT = 1

while @CT > 0

begin

insert into #tableb select LEFT(Team,CHARINDEX(',',Team+',')-1) AS 'Name',CallID from #tablea where Team <> ''

update #tablea set Team = LTRIM(REPLACE(Team,LEFT(Team,CHARINDEX(',',Team+',')),'')) where Team <> ''

select...

Try using isql with -b parameter.

If you want to insert into tblProjectTasks all the combinations of taskID and statusID then you can use

INSERT INTO tblProjectTasks

SELECT @ProjectID,

t.taskID,

s.statusID

...

FROM tblTask t

CROSS JOIN tblstatus s

No easy answers, depends on disk space available. If you have restrictions for the database, ie cannot create new table, copy & delete then your only choice is to export...

Is NewPrice defined as numeric?

Can you post data types for all fields (NewPrice,RGPSOPRC,SOPPriceIncrease.AMOUNT etc) and sample (non sensitive) data as well to show what you are getting and what you...

I have used that way as well but I also use

REPLACE(STR(table.version,2,0),' ','0')

don't know about performace though.

I always script my procs and therefore change the text files and update DB. In your case I would use EM to script all the procs into a single file,...

Cannot help you with AS400 connection as I have never done that. I do connect to a third party db using their own ODBC driver and found the best way...

ctcampbell, I agree that it is best to format dates as yyyy-mm-dd to avoid confusion. Your statement about bcp not properly convert a date like '20020310' may be true for...

Stephen,

The problem causing your date errors is due to you specifying zero length input. CHange your file to the following and try again.

8.0

7

1 SQLCHAR 0 5 "" 2 GroupCode ""

2...