Viewing 15 posts - 1,231 through 1,245 (of 3,544 total)
If the first proc is truly retruning only one row then make ID an output param and capture it in a variable then execute the second proc using that variable.
e.g.
DECLARE...
Far away is close at hand in the images of elsewhere.
Anon.
August 12, 2010 at 6:58 am
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value
Most common reason is the default language setting on your logins as this...
Far away is close at hand in the images of elsewhere.
Anon.
August 12, 2010 at 6:46 am
This is 'a depends' answer.
You can use either, if all the csv files are of the same format then you could BULK INSERT to a staging table before transfering to...
Far away is close at hand in the images of elsewhere.
Anon.
August 12, 2010 at 6:28 am
giosermao (8/10/2010)
Please receive my sincere and more than eloquent thanks.
Your welcome.
and thank you for yours 🙂
...made me think that we need to do things better, I want to change...
Far away is close at hand in the images of elsewhere.
Anon.
August 11, 2010 at 3:27 am
Notwithstanding the comments already made, I believe this is what the translation of your query would look like, ie trying use the IN predicate on a column value.
SELECT s.StatusID +...
Far away is close at hand in the images of elsewhere.
Anon.
August 10, 2010 at 2:13 am
skcadavre (8/4/2010)
Jack Corbett (8/4/2010)
Far away is close at hand in the images of elsewhere.
Anon.
August 4, 2010 at 9:58 am
Jeff Moden (8/3/2010)
Same here... I just don't want to become an Oracle DBA. 😛
Shame Jeff,
I'd love to see the Pork Chop launcher backfire 😉
Far away is close at hand in the images of elsewhere.
Anon.
August 3, 2010 at 7:24 am
Steve Jones - Editor (7/16/2010)
Kit G (7/16/2010)
The Dixie Flatline (7/16/2010)
It was a dark and stormy night....As I sat down to write...
I was quite a sight...
That you're all wrong and I...
Far away is close at hand in the images of elsewhere.
Anon.
July 17, 2010 at 10:03 am
Tom.Thomson (7/15/2010)
The post from David Burrows was far from the total fail you claim.
Thanks Tom 🙂
I think this thread is on the slippery slope to oblivion 😉
Far away is close at hand in the images of elsewhere.
Anon.
July 15, 2010 at 6:51 am
Any ideas you have for bumping up membership, I'm all ears.
Yeah, pay for my time off work and the flight across the pond and I'll join. 😀
Wish I could have...
Far away is close at hand in the images of elsewhere.
Anon.
July 15, 2010 at 6:48 am
doobya (7/15/2010)
in VB6 you can control whether a given block of code is resumptive or not
Not entirely true, it 'depends' on the definition of 'a block of code' and where...
Far away is close at hand in the images of elsewhere.
Anon.
July 15, 2010 at 6:43 am
doobya (7/15/2010)
VB6 is a good example, because you can use.....
You seem to have a singular point of view in that no one agrees with you.
On Error Resume Next
I would like...
Far away is close at hand in the images of elsewhere.
Anon.
July 15, 2010 at 5:40 am
Excuse the caps but I am getting frustrated when people are missing such a simple point
No one is missing the point. TRY...CATCH does exactly what you describe, it catches...
Far away is close at hand in the images of elsewhere.
Anon.
July 8, 2010 at 2:07 am
Tom.Thomson (7/7/2010)
David Burrows (7/7/2010)
However the first programming language I used was CESIL (the version from the late 1960's) 😎
CESIL? :Wow: Good heavens! And you went into computing after that?...
Far away is close at hand in the images of elsewhere.
Anon.
July 7, 2010 at 6:57 am
Tom.Thomson (7/6/2010)
David Burrows (7/6/2010)
Tom Brown (4/23/2010)
EDSAC !My word - that was ancient history when I started on ICL 1900s
Not that ancient when I started on an Elliott 803 !!
Elliot...
Far away is close at hand in the images of elsewhere.
Anon.
July 7, 2010 at 2:02 am
Viewing 15 posts - 1,231 through 1,245 (of 3,544 total)