Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT into ADVNET.dbo.KenCatItemTest
- (categoryitemid,itemid,categoryid)
- SELECT NEWID(),itemid,'0FCA508F-7EB5-4C2E-8803-DE688C4126E5'
- FROM janel.dbo.item
- WHERE janel.dbo.item.itemnumber like 'c-%' and listprice > 0
- DECLARE @CategoryItemId uniqueidentifier;
- SET @CategoryItemId = NEWID();
- DECLARE @ItemID uniqueidentifier;
- SET @ItemId = (select itemid from janel.dbo.item
- WHERE janel.dbo.item.itemnumber like 'c-%' and listprice > 0 );
- DECLARE @CategoryID uniqueidentifier;
- SET @CategoryID = '0FCA508F-7EB5-4C2E-8803-DE688C4126E5';
- DECLARE @LineSequence int;
- SELECT @LineSequence = ISNULL(MAX(LineSequence),0) + 1
- FROM KenCatItemTest WHERE CategoryId = @CategoryId;
- INSERT INTO ADVNET.dbo.KenCatItemTest
- (CategoryItemId, ItemId, CategoryId, LineSequence)
- VALUES (@CategoryItemId, @ItemId, @CategoryId, @LineSequence)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement