How large is 'large'? Do you want to do this internally (ie, using your own network/Exchange infrastructure), or use a third party (which you might, if large really is LARGE)?

Try something like this:

DECLARE @a VARCHAR(20) = '010711'

SELECT @a,

'20' + RIGHT(@a, 2) + SUBSTRING(@a, 3, 2) + LEFT(@a, 2)

Jnrstevej (6/22/2011)

---

Hi

I'm trying to format the column(dueDate) which contains the date to a YYYYMMDD format

My understanding to achieve this would be

select convert(varchar,getdate(),112)

select CONVERT(date,duedate,112)

from test

--my attempt

select convert(varchar,duedate,112

from test

--Test table...

Nasty.

I've thought about the logic a little & this might work:

If @StartDay <= @EndDay then

where Day(Birthdate) Between @StartDay and @EndDay

else

where Day(Birthdate) Not Between @StartDay and...

Sachin4all (6/21/2011)

---

Insert into hs(Id, Date, time)

select utid,date,time

from time t

where transactiontime between ? and ?

I have created the varibles startdate and enddate as datetime

Sourcetype as directinput...

You continue to infer things...

I created your table, populated the data and then

SELECT * FROM dbo.Onhand o

- there is no right-alignment of anything.

How are you getting the data out of SQL Server and into...

No, I read your message correctly. What I disagree with is "...consider doing yourself a favor and omit the readability word...". Yes, it's only in there to make the written...

Jnrstevej (6/21/2011)

---

Thanks for your replies

To be honest i don't understand the script below, this returns 32 for me.

declare @name varchar(256)

set @name = ' 1231'

select ascii(SUBSTRING(@name , 1 , 1))

I...

aaa-322853 (6/21/2011)

---

Ok listen to this. If I set up a proxy account a link it to the SQL Server agent domain account it works?? Something is not quite right when...

Adding to that, trim removes spaces, so the characters to the left that you wish to remove must be something else. Step 1 is to find out what those characters...

Everything sounds fine.

Notwithstanding your comments, I think the next step should still be a check on permissions. Please try putting the file in

c:\import

(or wherever)

and see whether you still get the...

How are you passing the file names to the job? Is it hard-coded, or via some sort of config?

What is the full UNC path + file name?

Yeah right. You accidentally used the word 'dump' in both the title and text of your original post.

But glad you...