The BEST way to get date formatting is in the front end. 😛

If you must use sql than use Lynn's approach.

You have different numeric sizes in two different columns.

It is probably failing in the where clause.

What is the datatypes for bondTrade.TradeID and IRPTrade.TradeID? I am guessing these are both numeric...

Eugene Elutin (5/9/2012)

---

Sean Lange (5/9/2012)

---

Phil Parkin (5/9/2012)

---

Looks like 62 points...

LOL I...

vinu512 (5/9/2012)

---

Are you implying that you need a Trigger?

here is something that I worked up. Hope it helps:

--Creating Tables

Create Table Ex

(id int not null primary key Identity(1,1), ...

There could be a zillion reasons for timeout. The most common is poorly written sql. Does this happen for all your sql or just certain procedures?

Hi and welcome to SSC!!! Before anybody has a chance at helping you, you need to provide a mountain of more information. We need ddl, sample data and desired output...

Wow your project seems to be full of bad development choices. The column names too are painful. Do all the tables have a column named ID that is the primary...

Did my pseudocode above show you how to do this or do you still need help?

I think the main point of confusion is that you have two unrelated tables of information. From what you posted there is nothing to join these on.

select *

from tableA a

join...

I would agree that you are over thinking this, but given the code you posted I think you need some help to resolve it. I will be happy to help...

Wow that is a bit off of how case works in sql. You are trying to use it to capture a bunch of rows and columns all at once. It...

With 526 points I would think you would know you should provide a bit more detail than this. This is totally a shot in the twilight.

update pjprojex

set rev_type = ''

from...

What is a max average salary? Do you...

That is awesome Steve!!! I am very happy for...