I knew I'd find the answer here.. Thanks..I didn't think to look at the convert statement

My requirements are this...

I'm writing a "simple" select statement that returns the date in this format yyymmdd so I have this

select convert(varchar,datepart(yyyy,duedate)) + convert(varchar,datepart(mm,duedate)) + convert(varchar,datepart(dd,duedate)) from ....

but with a...

Well,

I got the thing working in the Query Analyzer, but I'm getting an error in my Vbscript whne using the Wscript.Shell Object. I hope the Run command doesn't have...

Maybe I can load the file into a VBscript variable then use isql or osql to execute the stored procedure, passing the variable as the parameter?

Sounds like it should work...in...

Sounds like it should be simple.

Do you have an example of how this is done??

yup

the message I get is

The text, ntext, and image data types are invalid for local variables.

Ok, does the field HAVE to be a primary key to have a constraint on it?

Never mind, I wrote my own. Here's the code if you're interested, although it'd be interesting to know if there is such a function to do this automatically. The code...

This does it but it seems a bit extream??

select

case len(convert(varchar,datepart(mm,PartsDueBy)))

when 1 then '0' + convert(varchar,datepart(mm,PartsDueBy))

when 2 then convert(varchar,datepart(mm,PartsDueBy))

end

+ '/' +

case len(convert(varchar,datepart(dd,PartsDueBy)))

when 1 then...

NPeeters,

That too was on my mind, I'm actually selecting from a view and the table the view is refering is part of my morning dumps from another database (Progress) and...

NPeeters,

I was going to say never mind I found the problem..and it was exactually what you suggested!! Thanks for the reply anyway!

Petey20

sysadmin did it! Thanks

By excel Column headers, I mean the first row to contain the table column names.

Check the schedlgu.txt file which is the log file for the scheduler. See if it's a login issue. If it is and If you're running ASP .NET framework on this...

does this do it??

insert into srnntemp

SELECT srnntemp.*

FROM srnntemp where not exists

...