declare @t table (ID int, VALUE int)

insert @t select 1, 0

insert @t select 1, 0

insert @t select 1, 1

insert @t select 2, 0

insert @t select 2, 0

select t1.*

from @t t1...

Is it homework?

Try to use sp_OADestroy in your function,

Also, just in case, execute:

SET ROWCOUNT 0

before update

That is performance killer trigger!

You should avoid using cursors when coding in T-SQL. Especially for this sort of tasks.

We will need a bit more details from you about what are...

Do you perform a stand alone update statement or there is something else in this script/batch (which includes SET ROWCOUNT 128)?

Any triggers on a table?

May be there are only 128...

I have an advice for OP:

Do it the most suitable way you think it should be done. Call it somehow different, so your requester will not be able to recognise...

John Mitchell-245523 (3/12/2012)

---

mandirkumar (3/12/2012)

---

As requirement owner says there is no much flexibility in SSIS as in T-Sql query, so decided not to use SSIS, as I know BCP and others...

Yes Gail! You are absolutely right, that's why no terminator before WITH in a view...

It was a discussion recently here about when and where to use statement terminators. Actually, I've...

Ken at work (3/12/2012)

---

I'll pass that along,

Also something I noticed. Looking at the Where the second on 'PR_STATUS' is a data type "nchar(1)".

All of the 'Pay_Type_ID's are nvarchar(2). ...

I guess, they mean that they have no idea how to use it, or they do have pretty good...

GilaMonster (3/12/2012)

---

Also take the ; before the WITH out. ; is a statement terminator, you don't start statements with a symbol that marks the end of a statement (just like...

I would call it "in a more edible, but still noodles form" 🙂

"GO" is not a T-SQL command, it's a batch terminator for...

Gianluca Sartori (3/12/2012)

I recently wrote an article (publication due on march 23) on formatting/parsing dates in SQL Server and I found very interesting results on this topic.

Parsing a string to...

Jeff Moden (3/12/2012)

---

For the most part, I agree but there are some grand exceptions. There are many places where T-SQL code will beat SQLCLR simply because the T-SQL doesn't...