Results 1 to 5 of 5
Thread: SQL - Adding a blank column
08-22-2007, 03:39 PM #1
SQL - Adding a blank column
Just a cosmetic question.
Is there a way in SQL to add a blank column? Using Operational Reporting, I get a text email with two columns, but they're very close together.
My command is:
select node_name, sum(physical_mb) as TOTAL_MB from occupancy group by node_name order by 2 desc
Running from TSM command line the spacing is fine, but in the text email the columns are close.
08-22-2007, 04:13 PM #2
- Join Date
- Sep 2002
- Thanked 4 Times in 4 Posts
Add underscores to the column header "Total_MB" "__Total_MB__"
This will force TSM to use a wider column size.
-AaronThree things are certain:
Death, taxes, and lost data.
Guess which has occurred.
08-23-2007, 10:03 AM #3
That expanded the header, but since the column is left-justified it didn't separate any differently. Is there a way to set that column to right-justify?
12-06-2007, 09:50 AM #4
- Join Date
- Nov 2005
- Victoria, Australia
- Thanked 1 Time in 1 Post
12-07-2007, 12:25 PM #5
SELECT n.node_name||'<insert spaces>' as NODE, n.platform_name as PLATFORM FROM nodes n.....
By kfiresmith in forum Tape / Media LibraryReplies: 8Last Post: 09-24-2007, 02:04 PM
By Nicola in forum ScriptingReplies: 2Last Post: 07-17-2007, 10:25 PM
By Stephan in forum ScriptingReplies: 0Last Post: 01-17-2007, 01:24 PM
By stenbs in forum ScriptingReplies: 0Last Post: 09-17-2004, 01:58 PM
By bheisser in forum Backup / Archive DiscussionReplies: 1Last Post: 08-18-2004, 11:48 AM