Me again!

When I run the entire script I get:

UV 142.0 0.0

UVN ...

That's what the query above should do for you (not in to a table mind you, but it's an easy adjustment to make)

I can't see your required XML output. Can you edit your post to make it visible using the IFCode if you can.... You may need to replace < symbols with...

Hi,

I'm sorry, I'm a bit fuzzy on what you're asking for; you've asked for the most recent record only from table1 but you've then gone on to explain having two...

Hi,

I think this should help....

DECLARE@xlsFile VARCHAR(255)

DECLARE@xlsSheet VARCHAR(255)

DECLARE@importServer VARCHAR(10)

DECLARE@importDatabase VARCHAR(50)

DECLARE@importTable VARCHAR(50)

DECLARE @rc INT

DECLARE @adodbObject INT

DECLARE @connString VARCHAR(1000)

DECLARE @sqlString NVARCHAR(2000)

DECLARE @dummyOut INT

-- Connection Settings

SELECT @xlsFile = 'c:\myfile'

,@xlsSheet = 'mySheetName$'

,@importServer = 'myServer'

,@importDatabase...

Hi,

Is this the sort of thing that you're trying to achieve?

DECLARE @table TABLE (raw_payload VARCHAR(200))

INSERT INTO @table VALUES('UV+ 142.0000+ 0.0000')

INSERT INTO @table VALUES('UVN+ 524.0000+ 0.0000')

INSERT INTO @table VALUES('UVN+ 525.0000+ 0.0000')

INSERT...

I'm...

I think the main things to consider is the regular monthly payments that you have to make; i.e. mortgage/rent, utility bills etc.

I've always seen two upsides to contracting. The...

Hi,

Why not DTS or SSIS as this is one of the reasons that these facilities exist?? :crazy:

Also, we'd need much more information on what you are starting with (in terms...

{ Just realised that this was cross-posted - don't do that!!}

😀

Answer moved to new thread that was created here:

http://www.sqlservercentral.com/Forums/Topic487837-19-1.aspx

Mindy,

Hi, let's see if I can talk you through this....

Start a new DTS package.

Drag an Excel Connection in to the design space.

Configure the connection to point at your Excel file.

Drag...

Have you tried using these switches? \t for tab field terminator and \n for new line row terminator.

-t"\t" -r"\n"

HTH

Curd? Just don't goat there.

ROTFL (Roule-ing on the floor laughing)

😛

Matt, we should really tread Caerphilly before me make a Roquefort our own backs.