Solved

Violation of PRIMARY KEY constraint

Posted on 2008-06-25
22
956 Views
Last Modified: 2012-08-14
I'm running the below script but receive a 'Violation of PRIMARY KEY constraint' error.

The primary key is SKU - CHAR(15)

Any suggestions?
insert into sku_master
select 
	SKU = convert(char(15),I.ITEMNMBR),
	Class = '01',
	Env_Code = ' ',
	Storage_Velocity_Code = ' ',
	CC_Velocity_Code = ' ',
	Description1 = convert(char(50),I.ITEMDESC),
	Description2 = ' ',
	Unit_Desc = ' ',
	Bulk_Desc = ' ',
	Bulk_Qty = 0,
	Bulk_Pick_Flag = 'N',
	Bulk_Loc_Type = ' ',
	Unit_Loc_Type = ' ',
	Length = 0,
	Width = 0,
	Height = 0,
	Cube = 0,
	Weight = convert(float,I.ITEMSHWT),
	Serial_Track = 'N',
	Lot_Track = 'N',
	Exp_Date_Track = 'N',
	Mfg_Date_Track = 'N',
	High_Qty = 0,
	Tie_Qty = 0,
	Preemptive_Putaway_Flag = 'N',
	Shippable_Unit = 'N',
	Cost = convert(float,I.CURRCOST),
	Substitute_SKU = convert(char(15),I.ALTITEM1),
	New_SKU = 'N',
	Age_Control = 'N',
	Rule_ID = 'DEFLT',
	Preferred_Zone = ' ',
	PickGen_Rule = 'RULE1',
	Update_Date = getdate(),
	Update_User_ID = 'INIT',
	Update_PID = 'DTS'
	from GP9TST.KELEG.dbo.IV00101 I
	JOIN GP9TST.KELEG.dbo.IV00102 N on I.ITEMNMBR = N.ITEMNMBR where convert(char(15),I.ITEMNMBR) not in (
	select SKU from sku_master) and N.LOCNCODE = 'MEMPHIS'

Open in new window

0
Comment
Question by:jdr0606
  • 13
  • 9
22 Comments
 
LVL 7

Expert Comment

by:60MXG
ID: 21867879
I believed that the query written here

select
      distinct(SKU = convert(char(15),I.ITEMNMBR)),  --- Added distinct here
      Class = '01',
      Env_Code = ' ',
      Storage_Velocity_Code = ' ',
      CC_Velocity_Code = ' ',
      Description1 = convert(char(50),I.ITEMDESC),
      Description2 = ' ',
      Unit_Desc = ' ',
      Bulk_Desc = ' ',
      Bulk_Qty = 0,
      Bulk_Pick_Flag = 'N',
      Bulk_Loc_Type = ' ',
      Unit_Loc_Type = ' ',
      Length = 0,
      Width = 0,
      Height = 0,
      Cube = 0,
      Weight = convert(float,I.ITEMSHWT),
      Serial_Track = 'N',
      Lot_Track = 'N',
      Exp_Date_Track = 'N',
      Mfg_Date_Track = 'N',
      High_Qty = 0,
      Tie_Qty = 0,
      Preemptive_Putaway_Flag = 'N',
      Shippable_Unit = 'N',
      Cost = convert(float,I.CURRCOST),
      Substitute_SKU = convert(char(15),I.ALTITEM1),
      New_SKU = 'N',
      Age_Control = 'N',
      Rule_ID = 'DEFLT',
      Preferred_Zone = ' ',
      PickGen_Rule = 'RULE1',
      Update_Date = getdate(),
      Update_User_ID = 'INIT',
      Update_PID = 'DTS'
      from GP9TST.KELEG.dbo.IV00101 I
      JOIN GP9TST.KELEG.dbo.IV00102 N on I.ITEMNMBR = N.ITEMNMBR where convert(char(15),I.ITEMNMBR) not in (
      select SKU from sku_master) and N.LOCNCODE = 'MEMPHIS'
 

----has duplicated primary key so the sku_master table is rejecting it.  You might want to change the query like this

