Viewing 15 posts - 14,101 through 14,115 (of 15,381 total)
Are you wanting to get the results of that whole select? Look back at my example where I showed you how to execute a stored proc and get the result...
September 1, 2011 at 11:39 am
Glad you figured out and thanks for letting us know the resolution.
September 1, 2011 at 8:32 am
After reading your first post again it looks like you are trying to use the return values for an update. You can insert the data into a temp table so...
September 1, 2011 at 8:00 am
Notice the select statement is the last statement. It will return your select statement when you execute your proc. Look at the following:
create procedure ReturnTest
as
select top 50 name into...
September 1, 2011 at 7:54 am
You left of output when calling Proc2
EXEC Proc2 @Key1, @ReturnValue OUTPUT
September 1, 2011 at 7:11 am
gmamata7 (8/31/2011)
Hi,
In Oracle, If you do an update, delete and insert, then we can use COMMIT to commit the transaction and ROLLBACK to rollback the transaction.
How does this works in...
August 31, 2011 at 3:30 pm
Take a look at this example and see if it can help show how to get the value all the way back. This is only 2 levels deep but it...
August 31, 2011 at 3:23 pm
There are two ways you can accomplish this.
1) A stored proc will return the values of a select statement if it is the last statement in the procedure....
August 31, 2011 at 3:17 pm
PSB (8/31/2011)
I have to dynamically load records using this update statement below.
UPDATE V
SET V.VehicleID = A.[Equipment_ID]
FROM dbo.Veh V
INNER JOIN dbo.Comp C ON C.C_Link = V.C_Link
INNER JOIN dbo.Txns...
August 31, 2011 at 2:47 pm
As some folks around here say, "You can throw your boots in the oven, but that don't make 'em biscuits."
That is funny!!! I think we are 100% on the same...
August 30, 2011 at 3:25 pm
Oh that sounds like an interesting piece of work. I have never really used the sql_variant. Back in the old VB (or FP for some) days when everything was a...
August 30, 2011 at 3:16 pm
Excellent point!!
R.P.Rozema (8/30/2011)
OP provided us with ddl and test data, so I think he has earned the solution:
The cross tab will outperform the self join but here is how you...
August 30, 2011 at 2:39 pm
The basic gist of what you want to do. I am pretty sure you want to use Task and NOT TaskNote as your main table. Then join to TaskNote getting...
August 30, 2011 at 2:01 pm
If you can provide some ddl and sample data this is a pretty quick and painless task. Take a look at the link in my signature about the best approach...
August 30, 2011 at 1:59 pm
david.ostrander (8/30/2011)
I need some T-SQL help and hope someone can clear my head of this.
I have a query I want to be able to see the latest ModifiedDate...
August 30, 2011 at 1:50 pm
Viewing 15 posts - 14,101 through 14,115 (of 15,381 total)