Toreador (5/13/2010)

---

Interesting - it never occurred to me that the identity values wouldn't be available in the inserted table!

So how would you get the identity values of the rows you'd...

Good Excellent question. Learned quite a bit in the 2nd link (INSTEAD OF trigger).

FYI, in the explanation, it should be the string 'AnotherString' to be replaced with 'Stub', not 'TestString'.

Very well done Grant! There was a lot of "yeah!" moments in there.

Thanks!

Does anyone know of a FireFox (3.6.3) Add-on that provides a toolbar for supporting enhanced text fields (where you can directly format the text in a field) , such as...

set @YourVar = ((select ... FOR XML))

Jim,

In order to help you replace this with a set-based routine, we will need the following information from you:

1. DECLARE @ModelJob TABLE statement (so we know the structure of what...

Hmm, his last post...

Steve Jones - Editor (5/12/2010)

---

There are always new people, which is why we reprint older, good articles from the past at times. Nobody sees everything, and there is a need...

JacekO (5/12/2010)

---

Wow.

I did not expect to get so many posts before I even show up for work.

Looking at all the replies, one potential explanation for some of the...

Robb,

A while loop is no better, and frequently worse, than a c.u.r.s.o.r.

From what you describe, Jeff's article (that Lutz mentioned above) should handle your situation. I've seen solutions based on...

In addition to the above, what about a where condition. Where's on columns not in an index can force a table scan.

One common use of the top 1 is to...

You can add mine also to the sharepoint site.

Dohsan (5/11/2010)

---

I believe you can also use the QUOTENAME function here

http://msdn.microsoft.com/en-us/library/ms176114.aspx

SELECT'EXEC Sproc '

+ ...

Good article.

Having that username/password in a batch file is an issue. If (for any reason, like the FTP server is down) the package fails, that file could be left behind,...

Lynn Pettis (5/10/2010)

---

Who else is going to listen to the problems we have encountered and how we solved them, or what accomplishments we may have achieved at work? My...