select
      SKU = convert(char(15),I.ITEMNMBR),
      Class = '01',
      Env_Code = ' ',
      Storage_Velocity_Code = ' ',
      CC_Velocity_Code = ' ',
      Description1 = convert(char(50),I.ITEMDESC),
      Description2 = ' ',
      Unit_Desc = ' ',
      Bulk_Desc = ' ',
      Bulk_Qty = 0,
      Bulk_Pick_Flag = 'N',
      Bulk_Loc_Type = ' ',
      Unit_Loc_Type = ' ',
      Length = 0,
      Width = 0,
      Height = 0,
      Cube = 0,
      Weight = convert(float,I.ITEMSHWT),
      Serial_Track = 'N',
      Lot_Track = 'N',
      Exp_Date_Track = 'N',
      Mfg_Date_Track = 'N',
      High_Qty = 0,
      Tie_Qty = 0,
      Preemptive_Putaway_Flag = 'N',
      Shippable_Unit = 'N',
      Cost = convert(float,I.CURRCOST),
      Substitute_SKU = convert(char(15),I.ALTITEM1),
      New_SKU = 'N',
      Age_Control = 'N',
      Rule_ID = 'DEFLT',
      Preferred_Zone = ' ',
      PickGen_Rule = 'RULE1',
      Update_Date = getdate(),
      Update_User_ID = 'INIT',
      Update_PID = 'DTS'
      from GP9TST.KELEG.dbo.IV00101 I
      JOIN GP9TST.KELEG.dbo.IV00102 N on I.ITEMNMBR = N.ITEMNMBR where convert(char(15),I.ITEMNMBR) not in (
      select SKU from sku_master) and N.LOCNCODE = 'MEMPHIS'
0
 

Author Comment

by:jdr0606
ID: 21867975
Unfortunately, I still received a Primary Key violation error using the modified script.
0
 
LVL 7

Expert Comment

by:60MXG
ID: 21867995
Exam this script

select
      SKU = convert(char(15),I.ITEMNMBR),
      Class = '01',
      Env_Code = ' ',
      Storage_Velocity_Code = ' ',
      CC_Velocity_Code = ' ',
      Description1 = convert(char(50),I.ITEMDESC),
      Description2 = ' ',
      Unit_Desc = ' ',
      Bulk_Desc = ' ',
      Bulk_Qty = 0,
      Bulk_Pick_Flag = 'N',
      Bulk_Loc_Type = ' ',
      Unit_Loc_Type = ' ',
      Length = 0,
      Width = 0,
      Height = 0,
      Cube = 0,
      Weight = convert(float,I.ITEMSHWT),
      Serial_Track = 'N',
      Lot_Track = 'N',
      Exp_Date_Track = 'N',
      Mfg_Date_Track = 'N',
      High_Qty = 0,
      Tie_Qty = 0,
      Preemptive_Putaway_Flag = 'N',
      Shippable_Unit = 'N',
      Cost = convert(float,I.CURRCOST),
      Substitute_SKU = convert(char(15),I.ALTITEM1),
      New_SKU = 'N',
      Age_Control = 'N',
      Rule_ID = 'DEFLT',
      Preferred_Zone = ' ',
      PickGen_Rule = 'RULE1',
      Update_Date = getdate(),
      Update_User_ID = 'INIT',
      Update_PID = 'DTS'
      from GP9TST.KELEG.dbo.IV00101 I
      JOIN GP9TST.KELEG.dbo.IV00102 N on I.ITEMNMBR = N.ITEMNMBR where convert(char(15),I.ITEMNMBR) not in (
      select SKU from sku_master) and N.LOCNCODE = 'MEMPHIS'
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 7

Expert Comment

by:60MXG
ID: 21868053
Can you give me the sku_master table structure.  Something like this

sku_master_id                  [int]    PrimaryKey,
sku_master_desc              varchar(100)
0
 
LVL 7

Expert Comment

by:60MXG
ID: 21868200
also try to change your datatype from char to varchar unless all the data are fix length.  
0
 

Author Comment

