Does it throw a... particular... error? =)

That error means that the length of the character string you're trying to update to is bigger than the field can hold. Check your field lengths.

Awesome idea Lowell. One quick note, (and this is probably completely unnecessary in this particular discussion, but to anyone that wants to implement this method elsewhere), is to watch...

Ok, the gist of it what I'm talking about is just to get the data over into a temp table and then do whatever else you need to with it.

ALTER...

I don't know, how do the report numbers relate to the data you are getting? If they aren't in there, what piece of data determines what the report number...

This is a duplicate post. Please make any responses here: http://www.sqlservercentral.com/Forums/Topic1058124-338-1.aspx

I can't write you sample code because I'm honestly unclear on what you're trying to do still. If report number isn't in the oracle table, then how is it...

What are you expecting this to do?

declare @reportqry varchar(2000)

declare @rpt varchar(300)

If ((@rpt = '801') or (@rpt = '8') or (@rpt = '802') or (@rpt = '803'))

You're declaring a variable (which...

Honestly, I haven't been sanity checking that long select statement of yours, I've just been answering your syntax error questions. Simplify things first. Do just a select of...

You have a begin after your if, but not an end before your else. Add in the end.

You're probably going to be better off in this case by just doing something like :

IF @product = 'SHDS'

Select ...

WHERE d.resource IN ('FAM201','FAM202')

ELSE IF @product = 'SHDN'

SELECT ...

WHERE d.resource IN...

hnaveen84 (2/7/2011)

---

Hi there Thanks for getting back. The links reaaly helped me a lot. Am actually was able to execute the procedure with some values. But am having difficulty in...

Here's an example that does what you want. You probably *can* do this with unpivot or outer apply now that you took out the extraneous orderid's, but I didn't...

kazim.raza (2/4/2011)

---

home -> work instead of home -> shop means when the record inserted, it carried the value home, then it was updated to work and then updated to shop....

Also, why is OrderID present in this "audit" table without a change where as the other two are only present when there's a change? Is there an actual need...