Error

[renee35]

Could someone please tell me what I am doing wrong in the below create table statment:

create table #commissions (employeeid int, woid int,
worid int, custid int, custcode char(20), custname varchar (255), Effdate(datetime), WeekEnd(datetime))

To generate this error:

The definition for column 'Effdate' must include a data type.

Thanks a million

Thanks a bunch!!

-T

 

[RiverGuy]

Take off the parentheses around the word "datetime

 

[JohnDTampaBay]

No need for parens around the datetime datatype.

create table #commissions (
   employeeid int, woid int, worid int, custid int,
   custcode char(20), custname varchar (255),
   Effdate datetime , WeekEnd datetime )

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[renee35]

Thank you soo much RiverGuy!! You have no idea how much your responses and answers have said me soo much time. It's always the small things that we tend to overlook after working on something.

Have a wonderful day!!

Thanks a bunch!!

-T