DontSaveSensitive

i think this problem was kind weird .but i got the solution after all

UPDATE dt

SET dt.wrange = CrsApp4.WkStrt + ' - ' + CrsApp4.WkEnd

FROM dt

CROSS APPLY (

...

even i tried without saving password.but still i am getting same error

the only difference is that the package which runs in all way i am using windows authentication but package which gives me error in integration services (SSMS) and in...

thanks all

sorry 2007-01-01 and 2007-01-08 in last update was flaw.

-----

Even i was working with the same way with this

update dt

set WRange=Wrannn from

(select convert(varchar,datepart(m,min(dates))) + '/' +

convert(varchar,datepart(d,min(dates)))...

I think this can help you understand what i want

create table dt(dates datetime,wrange varchar(40))

insert into dt values('2012-02-29 00:00:00.000',null),

('2012-05-30 00:00:00.000',null),

('2007-01-01 00:00:00.000',null),

('2007-01-08 00:00:00.000',null)

select * from dt

i want to update...

i want to use execute sql task..i have posted one more forum for this u having title=sql query and started by =weston_086.if possible please try to provide solution

thanks that what i want .but how we can pass variable for that and set that in case expression.

hi

i am working as a developer .so when i tried to use this query

SELECT *

FROM OPENROWSET('SQLOLEDB','Server=yourservernamehere;Trusted_Connection=Yes;Database=Master', 'Set FmtOnly OFF; EXEC...

thanks it works

with cte (id,name,class,rn)

as

(select id,name,class,ROW_NUMBER() over (PARTITION by id ,name,class order by ID) from jtdup)

delete from cte

where rn>1;

select * from jtdup

with