Viewing 15 posts - 106 through 120 (of 190 total)
ramya.he (8/7/2009)
dgfghgf
Thanks for your insightful reply. Exactly the SQL syntax I was looking for. Works like magic under my where clause! 😎
August 7, 2009 at 6:36 am
never mind. problem solved, dont need to initialize it, maybe Lynn meant something else and i confused it. sorry for the hi-jack.
August 6, 2009 at 8:36 am
ta.bu.shi.da.yu (8/6/2009)
Just run:
set @value = 3
exec dbo.dummystoredprocedure @value
print @value
where dummystoredprocedure has some sort of NOP (e.g. select 1).
You'll see that the value after the exec doesn't...
August 6, 2009 at 8:28 am
GSquared,
In another post, I saw Lynn say that the variable needs to be initiliazed to zero (0).
My concern is, does the variable have to be initialized after every update/insert? meaning...
August 6, 2009 at 8:25 am
Yes, I am calling another stored procedure from within a stored procedure. I can't actually run any of the updates and inserts at this point so can't do print. Though...
August 6, 2009 at 8:18 am
ta.bu.shi.da.yu (8/6/2009)
Slick84 (8/6/2009)
Lynn Pettis (8/4/2009)
I may have missed it, but you will want to ensure that @RESULT is initialized to zero (0) before you start the update.
How would you initiliaze...
August 6, 2009 at 7:30 am
Lynn Pettis (8/4/2009)
I may have missed it, but you will want to ensure that @RESULT is initialized to zero (0) before you start the update.
How would you initiliaze the @result...
August 6, 2009 at 7:18 am
Suresh,
You could use SQL profiler to set a trace and run the select query. It should give you some helpful information.
Thanks,
S
August 4, 2009 at 9:37 am
That's true Matt. That was exactly the reason that threw me off and got me confused. So I did use parentheses in my next statement. In the first update I...
August 3, 2009 at 1:05 pm
Aah... you know what.. I think I have this figured out. I was trying to update Table B above, I just used AND's in the criteria and then added another...
August 3, 2009 at 12:40 pm
Jack Corbett (7/29/2009)
It Depends on the servers, the network, and activity. I'd be more inclined to use bcp/bulk insert or SSIS to do something like this.
BCP utility would be...
July 29, 2009 at 12:50 pm
mtucker (7/28/2009)
Lynn Pettis (7/28/2009)
July 29, 2009 at 7:04 am
sashikanta.mishra (7/29/2009)
I do not agree that Brad will get more hate mails as this is his individual research and thought.
But speaking through the relation of nature of...
July 29, 2009 at 6:52 am
Robert.Smith (7/27/2009)
Self-congratulatory bollocks.Pick almost any career (architects, police, trades, heck even pot growers) and the people doing it will claim to be stable, family-oriented, hard-working, community-minded.
Robb
Thats true.. and hilarious :w00t:
July 27, 2009 at 9:35 am
Lynn Pettis (7/26/2009)
Slick84 (7/26/2009)
July 27, 2009 at 6:46 am
Viewing 15 posts - 106 through 120 (of 190 total)