Viewing 15 posts - 61 through 75 (of 1,473 total)
Does it throw a... particular... error? =)
February 9, 2011 at 8:18 am
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.
February 9, 2011 at 6:18 am
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...
February 8, 2011 at 2:38 pm
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...
February 8, 2011 at 2:03 pm
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...
February 8, 2011 at 1:22 pm
This is a duplicate post. Please make any responses here: http://www.sqlservercentral.com/Forums/Topic1058124-338-1.aspx
February 8, 2011 at 11:16 am
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...
February 8, 2011 at 11:11 am
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...
February 7, 2011 at 7:42 pm
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...
February 7, 2011 at 1:37 pm
You have a begin after your if, but not an end before your else. Add in the end.
February 7, 2011 at 12:19 pm
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...
February 7, 2011 at 10:52 am
hnaveen84 (2/7/2011)
February 7, 2011 at 10:34 am
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...
February 7, 2011 at 6:39 am
kazim.raza (2/4/2011)
February 4, 2011 at 1:34 pm
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...
February 4, 2011 at 1:26 pm
Viewing 15 posts - 61 through 75 (of 1,473 total)