Try this picture !

hi

I have done this a number of times.

What i tend to do is wrap it in a stored proc that uses XP_CMDSHELL

I then call the stored procedure from ASP and...

Cheers DSP

Works like a charm...you have no idea how long I have spent on that!!!

wouldn't it be nice if it was called the same as on the screen!

cheers m8

Ross

hi darrell

have been through these with no luck to date

can easily change the standard properties, what i need is a way to change the path to the UDL

thanks anyway

Ross

yes, that would work too, and a little more elegant !

Hi, try this.  Allows padding of any character to any length

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

create function padstring(@thestring varchar(50),@finlength int,@padchar char(1))

returns varchar(50)

as

begin

if len(rtrim(@thestring))<@finlength

 begin

  while len(rtrim(@thestring))<@finlength

  begin

   set @thestring=@padchar+@thestring

  end

        end

return @thestring

end

GO

SET QUOTED_IDENTIFIER...

Hi there

A simple solution would appear to be to write a UDF capable of creating your required output and then include this in your select from your table

eg. select name,...

If I am understanding what you mean....

It is possible to use workflow to activate one task 'on completion', 'on success' etc of a previous task.

This is done by selecting start...

My concern, like the other posters, would be how you handle database changes.

Performance gains are clearly evident via caching, but with a system with many users - certainly in our...