Search results for query: *

Hi All, I have an excel 2007 pivot with three levels of Column labels. I am trying to get the upper most layer of column label to break down its total by the 3rd layer level. My comma-delimted data is below. In my pivot, my row label is Employee, my column labels are Data Type, Measurement...

Hi SQL Experts, We have a situation where we have a sales order table with a Sales Order say number 000999 which has attached to it a serial number 2345678. At some point in the life of the sales order, this serial number could change to a different number, e.g. 7891011, because the...

Hi, It's been years since Brio... and now I'm at a new job using Hyperion Interactive and I'm having trouble with formatting. I'm putting two tables in the body of my report, along with a text label at the bottom. It runs fine and looks great, but then when I run the report again the...

Once again, it's been awhile since I used SQL, so I'm sorry. I did search the forum first but I haven't found exactly what I'm looking for. Here's a sample of my data in my CASH table: TransID EmpID Amount Date 3 7 45 4/11/2007 4 7 45 2/2/2007 5...

Hi All, I've been trying to write a 'record-matching' statement for our customer database. It is comparing the First Name, Middle Name and Last Name and scoring the potential matches. The first criteria is a match on the first three characters of the customer's last name. The SQL is below...

I'm trying to get data out of an OLD Sybase database on an NT server. My client doesn't have any of the old disks, so there is no ODBC driver. I tried installing the DataDirect Sybase drivers, but I'm out of my element. I don't understand how to set the Named Pipes, and I can't use Winsock...

I'm sort of new to SQL Server so forgive me. I've been asked to create a view that requires a table be linked 9 times to the same 'core' table. For example, the core table is tblCustomers, and the tblCodes is linked to 9 different fields in tblCustomers (gender, religion, ethnicity etc. all...