Hi,

The latter, the display format of a datetime is as shown.

The column is of Varchar(24) data type.

When I insert the lines you have provided I get the error:

Msg 102,...

Either would be fine

First, why is a date being stored in a varchar912) column instead of a datetime column? Second, you show how the date is displayed, but is that how it...

OK, thanks.

I used the following:

SELECT CONVERT( datetime, [bgn date], 103 ) as date

from date

Two things

1. I want to select the rest of the columns in the table too.

2. I need...

Fantastic, worked fine.

I have attached the XML DATA FILE (CSV).

The final CSV will be updated manually every day.

After the update I was to convert it to the XML file.

Thanks

Any suggestions?

Thanks guys, Erik Kutzler idea works for me!

Thanks Guys,

But im not sure what you mean by:

"Add the XML header info to the top of the varchar string"

Can I have an example please?

regards,

Basically I I have the following data in a SQL2005 DB:

Job ...

Sorry about the formatting of my last post.

I have run the code above and this does create the following:

SoftCom

Site Manager

...

Table:

USE [UK_DBA_Test]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[ContactTable](

[Date] [char](11) NULL,

[Job] [varchar](100) NULL,

[Telephone] [varchar](100) NULL,

[Company] [nvarchar](255) NULL,

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

Results:

2009-01-01 Site Manager 0208 7845111 ...

Right, I lost you after the first stage...

Like I said Iv never done this before and iv only used SSIS a number of time, hense I was asking for a...

Is this the only way it can be done?

ok so i answered it my self:

Select email_address

= (client_email + '@' +Client_email_domain) FROM client_contact

where Client_email_domain NOT like '%gmail%'