Question:
I was trying to create a visual chart showing an exponential formula that expanded very widely. I ran out of columns at IV (approximately just over 200 columns). Wondering if there’s a way to expand the number of columns allowed?
Solution:
Hello CanadianJeff,
Excel 2007 supports more than 256 columns, but you have to make sure you’re not [...]
Question:
To begin, I run a business and this concerns my inventory…
I have two columns in MS Excel.
“Column A” has 73,764 cells
“Column B” has 73,864 cells
It’s a 100 cell difference between the two. Simple, right? Well, “Column B” not only has 100 more cells been added to the column–but 100 other cells have been DELETED in [...]
Question:
Hello experts, I need assistance in querying a mySQL database.
I have two tables in this database-
tableA – last / first / dob / pid1 / pid2 / sid1
tableB – sid1
all fields are varchar type, and there could be trailing spaces in sid1, I dont know if that would trigger any issues when trying to match.
tableA [...]
Question:
I’m selecting data from two different places — inbound and outbound shipments from a warehouse.
SELECT WorkDate, ProdCodeInbound, QtyReceived, ‘ ‘ AS ProdCodeOutbound, 0 AS QtyShipped
FROM g_InboundProdCodeByDate
UNION
SELECT WorkDate, ‘ ‘, 0, ProdCodeOutbound, QtyShipped
FROM g_OutboundProdCodeByDate
is working ok. Except that I get one row for the ProdCodeInbound and a separate row for the ProdCodeOutbound. Example below:
1/2/07 ProdA 5 [...]
Question:
I have a spreadsheet that when run through an ASP page is adding records even after the last bit of data shows up on the spreadsheet–which makes me assume there’s some other information still in there. Is there a way to ensure that all data is gone after my last row besides selecting several thousands [...]
Question:
How do i add a custom column to the windows explorer details view (Windows XP Pro).
Specifically I would like to add a height and a width column to .gif and .jpg files. I realize that there is the Dimension column that gives both height and width but i am looking for them to [...]
Question:
Hi,
I was trying to write a sql to display the columns of a row as attribute/value pair
say I have a table with NAME as primary key column
Columns -> NAME AGE HEIGHT WEIGHT
Data -> PETER 21 6.1 190
Looking to write sql to get data like this.
NAME COLUMN VALUE
——- ———- ——-
PETER AGE 21
PETER HEIGHT 6.1
PETER WEIGHT 190
Appreciate [...]
Question:
Is there any other ways I can view the columns of a particular table without using DESC tablename?
Solution:
A couple of things may be the problem. One, you need to make the owner and table_name uppercase (where owner = ‘RA’ and table_name = ‘ROUTINE_ITEM’). Two, use of all_tab_columns, will only provide you with info if you [...]
Question:
I asked this question a few weeks back and got a good answer on how to find exact matches between two columns in two seperate sheets: =VLOOKUP(“*A1″,parts,1,FALSE)<>”#N/A”. What I need to do now is find matches that are similar. The data that I am using is part numbers. In the first column I have [...]
Question:
MS SQL Server 2000.
At the bottom of this post, you’ll see an example test table that I have sorted by monthRated, then by AVGVotes, then by rateCount that contains a list of numbers in each of the respective three columns; monthRated, AVGVotes, and rateCount. I want to be able to group each row by [...]