Unfortunately, there is no easy way of getting SQL to FORMAT like EXCEL.  What you probably could do is take your code above and build it into a function that...

Is it possible for you to ADD an IDENTITY field or some variant thereof that would allow the following type syntax?

SELECT field1, field2, field3

  FROM dbo.table1

WHERE table1ID BETWEEN 1 AND 30

Then...

This is from my PC

name                                minimum     maximum     config_value run_value  

----------------------------------- ----------- ----------- ------------ -----------

max text repl size (B)              0           2147483647  65536        65536

This is from my Dev server

name                                minimum     maximum    ...

I would avoid trying to use the "SET identity ON add a record SET identity OFF"

This will cause duplicate records to get entered/records inserted out of order.

I know from personal...

that my friend could get very ugly.  You would need to build multiple variables and parse the text field .....  Please dont ask me how to do that.  I have...

Sounds like you will have to build a temp table that will be populated by the 1st row with whatever criteria is used to pull the data for the 1st...

Have you tried converting the ReadText to be like the following?

CAST(ReadText AS VARCHAR(8000)) or CONVERT(VARCHAR(8000), ReadText)

You can also add that to the WHERE or wherever else you reference the TEXT...

To my knowledge you can't (or rather shouldn't).  You can easily do this through EM and for the more adventurous via registry hacking (not recommended for ANYONE but an option...

Unfortunately,

I really dont know

AH!  Now it becomes clear.  I downloaded the SQL Server 2005 BETA I think you have the client reference edition only.

Sorry to confuse you,

I downloaded from MSDN.one.microsoft.com but you have to be a subscriber.  I don't know where else to get it

Are you sure you dont have

"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe"

???

I create a variable called PilotRun in the DTS package properties and set it via command line run (we use a host scheduler and have to use DTSRun).  Here is...

I tried to find something in BOL aqnd couldn't.  I always use a variable because I never thought out a function....

It is the SQL Server Management Suite (Profiler, EM, QA) and Business Intelligence (??) for DTS Packages

Not very complicated but hopefully will help you:

SELECT *

  FROM pubs.dbo.authors            AU

    LEFT JOIN pubs.dbo.titleauthor TA

      ON AU.au_id = CASE WHEN ISNULL(TA.au_id, '') = ''  THEN NULL ELSE...