Hi,

I do not have the . before the bak sorry, that was just to explain what type of file they were. I have encountered that problem before and learnt from...

You're welcome. Let me know how you get on.

I'm no expert but I use this code and it works, if you're just dumping into one field to get it into the db

USE Databasename

DECLARE

@FilePath VARCHAR(1000) = 'c:\Transfer\' ,

@ArchivePathVARCHAR(1000) =...

This works perfectly. Thank you very much 🙂

If anyone could help I'm now trying a CTE, but getting a similar error as when I tried the derived table, I assume it's something simple, I just don't have...

Thanks for the advice, I have tried implementing a merge statement, but as John previously said I need my Select statements in a derived table, which I still cannot work...

I have tried to create what I think is a derived table, but I'm still getting errors. If anyone can see what is wrong with it, that'd be great.

USE...

Oh okay, thanks for clarifying that for me. I have no idea how to do that but I'll research and try.

Thanks for replying.

It doesn't seem to like so1.[Date&TimeOfReading] now.

Msg 207, Level 16, State 1, Line 148

Invalid column name 'Date&TimeOfReading'.

Msg 207, Level 16, State 1, Line 145

Invalid column name 'Date&TimeOfReading'.

And I...

Thanks, I'm trying this out.

USE SVA_FLOWS

IF OBJECT_ID('tempdb..#splitoutdata','U') IS NOT NULL DROP TABLE #SPLITOUTDATA;

CREATE TABLE #SPLITOUTDATA (

INDEX1 INT,

ROWNUM INT,

BITOFDATA VARCHAR(max));

IF OBJECT_ID(N'dbo.Split_XML', N'TF') IS NOT NULL DROP FUNCTION dbo.Split_XML

GO

SET QUOTED_IDENTIFIER ON

SET ANSI_NULLS...

Sorry, yes my fault, I've fixed it now!

Thanks for the help with the Date/Time thing, very handy.

If you/anyone else could help me with the WHERE on the INSERT INTO...

OK great that works, thanks.

I'm now getting error below when I include the INSERT INTO statement

Msg 213, Level 16, State 1, Line 28

Column name or number of supplied values does...

Thanks.. I'm just trying this now, but struggling to find where this fits in with my code and which bits of mine to take out! I'll play around with it.

USE [test]

GO

/****** Object: Table [dbo].[d0003] Script Date: 19/12/2012 10:36:18 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[d0003](

[Date&TimeOfReading] [varchar](max) NULL,

[MPAN] [varchar](max) NULL,

[P1] [varchar](max) NULL,

[P2] [varchar](max) NULL,

[P3]...

OK.. But this is quite long winded.

USE [SVA_FLOWS]

GO

/****** Object: Table [dbo].[RUG_CLOB] Script Date: 19/12/2012 10:24:56 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[RUG_CLOB](

[INDEX1] [varchar](50) NULL,

[DATA]...