Before I look, could you at least answer my question?

GSquared (12/9/2009)

---

The rumor mill is seriously overclocked at this point. I think it's running...

Here is a little more knowledge that will be beneficial here on SSC. Read the first article I reference below in my signature block regarding asking for assistance, then...

Post the code for your trigger. Since you have made changes, it would be helpful to see the new code.

Bru Medishetty (12/8/2009)

---

ray 78019 (12/8/2009)

---

I have SQL Server 2005 and I need to create DTS packages (not SSIS packages). I installed the DTS add-on but the DTS node only allows...

GSquared (12/9/2009)

---

I just checked the...

Hope this code helps:

select substring(YourColumn, 1, charindex('-',YourColumn) - 1), substring(YourColumn, charindex('-',YourColumn) + 1,len(YourColumn) - charindex('-',YourColumn))

Bru Medishetty (12/9/2009)

---

Lynn Pettis (12/9/2009)

---

Krasavita (12/9/2009)

---

This is what I get:

Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c) 1988-2003 Microsoft...

Hard to help with just the problem description provided. Please read the first article I reference below in my signature block regarding asking for assistance. If you follow...

jcrawf02 (12/9/2009)

---

I have to say, jokes aside, I'm impressed with the group's psychic abilities, to be able to help someone with so little to work with. I think I've...

Thank you, Gus. There are times I can't post certain code snippets from work, and this was one of them. Can't include d r o p t...

Repost the code for your trigger. Since you have made changes we really need to see what you are actually running.

jcrawf02 (12/9/2009)

---

I have to say, jokes aside, I'm impressed with the group's psychic abilities, to be able to help someone with so little to work with. I think I've...

Check BOL for the syntax of the EXECUTE statement. I think you'll find that you need the OUTPUT statement on the parameters that are output parameters when calling the...

Is the following order of records guarantteed, or could you get a type 1 with no following type 0, or could you get 2 consecutive type 1's or 0's?

100, 2009-11-01...