Viewing 15 posts - 7,816 through 7,830 (of 18,926 total)
How can the reports not have been built in BIDS (or anything similar)? There's no way in hell that someone touched typed all that code in XML, in notepad...
September 1, 2010 at 8:38 am
No, you need to find the 1 sku that makes the proc fail. When you read the executions results from the job you see that it succeeds a few...
September 1, 2010 at 8:33 am
Maybe I was not clear. COPY the sp and call it update inv BATCH or whatever you like and make the changes there.
There's no magic bullet for this one,...
September 1, 2010 at 8:18 am
How long can a inventory update get???
You can always post the code as attachement if you want.
September 1, 2010 at 7:56 am
I'm not sure anymore, but it might also be the case if the parameter is varchar(30). I don't remember if that throws and error, but it sure can make...
September 1, 2010 at 7:52 am
Yes it's possible.
However I would reverse engineer that sp and make it run for multiple codes at the same time rather than 1 at the time.
If you send the sp...
September 1, 2010 at 7:47 am
only 2 possible options :
1 - DECLARE @POPRCTNM AS VARCHAR(40)
It's possible that the data column is more than varchar(40).
2 - The SP you call is failling on some...
September 1, 2010 at 7:46 am
dunne.neal (9/1/2010)
another basic questionon the server where the report are kept you would expect some .rdlc files wouldnt you?
i cant find any of the existing reports on the server
You can't...
September 1, 2010 at 7:42 am
DBAgal (9/1/2010)
I should also mention that I can not create any of my own indexes on the tables, because it voids the support.
I does not have to.
Assuming you have a...
September 1, 2010 at 7:39 am
So exactly like ssc started :w00t:.
August 30, 2010 at 4:45 pm
Can it be done by telecommute?
What kind of shares were you thinking about?
What's the deadline set for the project?
August 30, 2010 at 4:37 pm
Leo.Miller (8/30/2010)
1) Never use SELECT COUNT(*)...
Besides being lazy coding, SQL assumes you actually want to count all the columns. Since you only actually need DepositEntryId rather use SELECT...
August 30, 2010 at 4:33 pm
RalphWilson (8/30/2010)
Steve Jones - Editor (8/30/2010)
I've always seen "N/A" as "Not applicable", but you give some good other responses that might be used. Hence another point for the "non-nulls" argument.
I...
August 30, 2010 at 12:28 pm
alen teplitsky (8/30/2010)
say you sign up a customer today and promise some service that will be done in the...
August 30, 2010 at 12:24 pm
Ninja's_RGR'us (8/30/2010)
Grant Fritchey (8/30/2010)
Lots of columns, one table... eh.Try messing with an 86 table join. That's when life gets interesting.
especially if the columns are not qualified and that you don't...
August 30, 2010 at 9:00 am
Viewing 15 posts - 7,816 through 7,830 (of 18,926 total)