jcb (11/19/2013)

---

Question: a select count(1) from inserted ill return the number of inserted rows?

just for the record: avoid triggers, they are evil.

avoid to put business logic in the database, let...

John Hanrahan (11/19/2013)

---

Sean,

Here's the relevant code:

...

Maybe my question should be isn't @@rowcount always one 1 in a trigger? You can see they use @numrows to do error checking?...

John Hanrahan (11/19/2013)

---

In an Insert Trigger this code is sometimes quite slow: "SELECT @numrows = @@rowcount"

This code is used to determine if a row was inserted into the table....

boeledi (11/19/2013)

---

Am I wrong but we need to make the assumption that SQL Server ensures some kind of unicity constraints.

Therefore, in case of error, I will need to test the...

waxb18 (11/19/2013)

---

Essentially all i want to be able to do is use these tables to tell the story so to speak based on their dates and Journey ID.

So for journey...

Something like this?

begin try

begin transaction

--Insert Child (Mary)

DECLARE @Mgr hierarchyid

DECLARE @LastEmp hierarchyid

SELECT @Mgr = [HierarchyID] FROM hierarchies WHERE employeename = 'Nick'

SELECT @LastEmp = Max([HierarchyID].ToString()) FROM hierarchies WHERE [HierarchyID].GetAncestor(1) = @Mgr

INSERT INTO...

No it's cool. I would suggest though that you test this stuff before you post it. There were loads of errors. This is the script after I combined them into...

Save yourself months of anguish and use the hierarchyid datatype. This is essentially what you are trying to recreate on your own.

http://technet.microsoft.com/en-us/library/bb677290.aspx

We all have those things we can't change and often they are the most frustrating. Hopefully you at least realize how awful of a design that is and don't do...

waxb18 (11/19/2013)

---

Unfortunately i dont know if an order by will work. They are completely seperate tables not rows within one table.

I will do my best to get together some scripts...

waxb18 (11/19/2013)

---

Good Afternoon,

I have been tasked with creating a travel Itinerary, simple stuff....

however upon further investigation each part of a journey is stored in a different table each one with...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

And then it would be HIGHLY advisable to change your schema that you store dates in a date column instead of numeric. It will save you countless hours of pulling...

Revenant (11/18/2013)

---

I hope I will not disappoint you, Sean. My...

There is nothing wrong with your ddl. I am guessing this is on the .NET side. What does the code look like?