Attachment 82306 Details for Bug 66765 – text file which was copied into spreadsheet

text file which was copied into spreadsheet

AddCallPartAnalysis.txt (text/plain), 3.77 KB, created by Tim Jowers on 2013-07-11 00:17:46 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Tim Jowers

Created: 2013-07-11 00:17:46 UTC

Size: 3.77 KB

patch

obsolete

>exec CPEC.dbo.zDP_SVC00950SS_1 'CPEC01','TEST 1'
>exec CPEC.dbo.zDP_IV00102SS_1 'TEST ITEM',2,'TJOWERS01'
>exec CPEC.dbo.zDP_IV00102SS_1 'TEST ITEM',1,''
>exec CPEC.dbo.zDP_SVC00951SS_1 'TEST ITEM'
>exec CPEC.dbo.zDP_SVC00998F_1 NULL,NULL
>exec DYNAMICS.dbo.zDP_SY02100SS_1 7,949,6,0
>exec CPEC.dbo.zDP_SVC00710SS_1 'TJOWERS01','',1,'0000004190','TEST ITEM',16384,0
>BEGIN DECLARE @num int EXEC CPEC.dbo.zDP_SVC00710SI '0000004190', 1, 'TEST ITEM', 16384, 'Do not use or inventory. Testing purposes only', 'TJOWERS01', 99.00000, '', 'TJOWERS01', 99.00000, 'EACH', 0.00000, 0.00000, '', '', 0, 1, '', 0, '', '', '', 2, '', '1900.01.01', 0, '', 0, @num OUT SELECT @num END
>BEGIN DECLARE @num int EXEC CPEC.dbo.zDP_SVC00203SI 2, '0000004190', 1, 16384, 'P', 'BO', 'TJOWERS01', 'TEST ITEM', 'C', 'Do not use or inventory. Testing purposes only', 'TJOWERS01', 'EACH', 99.00000, 0.00000, 99.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, '1900.01.01', '00:00:00', '1900.01.01', '00:00:00', '', '', '', 0.00000, 0, '', 0, 100.00000, 100.00000, 100.00000, '1900.01.01', '', 0.00000, 0, '', 0.00000, 0, 0, 0, 'CPEC', 2, '', 0, '', 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, '', 0, '', 0, 0.00000, @num OUT SELECT @num END  
>
>declare @p1 int
>set @p1=4
>exec sp_prepexec @p1 output,N'@P1 char(4),@P2 char(4),@P3 char(12),@P4 smallint',N'BEGIN UPDATE CPEC.dbo.SVC00200 SET SRVSTAT = @P1 WHERE SRVSTAT = @P2 AND CALLNBR = @P3 AND SRVRECTYPE = @P4 SELECT @@rowcount END ','BO  ','ENT ','0000004190  ',2
>select @p1
>
>Second run adding a Part in GP
>
>-- SVC_Inventory_Requirements_Work	SVC00710
>-- SVC_Service_MSTR_Line	SVC00203
>
>BEGIN DECLARE @num int EXEC CPEC.dbo.zDP_SVC00710SI '0000004190', 1, 'TEST ITEM', 49152, 'Do not use or inventory. Testing purposes only', 'TJOWERS01', 99.00000, '', 'TJOWERS01', 99.00000, 'EACH', 0.00000, 0.00000, '', '', 0, 1, '', 0, '', '', '', 2, '', '1900.01.01', 0, '', 0, @num OUT SELECT @num END
>
>BEGIN DECLARE @num int EXEC CPEC.dbo.zDP_SVC00203SI 2, '0000004190', 1, 49152, 'P', 'BO', 'TJOWERS01', 'TEST ITEM', 'C', 'Do not use or inventory. Testing purposes only', 'TJOWERS01', 'EACH', 99.00000, 0.00000, 99.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, '1900.01.01', '00:00:00', '1900.01.01', '00:00:00', '', '', '', 0.00000, 0, '', 0, 100.00000, 100.00000, 100.00000, '1900.01.01', '', 0.00000, 0, '', 0.00000, 0, 0, 0, 'CPEC', 2, '', 0, '', 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, '', 0, '', 0, 0.00000, @num OUT SELECT @num END 
>
>...
>BEGIN DECLARE @stored_proc_name char(38) DECLARE @retstat int DECLARE @param7 int DECLARE @param8 char(11) set nocount on SELECT @param7 = 0 SELECT @param8 = 'TJOWERS01' SELECT @stored_proc_name = 'CPEC.dbo.SVC_Get_ServiceDistLocAccount' EXEC @retstat = @stored_proc_name 2, '0000004190', 1, 49152, 'P', 5, @param7 OUT, @param8 OUT SELECT @retstat, @param7, @param8 set nocount on END 
>...
>
>BEGIN DECLARE @stored_proc_name char(38) DECLARE @retstat int set nocount on SELECT @stored_proc_name = 'CPEC.dbo.SVC_Create_Srv_Audit_UserDate' EXEC @retstat = @stored_proc_name '0000004190', 2, 'BO', 'tjowers', 'Part Record Added/Updated', '2013.06.27' SELECT @retstat set nocount on END 
>
>SELECT COUNT(SRVRECTYPE) FROM CPEC.dbo.SVC00203 WHERE SRVRECTYPE = 2 AND CALLNBR >= '0000004190' AND CALLNBR <= '0000004190' AND EQPLINE = 1 AND LINITMTYP >= 'P' AND LINITMTYP <= 'P'
>
>SELECT COUNT(SRVRECTYPE) FROM CPEC.dbo.SVC00203 WHERE SRVRECTYPE = 2 AND CALLNBR = '0000004190' AND EQPLINE = 1 AND LINITMTYP = 'L' AND CMPNTSEQ = 0 
>SELECT COUNT(SRVRECTYPE) FROM CPEC.dbo.SVC00203 WHERE SRVRECTYPE = 2 AND CALLNBR = '0000004190' AND EQPLINE = 1 AND LINITMTYP = 'A' AND CMPNTSEQ = 0 
>SELECT COUNT(SRVRECTYPE) FROM CPEC.dbo.SVC00203 WHERE SRVRECTYPE = 2 AND CALLNBR = '0000004190' AND EQPLINE = 1 AND LINITMTYP = 'E' AND CMPNTSEQ = 0 
>

Actions: View

Attachments on bug 66765: 82267 | 82306 | 82307 | 150863