Viewing 15 posts - 4,276 through 4,290 (of 14,953 total)
Scott-144766 (5/18/2011)
Thanks for the reply. I can confirm there are no spaces in the object name or in the SQL code I posted.
This piece, as you posted it, has a...
May 18, 2011 at 7:24 am
Brandie Tarvin (5/18/2011)
Jim Murphy (5/17/2011)
Koen Verbeeck (5/17/2011)
And now I've reached the 5000-points milestone.W00t w00t! :w00t: 😎 :hehe:
Ahem.... Back to the tasks at hand... 😀
Excellent! Good job helping the community.
Wait....
May 18, 2011 at 6:13 am
There's a space in the object name. If you have spaces, or a variety of other characters, in the object name, you have to enclose it in square-brackets to...
May 18, 2011 at 6:10 am
GilaMonster (5/17/2011)
Oh, forgot to ask. Is this a distributed transaction? (some reference to a remote server)?
Yes. It's an ETL staging database that pulls from one server and feeds to...
May 18, 2011 at 6:09 am
Brandie Tarvin (5/17/2011)
jcrawf02 (5/17/2011)
May 17, 2011 at 12:57 pm
free_mascot (5/17/2011)
If able to get sufficient time to perform it as a safer side....
May 17, 2011 at 6:59 am
If you want to flag a row for replacement, you'd do that in the table itself.
Add a column "UpdateFlag" to the table. You could either make it a bit...
May 17, 2011 at 6:58 am
You theoretically could that in the table and procedure.
Add a "flagged for update/replacement" type column. If the query finds a row exists with the requested values, it flags that...
May 16, 2011 at 1:10 pm
A dataset returned the calling proc is, by default, returned to the client.
Here's a proof-of-concept demo:
USE ProofOfConcept;
GO
CREATE PROC MyInnerProc
(@Param_in INT)
AS
SELECT @Param_in AS MyInnerProcValue;
GO
CREATE PROC MyOuterProc
AS
EXEC MyInnerProc 1;
GO
EXEC MyOuterProc;
Is there a...
May 16, 2011 at 12:37 pm
Peoplesoft and JD Edwards are Oracle products, not Oracle competitors. The survey was about Oracle products, not just about their database engine, so it would naturally include both of those.
Ah,...
May 16, 2011 at 12:31 pm
Jack Corbett (5/16/2011)
It was great to see you at SQLRally and I'm glad you found it valuable and valuable enough to consider attending the Summit. That was one of...
May 16, 2011 at 12:23 pm
Stefan Krzywicki (5/16/2011)
GSquared (5/16/2011)
Stefan Krzywicki (5/16/2011)
SQL Server's not even mentioned, I guess we have a way to go in being considered suitable for very...
May 16, 2011 at 12:04 pm
Actually, the thing to look at is: If it's order-dependent, is it a good idea to try to make it "set based"?
Sets, in relational theory, are naturally unordered data. ...
May 16, 2011 at 12:00 pm
Stefan Krzywicki (5/16/2011)
SQL Server's not even mentioned, I guess we have a way to go in being considered suitable for very large databases. A...
May 16, 2011 at 11:44 am
Viewing 15 posts - 4,276 through 4,290 (of 14,953 total)