Adam Machanic (9/22/2008)

---

Matt Miller (9/22/2008)

---

Agreed. Still - my biggest objection to it is the separation of duties issue. Since we're back to putting what essentially boils down to...

cs_troyk (9/22/2008)

---

In addition to the automatic parameterization issues mentioned earlier, I have seen cases where the SQL emitted by a LINQ expression contains a cartesian product (CROSS JOIN) where it's...

Jack Corbett (9/22/2008)

---

Case

When IS_MEMBER('role') = 1 Then 1 -- is a member

Else 0 --...

That was kind of my thought when I started using it. And then I figured out that I could get everything I used to have through the Job Activity...

You're going to want to look up the OUTPUT clause, since you're using SQL Server 2005. This will allow you to spit out the ID from the initial phase...

The many reason to use a hierarchical data set is to have an unknown/undetermined number of levels. If you have a hard hierarchy like you have (and not some...

steveb (9/19/2008)

---

Terri (9/19/2008)

---

Matt Miller (9/18/2008)

---

It makes sure that the trailing spaces don't get truncated before you count them. (LEN will not count trailing spaces). by adding it to both...

You could simply use the "success" or "failure" options in the job definition to define branching.

It would look something like:

Step 1: do something for real

Step 2 (branching step)

do your count....

Chris' code will work if the max number of columns per encid is known. If not - you're going to have to build something that dynamically builds a query...

Depending on what you need this for, you might care to look at the ROW_NUMBER() function in 2005, or use the techniques described in this article.

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/%5B/url%5D

I can't say I've done a direct compare from 2000 to 2005 on function execution. That being said, even IF the 2005 functions execute faster than their 2000 counterparts,...

It makes sure that the trailing spaces don't get truncated before you count them. (LEN will not count trailing spaces). by adding it to both - it cancels out...

Except...It will return the wrong number if...

Personally I'd use the "generate script" and WinDIFF. This way you get to both find things that are different, and get right to the area of code where they...

Michael's right. It looks to be ms from 1/1/1970.

If my math is right - that's

9/17/2008 22:43:34.262

I'd assume that's being expressed in GMT time.