Hi,

Please visit this page to know the options available in Convert function

http://technet.microsoft.com/en-us/library/ms187928.aspx

SQL parses your script and finds that you are attempting to create it in two different places, and so raises an error, its better to create the table in the...

This query might help you

Create Table WHS_Details (ItemCode VarChar(20),

Quantity numeric(19, 6),

Price numeric(19, 6),

DocType VarChar(10),

DocNum VarChar(12),

DocDate Date ,

TransID Int)

Insert into WHS_Details values ('IT001',10,100,'PURCHASE',210000033,'2013-09-11',85)

Insert into WHS_Details values ('IT002',10,1000,'PURCHASE',210000033,'2013-09-11',85)

Insert into WHS_Details values ('IT001',6,200,'SALES',110000019,'2013-09-12',86)

Insert...

Nice Question :w00t:

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best

practices on asking questions.

What are you expecting?:w00t:

No Suggestions? :hehe:

.

No answer ? :crying:

Use Group clause

Here is the code, this might helps you

CREATE TABLE example (

holdId nvarchar(200),

Ugedag nvarchar(200),

Frakl nvarchar(200),

Tilkl nvarchar(200)

)

INSERT INTO example (holdId, Ugedag, Frakl, Tilkl) VALUES ('58f42ab', 'Mandag', '08:00', '16:30')

INSERT INTO example...

This link may helps you

http://msdn.microsoft.com/en-us/library/ms173773.aspx