>>

Thank you for your help. It is not a big deal for me either, is just that I want to group the columns together according to its content, as you said...

To be honest, Kim, I have no idea whether the mistakes are yours or the book's.  I don't have the book (or any other book on this subject, FWIW!). 

But...

Kim -- this is my third attempt to post an answer in this thread. Excuse me for being brief this time <g>.

The individuals on the thread were telling you to...

Hi there,

On #3, don't get too fussed about the "call and parameters go in the body".  This is true of some SOAP messaging styles and not others.  The important thing...

From http://www.chriskempster.com/tipsandhints.html

>>

(this post may appear twice)

I did a little experimenting and, if I set up a scratch database with a collation of SQL_Latin1_General_Cp1_CI_AS, I don't see the difference.  I'm pretty sure...

This might have something to do with our base collations.  Mine is Latin1_General_CS_AI. What's yours?

>L<

It's probably not a bug, rather a collation issue.  That's why some people can see it and others can't (I can).  Try this (including the people who couldn't repro with...

Here you go.  As the first person who recommended this script uses the second method (from page 2 of the article), that is the method I have revised below.  Search for...

> The problem can't be permissions because i'm running the program as an administrator

That's true.  I thought you were running the task in the Task Scheduler, however, not by double-clicking...

Try executing the script from the command line or double click in Windows rather than the Task Manager.  If it works then, you have a permissions problem.  Check to see...

You're probably better off maintaining the second license if you go ahead with your strategy of having the secondary work for multiple primaries.  It might be in use frequently, albeit...

If it's available, you might also try consuming this data via Excel, which will "understand" this text file as a comma-separated, quotation-mark-field-delimited file, like this:

DECLARE @SheetFileName VARCHAR(100), 

            @SheetX VARCHAR(150),

            @Err Int

SET...

You got the error from Paul's statement because he typed "%" rather than '%' (double quotes rather than single).  Whether this is going to work or not (I think) depends...

If you're doing the conversion to Julian date in VB code, look here:

http://www.novicksoftware.com/UDFofWeek/Vol2/T-SQL-UDF-Vol-2-Num-2-udf_DT_ToJulian.htm

...as you'll see there, your definition of Julian Date fits only one definition of Julian.  All such...