toneranger (12/18/2013)

---

Is it possible to set a field value in a table based on 2 field values in 2 different tables? Which table gets the trigger?

Triggers are like events for...

That is the circular referenced verbose version. 😀

Like this?

CREATE FUNCTION dbo.fn_parsename

(

@pString VARCHAR(7999),

...

You will end up with something similar to this.

declare @Something table (SomeValue varchar(50))

insert @Something(SomeValue) values('01-08-087-0101W5')

select *

from @Something

cross apply dbo.DelimitedSplit8K(SomeValue, '-')

Take a look at the link in my signature about splitting strings. This is probably the best approach for what you are trying to do here.

cdl_9009 (12/18/2013)

---

I am trying to write logic that says:

(( Status = 'P' --PENDING

AND TYPE = 'P' ) --PRIMARY

OR (STATUS = 'C' --CURRENT

...

I guess you didn't like my response on your first version of this question? http://www.sqlservercentral.com/Forums/Topic1524214-149-1.aspx

When you create multiple threads on the same topic your responses get fragmented and it is...

I didn't realize the entire scope of the issue on my first post.

You may have to go so far as adding an ItemCodeEffectiveDate to your main table to so you...

mcfarlandparkway (12/18/2013)

---

Using these two querys

Select * from SNLunchSevereNeeds Where SystemCertificationID in(

Select SystemCertificationID from SNSystemCertification where FiscalYear=2014 and

SystemID=749 And IsActive=1 )

Select * from SNLunchSevereNeeds Where SystemCertificationID in(

Select...

You don't need all the extra variables and such in these calculations either. Everything is based off getdate() so there is no need to store interim values. This can all...

MysteryJimbo (12/18/2013)

---

I wouldn't use that approach for a simple date calculation. There are no table...

Hi and welcome to the forums. Why do you need a cursor for this? From what you posted I think you can replace the entire body of your stored proc...

sturner (12/18/2013)

---

I'm not a proponent of having parents and children in the same table - the justification hasn't ever been made other than being able to have everything in one...

You should have a primary key on your table. Since you have two columns and the values can be changed for either of them you should add an identity column....

Displaying tabular information...