BEGIN TRANSACTION
--temp db deki temp tabloya tasi
INSERT INTO rollback_table (ProductID,Name)
Select
ProductID, Name
From
tmp_table(NOLOCK)
--yukardaki islem basarili degilse bitir
IF @@ERROR<>0
BEGIN
ROLLBACK
RETURN 0
END
--datalari sil
DELETE FROM tmp_table
COMMIT TRANSACTION
WITH RN AS
(
SELECT groupid, val,
ROW_NUMBER() OVER(PARTITION BY groupid ORDER BY val, memberid) AS rna,
ROW_NUMBER() OVER(PARTITION BY groupid ORDER BY val DESC, memberid DESC) AS rnd
FROM dbo.Groups
)
SELECT groupid, AVG(1.*val) AS median
FROM RN
WHERE ABS(rna - rnd) <= 1
GROUP BY groupid;
http://www.evanreiser.com/
SET IDENTITY_INSERT table ON
EXEC SP_MOVE_PRICE_TMP
SET IDENTITY_INSERT table OFF
IF OBJECT_ID('tempdb..#tmp') IS NOT NULL DROP TABLE #tmp
CREATE PROCEDURE [dbo].[test]
@a int,
@TotaltCount int out
SET @TotaltCount = 10
DECLARE @ Count2 int
exec [PRW_SEL_SEARCH] 1,@Count2 output
select @ Count2
