I would hate taking over the maintenance of a database which contained triggers like this. On behalf of those who may have to maintain your code in future, please reconsider....

inmallinath (12/4/2012)

---

I had tried this a while ago. This messes up the use of office applications.

When you launch any of the office applications, it starts to install the software.

Am I...

Saintmount.Sql (12/3/2012)

---

Thanks for your reply,

But I want to insert below selected values to another table by random way.

Ex:

select Distinct code_id from Pri_codes_master

where code_description like '%assignment%'

--ORDER BY NEWID()...

As far as I know, the format of files generated by either the 32-bit version or the 64-bit version of Excel is exactly the same - so referring to '32-bit...

You've made it more complex than it needs to be - no need for the SQL Server variable. Just this should be fine:

select top 1 code_id from Pri_codes_master

where code_desc...

You just have to remove the FK relationship which is preventing the deletion first:

update fk_test

set fno = null where fno = 5

delete fk_test where eno = 5

select * from fk_test

I wrote the above response before trying Craig's solution, which certainly does the business - thanks! Maybe this is one instance where a loop is the best solution. I'll leave...

First of all, thanks to everyone who has taken the time to think about this problem and contribute. I spent over an hour blowing recursion limits left, right and centre...

Correct.

rhythm.varshney (11/27/2012)

---

Phil Parkin (11/27/2012)

---

There is no good way of doing this in SSIS - I'm with Jeff on this one.

If you want to put an SSIS 'wrapper' round it, something...

There is no good way of doing this in SSIS - I'm with Jeff on this one.

If you want to put an SSIS 'wrapper' round it, something like this would...

You still have not asked a single question - there is nothing to respond to.

Have you tried {CR}{LF}?

In your Flat File connection manager, what is the value of the Row Delimiter property?

rhythm.varshney (11/25/2012)

---

Phil Parkin (11/25/2012)

---

rhythm.varshney (11/25/2012)

---

I need to import the data into the table.The logic is If Type is MSAD then it should update MSAD...