Thanks friends,

Employee: @LastName, @FirstName

EmpEmail: @StudentEmailAddress

The above values are coming from query.

Thanks

Abhas.

Thanks Luis nad Hanshi. 🙂

Its working fine for me. 🙂

Thanks again

Regards

Abhas

Thanks twin,

All changes are aviliable in a table itself and we can idenitfy that changes by using EffectivestartDate column.

By using this column we can find out latest two...

Thanks Twinn,

But is it possible using query?

-- Create the test table

create table testTable (

field1 integer,

field2 varchar(30)

field3 varchar(30)

field4 varchar(30)

);

-- Populate the test table

insert into testTable values (1, 'Jane','abc','efg');

insert...

Hi All,

Thanks for your replies

Regards

Abhas

Thanks Sushil,

But how job/Package will execute? we need to give interval for run packages as small as possible rite. E.g. 1 minute or 2 minute. Correct?

Thanks

Abhas.

Hi John and Daniel , Thanks for your reply.

I need execute daily once only as soon as file aviliable for that location.

i.e. The file will be processed once in a...

Thanks Milos. 🙂

🙂 🙂 🙂

Its working. Thanks a lot

Thanks nicol,

very pretty solution. :).

Thanks

Abhas.

Thanks All,

I am doing the same.

SELECT

ROW_NUMBER() OVER (PARTITION BY t.CustomerName ORDER BY t.DateAdded DESC) AS RowNumber

from tblCustomer. but it is giving 1,2,3.....RowNumber.

I want again repeat RowNumber to each CustomerName.

Thanks

Abhas.

Thanks LinksUp

It is working for me . Thank you so much!

:-):-):-)

Thanks

Abhas

Hi,

Sorry Sowbhari,

its working.

DECLARE @StartTime VARCHAR(MAX),@X XML

SELECT @StartTime = '7:00 AM <br/> 12:30 PM'

SELECT @X = CONVERT(XML,'

' + replace(@StartTime,'<br/> ','</br>

') + '</br>')

SELECT x.i.value('.','varchar(max)') AS [StartTime]

FROM @X.nodes('//br') x(i)

Thanks.

Hi Sowbhari,

Thanks for reply but if i am using your approach, i am getting below error.

XML parsing: line 1, character 13, end tag does not match start tag

Thanks

Abhas

Thanks Phil,

But there is no Primary key in the target table , so can go with non-clustered index or clustered index?

Thanks

Abhas.

Thanks all,

if i use alies of linked server then its working. thanks again for your help. 🙂

Cheers

Abhas.