I figured it out but if any one want to know how here you go:
PROCEDURE p_sync_sn
AS
BEGIN
MERGE INTO WWGD_SERVICENOT ES B
USING (
SELECT SERVICE_ID, CATGROUP, DESCRIPT, REBOOT
FROM HPSTYPE
WHERE CATGROUP is NOT NULL) E
ON (E.SERVICE_ID = B.SERVICE_NAME)
WHEN MATCHED THEN
UPDATE
SET B.SVC_CATGROUP...
parikhm3
Last Activity: Aug 1 '07, 01:26 PM
Joined: Jul 23 '07
Location:
-
I AM NOT A ORACLE GUY BUT NEED TO RUN THIS AS I RUN MY OWN BUSINESS. SO PLEASE HELP OUT.
CREATE PROCEDURE [dbo].[testINS]
(
@AValue int
)
AS
DECLARE @TType nvarchar(3)
SET @TType = 'INS'
BEGIN
INSERT INTO [dbo].[OriginalTable]([aValue]) VALUES (@AValue)
INSERT INTO [dbo].[TransactionsTab le]([TType],...Leave a comment:
-
HI,
MERGE INTO WWGD_SERVICENOT ES
USING HPSTYPE
ON <A's primary key> =<B's PRIMARY key>
WHEN MATCHED THEN
UPDATE SET (<B's SERVICE_NAME, REBOOT_FLAG, BITS_AVAIL, RTP_LEVEL, ETF_FLAG, DATE_VENDORRELE ASE, DATE_ACQUISITIO N, DATE_TEST, DATE_PRODUCTION , INDIVIDUAL_PROD UCTION, DATE_OBSOLETE, INDIVIDUAL_OBSO LETE, SVC_COMMENT, SVC_CATGROUP, SVC_DESCRIPT,...Leave a comment:
No activity results to display
Leave a comment: