Thanks very much for the advice there guys,

Its great to have some people to bounce things off once in a while...

Much appreciated...

Vida.

Ok, so I;ve come up with a really simple way of doing this.. but would appreciate some critiques.. is it too simpple?

Table is like

CREATE TABLE [dbo].[Way4Files](

[ID] [bigint] IDENTITY(1,1) NOT...

Jeez Guys,

This is a much better response than I thought I'd get for this question. Thanks for taking the time.

I'm afraid that its as Ninja's_RGR'us said...

I'll have more than one...

Yep,

That was the problem in my experience.. it couldn't create the share cos the bloody thing already existed! (how bad a bit of programming is that?)

Once I deleted the share...

Well folks in Ireland anyway the demand for Java programmers far exceeds the demand for dotnet... especially where i am located.. in Galway.. on the west coast.

Majority of the jobs...

Ooops,

Found the answer in a post down below there in the forums...

I'd just have to do:

DECLARE @MyString varchar(1000)

SET @MyString = ''

SELECT @MyString = @MyString +...

The ONE and ONLY book for me was the Wrox Professional SQL Server 2000 by Patrick Vieira

http://www.amazon.com/gp/product/0764543792/sr=8-3/qid=1151053201/ref=sr_1_3/104-3644669-1203922?%5Fencoding=UTF8

... superb.. explains everything... great sections on UDF's and Stored Procedures..

You DO need...

TV Be GONE !!!

Brilliant idea.... ever sat in a pub where someone has left a TV on even tho nobody is watching it? Its sooo distracting when you are sitting and...

Hi guys,

yeah, ehh the reason I want to move the stored procs is we have a live version of the database out there... and we have had a guy working...

Our Foxpro guy has just told me to give hima csv now anyway.. sigh...

Something to do with the headers that the OLE foxpro driver generates wouldn't be compatible... think there...

Woo.. well spotted Shaun.. thank you!

vida

Yeah...

I was kinda hoping for a more automatic kinda result... the CSV file would need to be imported into FoxPro...

I've been digging around on the web sice I asked the question...

Oh NICE ONE Jonathan!

Thanks very much!

Vida

Oh wow guys ! This is great!

I'll go hoover up all I can find about SQL Mail so...

Thanks very much!

Vida