by:jdr0606
ID: 21868291
Does this code snippet help?


CREATE TABLE [dbo].[SKU_Master](
	[SKU] [dbo].[SKU] NOT NULL,
	[Class] [dbo].[Class] NOT NULL,
	[Env_Code] [dbo].[Env_Code] NOT NULL,
	[Storage_Velocity_Code] [dbo].[Velocity_Code] NOT NULL,
	[CC_Velocity_Code] [dbo].[Velocity_Code] NOT NULL,
	[Description1] [dbo].[SKU_Desc] NOT NULL,
	[Description2] [dbo].[SKU_Desc] NOT NULL,
	[Unit_Desc] [dbo].[UoM] NOT NULL,
	[Bulk_Desc] [dbo].[UoM] NOT NULL,
	[Bulk_Qty] [dbo].[Qty] NOT NULL,
	[Bulk_Pick_Flag] [dbo].[Boolean] NOT NULL,
	[Bulk_Loc_Type] [dbo].[Loc_Type] NOT NULL,
	[Unit_Loc_Type] [dbo].[Loc_Type] NOT NULL,
	[Length] [dbo].[Dimension] NOT NULL,
	[Width] [dbo].[Dimension] NOT NULL,
	[Height] [dbo].[Dimension] NOT NULL,
	[Cube] [dbo].[Dimension] NOT NULL,
	[Weight] [dbo].[Dimension] NOT NULL,
	[Serial_Track] [dbo].[Boolean] NOT NULL,
	[Lot_Track] [dbo].[Boolean] NOT NULL,
	[Exp_Date_Track] [dbo].[Boolean] NOT NULL,
	[Mfg_Date_Track] [dbo].[Boolean] NOT NULL,
	[High_Qty] [dbo].[Qty] NOT NULL,
	[Tie_Qty] [dbo].[Qty] NOT NULL,
	[Preemptive_Putaway_Flag] [dbo].[Boolean] NOT NULL,
	[Shippable_Unit] [dbo].[Boolean] NOT NULL,
	[Cost] [float] NOT NULL,
	[Substitute_SKU] [dbo].[SKU] NOT NULL,
	[New_SKU] [dbo].[Boolean] NOT NULL,
	[Age_Control] [dbo].[Boolean] NOT NULL,
	[Rule_ID] [dbo].[Small_ID_String] NOT NULL,
	[Preferred_Zone] [dbo].[Zone] NOT NULL,
	[PickGen_Rule] [dbo].[Small_ID_String] NOT NULL,
	[Update_Date] [datetime] NOT NULL,
	[Update_User_ID] [dbo].[User_ID] NOT NULL,
	[Update_PID] [dbo].[PID] NULL,
 CONSTRAINT [PK_SKU_Master_1__12] PRIMARY KEY CLUSTERED 
(
	[SKU] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

Open in new window

0
 
LVL 7

Expert Comment

by:60MXG
ID: 21868366
Try to remove the Primary Key on the SKU column in your SKU_Master table if you just want to import the data.  Your datasource has duplicated Sku I believed so exam the output of your select statement.

select
      distinct(SKU = convert(varchar(15),I.ITEMNMBR)),       --- added distinct and change datatype
      Class = '01',
      Env_Code = ' ',
      Storage_Velocity_Code = ' ',
      CC_Velocity_Code = ' ',
      Description1 = convert(varchar(50),I.ITEMDESC),            -- change datatype
      Description2 = ' ',
      Unit_Desc = ' ',
      Bulk_Desc = ' ',
      Bulk_Qty = 0,
      Bulk_Pick_Flag = 'N',
      Bulk_Loc_Type = ' ',
      Unit_Loc_Type = ' ',
      Length = 0,
      Width = 0,
      Height = 0,
      Cube = 0,
      Weight = convert(float,I.ITEMSHWT),
      Serial_Track = 'N',
      Lot_Track = 'N',
      Exp_Date_Track = 'N',
      Mfg_Date_Track = 'N',
      High_Qty = 0,
      Tie_Qty = 0,
      Preemptive_Putaway_Flag = 'N',
      Shippable_Unit = 'N',
      Cost = convert(float,I.CURRCOST),
      Substitute_SKU = convert(varchar(15),I.ALTITEM1),            --- change data type
      New_SKU = 'N',
      Age_Control = 'N',
      Rule_ID = 'DEFLT',
      Preferred_Zone = ' ',
      PickGen_Rule = 'RULE1',
      Update_Date = getdate(),
      Update_User_ID = 'INIT',
      Update_PID = 'DTS'
      from GP9TST.KELEG.dbo.IV00101 I
      JOIN GP9TST.KELEG.dbo.IV00102 N on I.ITEMNMBR = N.ITEMNMBR where convert(char(15),I.ITEMNM
0
 

Author Comment

by:jdr0606
ID: 21868395
It cutoff the last line or two, was there any changes on them?

Thanks
0
 
LVL 7

Expert Comment

by:60MXG
ID: 21868396
I think I find it

select
      distinct(SKU = convert(varchar(15),I.ITEMNMBR)),   ---added
      Class = '01',
      Env_Code = ' ',
      Storage_Velocity_Code = ' ',
      CC_Velocity_Code = ' ',
      Description1 = convert(varchar(50),I.ITEMDESC),
      Description2 = ' ',
      Unit_Desc = ' ',
      Bulk_Desc = ' ',
      Bulk_Qty = 0,
      Bulk_Pick_Flag = 'N',
      Bulk_Loc_Type = ' ',
      Unit_Loc_Type = ' ',
      Length = 0,
      Width = 0,
      Height = 0,
      Cube = 0,
      Weight = convert(float,I.ITEMSHWT),
      Serial_Track = 'N',
      Lot_Track = 'N',
      Exp_Date_Track = 'N',
      Mfg_Date_Track = 'N',
      High_Qty = 0,
      Tie_Qty = 0,
      Preemptive_Putaway_Flag = 'N',
      Shippable_Unit = 'N',
      Cost = convert(float,I.CURRCOST),
      Substitute_SKU = convert(varchar(15),I.ALTITEM1),
      New_SKU = 'N',
      Age_Control = 'N',
      Rule_ID = 'DEFLT',
      Preferred_Zone = ' ',
      PickGen_Rule = 'RULE1',
      Update_Date = getdate(),
      Update_User_ID = 'INIT',
      Update_PID = 'DTS'
      from GP9TST.KELEG.dbo.IV00101 I
      JOIN GP9TST.KELEG.dbo.IV00102 N on I.ITEMNMBR = N.ITEMNMBR where convert(char(15),I.ITEMNMBR) not in (
      select distinct(SKU) from sku_master) and N.LOCNCODE = 'MEMPHIS'   ----added distinct
0
 
LVL 7

Expert Comment

by:60MXG
ID: 21868410
sorry I cut off the line when I copy and paste
0
 

Author Comment

by:jdr0606
ID: 21868428
Getting the following on the code

Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '='.
Msg 156, Level 15, State 1, Line 41
Incorrect syntax near the keyword 'and'.
0
 
LVL 7

Expert Comment

by:60MXG
ID: 21868444
select distinct(SKU = convert(varchar(15),I.ITEMNMBR)),   --this line of code could be wrong then try this

select (distinct(SKU) = convert(varchar(15),I.ITEMNMBR)),  
0
 
LVL 7

Expert Comment

by:60MXG
ID: 21868549
Get it to work?
0
 

Author Comment

by:jdr0606
ID: 21868566
Still getting syntax errors.

Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'select'.
Msg 156, Level 15, State 1, Line 40
Incorrect syntax near the keyword 'and'.

select 
      select (distinct(SKU) = convert(varchar(15),I.ITEMNMBR)),  
      Class = '01',
      Env_Code = ' ',
      Storage_Velocity_Code = ' ',
      CC_Velocity_Code = ' ',
      Description1 = convert(varchar(50),I.ITEMDESC),
      Description2 = ' ',
      Unit_Desc = ' ',
      Bulk_Desc = ' ',
      Bulk_Qty = 0,
      Bulk_Pick_Flag = 'N',
      Bulk_Loc_Type = ' ',
      Unit_Loc_Type = ' ',
      Length = 0,
      Width = 0,
      Height = 0,
      Cube = 0,
      Weight = convert(float,I.ITEMSHWT),
      Serial_Track = 'N',
      Lot_Track = 'N',
      Exp_Date_Track = 'N',
      Mfg_Date_Track = 'N',
      High_Qty = 0,
      Tie_Qty = 0,
      Preemptive_Putaway_Flag = 'N',
      Shippable_Unit = 'N',
      Cost = convert(float,I.CURRCOST),
      Substitute_SKU = convert(varchar(15),I.ALTITEM1),
      New_SKU = 'N',
      Age_Control = 'N',
      Rule_ID = 'DEFLT',
      Preferred_Zone = ' ',
      PickGen_Rule = 'RULE1',
      Update_Date = getdate(),
      Update_User_ID = 'INIT',
      Update_PID = 'DTS'
      from GP9TST.KELEG.dbo.IV00101 I
      JOIN GP9TST.KELEG.dbo.IV00102 N on I.ITEMNMBR = N.ITEMNMBR where convert(char(15),I.ITEMNMBR) not in (
      select distinct(SKU) from sku_master) and N.LOCNCODE = 'MEMPHIS'

Open in new window

0
 
LVL 7

Expert Comment

by:60MXG
ID: 21868710
select
      select (distinct(SKU)) = convert(varchar(15),I.ITEMNMBR),  
      Class = '01',
      Env_Code = ' ',
      Storage_Velocity_Code = ' ',
      CC_Velocity_Code = ' ',
      Description1 = convert(varchar(50),I.ITEMDESC),
      Description2 = ' ',
      Unit_Desc = ' ',
      Bulk_Desc = ' ',
      Bulk_Qty = 0,
      Bulk_Pick_Flag = 'N',
      Bulk_Loc_Type = ' ',
      Unit_Loc_Type = ' ',
      Length = 0,
      Width = 0,
      Height = 0,
      Cube = 0,
      Weight = convert(float,I.ITEMSHWT),
      Serial_Track = 'N',
      Lot_Track = 'N',
      Exp_Date_Track = 'N',
      Mfg_Date_Track = 'N',
      High_Qty = 0,
      Tie_Qty = 0,
      Preemptive_Putaway_Flag = 'N',
      Shippable_Unit = 'N',
      Cost = convert(float,I.CURRCOST),
      Substitute_SKU = convert(varchar(15),I.ALTITEM1),
      New_SKU = 'N',
      Age_Control = 'N',
      Rule_ID = 'DEFLT',
      Preferred_Zone = ' ',
      PickGen_Rule = 'RULE1',
      Update_Date = getdate(),
      Update_User_ID = 'INIT',
      Update_PID = 'DTS'
      from GP9TST.KELEG.dbo.IV00101 I
      JOIN GP9TST.KELEG.dbo.IV00102 N on I.ITEMNMBR = N.ITEMNMBR where convert(char(15),I.ITEMNMBR) not in (
      select distinct(SKU) from sku_master) and N.LOCNCODE = 'MEMPHIS'
0
 

Author Comment

by:jdr0606
ID: 21868795
What am I doing wrong?  I still get the below errors using your latest query syntax.

Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'select'.
Msg 156, Level 15, State 1, Line 40
Incorrect syntax near the keyword 'and'.
0
 
LVL 7

Expert Comment

by:60MXG
ID: 21868836
insert into sku_master
select
      SKU = convert(char(15),I.ITEMNMBR),
      Class = '01',
      Env_Code = ' ',
      Storage_Velocity_Code = ' ',
      CC_Velocity_Code = ' ',
      Description1 = convert(char(50),I.ITEMDESC),
      Description2 = ' ',
      Unit_Desc = ' ',
      Bulk_Desc = ' ',
      Bulk_Qty = 0,
      Bulk_Pick_Flag = 'N',
      Bulk_Loc_Type = ' ',
      Unit_Loc_Type = ' ',
      Length = 0,
      Width = 0,
      Height = 0,
      Cube = 0,
      Weight = convert(float,I.ITEMSHWT),
      Serial_Track = 'N',
      Lot_Track = 'N',
      Exp_Date_Track = 'N',
      Mfg_Date_Track = 'N',
      High_Qty = 0,
      Tie_Qty = 0,
      Preemptive_Putaway_Flag = 'N',
      Shippable_Unit = 'N',
      Cost = convert(float,I.CURRCOST),
      Substitute_SKU = convert(char(15),I.ALTITEM1),
      New_SKU = 'N',
      Age_Control = 'N',
      Rule_ID = 'DEFLT',
      Preferred_Zone = ' ',
      PickGen_Rule = 'RULE1',
      Update_Date = getdate(),
      Update_User_ID = 'INIT',
      Update_PID = 'DTS'
      from GP9TST.KELEG.dbo.IV00101 I
      JOIN GP9TST.KELEG.dbo.IV00102 N on I.ITEMNMBR = N.ITEMNMBR where convert(char(15),I.ITEMNMBR) not in (
      select distinct(SKU) from sku_master) and N.LOCNCODE = 'MEMPHIS'    -- added distinct
 
--- try your old query here
0
 

Author Comment

by:jdr0606
ID: 21869003
Ran the above and received the Primary key error again
0
 
LVL 7

Accepted Solution

by:
60MXG earned 500 total points
ID: 21869034
insert into sku_master
select
      SKU = distinct(convert(char(15),I.ITEMNMBR)),
      Class = '01',
      Env_Code = ' ',
      Storage_Velocity_Code = ' ',
      CC_Velocity_Code = ' ',
      Description1 = convert(char(50),I.ITEMDESC),
      Description2 = ' ',
      Unit_Desc = ' ',
      Bulk_Desc = ' ',
      Bulk_Qty = 0,
      Bulk_Pick_Flag = 'N',
      Bulk_Loc_Type = ' ',
      Unit_Loc_Type = ' ',
      Length = 0,
      Width = 0,
      Height = 0,
      Cube = 0,
      Weight = convert(float,I.ITEMSHWT),
      Serial_Track = 'N',
      Lot_Track = 'N',
      Exp_Date_Track = 'N',
      Mfg_Date_Track = 'N',
      High_Qty = 0,
      Tie_Qty = 0,
      Preemptive_Putaway_Flag = 'N',
      Shippable_Unit = 'N',
      Cost = convert(float,I.CURRCOST),
      Substitute_SKU = convert(char(15),I.ALTITEM1),
      New_SKU = 'N',
      Age_Control = 'N',
      Rule_ID = 'DEFLT',
      Preferred_Zone = ' ',
      PickGen_Rule = 'RULE1',
      Update_Date = getdate(),
      Update_User_ID = 'INIT',
      Update_PID = 'DTS'
      from GP9TST.KELEG.dbo.IV00101 I
      JOIN GP9TST.KELEG.dbo.IV00102 N on I.ITEMNMBR = N.ITEMNMBR where convert(char(15),I.ITEMNMBR) not in (
      select distinct(SKU) from sku_master) and N.LOCNCODE = 'MEMPHIS'  
0
 

Author Comment

by:jdr0606
ID: 21869175
Still generating error.

Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'distinct'.
Msg 156, Level 15, State 1, Line 41
Incorrect syntax near the keyword 'and'.
0
 

Author Closing Comment

by:jdr0606
ID: 31470664
It turns out that the test DB I was pointing to had an item number greater than 15 characters but when it was converted down to 15 characters ended up being a duplicate and created the primary key error.

Still dont' know why I kept getting the syntax errors but the real problem has been resolved.

Thanks again for your assistance!
0
 
LVL 7

Expert Comment

by:60MXG
ID: 21876111
use Varchar instead of Char.  I read some article about varchar and char.  Varchar is much better in term of performance and has less problem.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how the fundamental information of how to create a table.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question