Search results for query: *

Hi Skip, Thanks so much for the thoughtful answer, so a star for you! Unfortunately, I have to maintain the pivot filtering they have set up for the user so I think I will have to end up putting the data in crosstab type query at its source. Thanks again though, Julie

OK, makes sense. The yellow highlights are the total breakout that I can't get. Non Revenue Hours Credited Non Revenue Hours Credited Sum FaceToFaceMeeting Phone call Review of Contract Total Total Current Period Prior Period Current Period Prior Period Current Period Prior Period...

HI Skip, I tried to type it out but it looks too messy. I hope the attachment will work. I am looking for the pivot on the tab called 'pivot i would like', specifically, I cannot get the yellow highlighted fields no matter what I seem to try with totals/subtotals on the tab 'pivot that I...

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...

Did the trick, thanks PHV! And yes, very slow -thanks sQLSister for the warning. :)

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...

JackVam's solution worked, though c1.empid was c.empid I think. Have a star. I didn't have a chance to try Nice95's, but thank you both!

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...

A star to George because I learned so much today. You are great! It turns out that Middle_Name is not indexed and so is causing a slow Bookmark Lookup on the immense main records table. (It turns out that cust_data is actually a view containing 9 tables) The only way I could have discovered...

Very interesting George. Thanks for the quick reply. The last_name field is indexed and I did some reading on non-sargable. Is the left(last_name,3) function going to continue to render it non-sargable since it uses a function? I won't be able to log on to the server until this afternoon to...

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...

Thanks for your help. So, I want all the records from tblCustomers, whether or not they have entries in the gender, religion, or ethnicity fields. *The field names are: tblCustomers.gender (might have a value of 1004 for example) tblCustomers.religion tblCustomers.ethnicity *Link to the...

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...

I really struggled with this, so I'll answer even though so late in the game for you. Maybe it will help someone else. Try making two vertical lines. One in the header and one in the detail. If you have a footer, you'll have to put a third there too if you want it to continue down. They have...