Mine is similar to Goldie's. Main difference is that the IncidentType column has the desired text (instead of the column name), and it is sorted according to the sort order...

WayneS (5/12/2010)

---

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...

PHXHoward (5/13/2010)

---

I came up with this as an if but it isn't working right now.

([YearE]== '00' ? NULL : (DT_DATE)

...

You might want to look at sys.all_sql_modules... it's the replacement for syscomments

It's close. It should be:

DELETE FROM Products FROM Products AS P1 JOIN NewProducts AS P2 ON P1.id = P2.id

Note that the first FROM is optional, so it also could be:

DELETE...

With variables Year (int32), Month (int32), Day (int32), use this:

(DT_DATE) (

(DT_STR, 4, 1252) @[User::Year] + "-" + ...

Only 75%? I would have expected much better... closer to 90%. What else is...

I've used both. Both are excellent products.

ERwin has continually increased their price to where, IMO, it's not worth it anymore.

I would caution you: if you can't explain...

That he does. But...

First, if you're going to use the FROM clause in an UPDATE statement, you MUST include the table being updated.

Since the field being updated is coming from a PK...

urzsuresh (5/13/2010)

---

This is my table structure

tag table

Tag TableName FieldName

abc wc s_name

lbl ...

Robb Melancon (5/13/2010)

---

Ok so everything is working... almost. The first problem I am running into is that I need to reset some values when an asset changes. Should...

Lowell (5/13/2010)

---

TheSQLGuru is right! this forum is one of my first items on my list of resources!

...

Ninja's_RGR'us (5/13/2010)

---

Glad to see I'm not insane :w00t:.

Here's...