did you check my 2nd suggestion in my initial reply?

i had a similar issue, was a trigger causing the locks

how about this?

update distination

set [Column] = c.col

from (

select case when a.[Column] <> b.[Column] then a.Colum else b.[Column] end as col

from source a join destination b

on a.id=b.id) as c

your front end cannot connect to sql for some reason.

we need to check if sql is running, if it is, then we need to check if your login is valid.

once...

try this in your where statement

WHERE (CALLLOG.RecvdDate) >= cast(@start_date as datetime)

AND (CALLLOG.RecvdDate) <= cast(@end_date as datetime)

Your subquery is returning more than 1 row, and based on that, you want to update the lookup.

why not create a table with multiple columns for child, grandchild, etc and...

Hi,

This could have multiple causes

1. try connecting to sql to ssms with your user credentials

2. ensure the correct protocol is selected under SACM,i.e named pipes and tcp/ip

not sure what you...

wat about this?

create table tempstore(id int identity (1,1),

OrderID nchar(2),

OrderType nchar(3))

insert into tempstore(OrderID,OrderType)

select 'A', 'X' union

select 'B','Y'union

select'C','Z' union

select'D','YY' union

select'E','ZZ'

UPDATE Orders

SET...

hi there,

not too fimiliar with db2, but the principals should stand.

if your query is correct try testing your odbc connection. did you try and coonect with this via windows?

hi there,

please post your code

hi,

what are trying to do with your "iff" function?

Hi,

Not too clear on your question, but heres a possible solution.

1.Import text file to SQL

2.Create 3 variables, TotalRows, ValidatRows, InvalidRows

declare @ValidRows float

declare @InvalidRows float

Declare @TotalRows float

3. Assign values to variables...