Search results for query: *

Hello Borislav, I actually need two take 24 months of data in a pivot table. This is the reason why I need to concatenate the year variable with the field name for my pivot table. Hello Quik3Coder, please give me more information on how to make your example work. I need to have a pivot table...

Hello, I'm trying to concatenate a variable to a sql statement that creates a pivot table. This statement is givig me an error Select ship_from, 'Jan-'+@cyear=sum(case when invoice_dt >= '01/01/' + @cyear + ' 00:00:00:000' and invoice_dt< '01/31/' + @cyear + ' 23:59:59:999' then quantity...

Hello, I have an existing table with several thousand records. I need to add a uniqueidentifier field to the table. Can you give me an idea of what steps to take to do this? Thank you.

Hello, I made a mistake - We're using SQL2000 not MSSQL7. I was misled my the root director MSSQL7 Thanks

Business Requirement: Automatically create an XML file from MSSQL7. The XML file must be readable by Excel 2007. Here is what I have done: 1) I saved the following statement to myscript.sql: use Mini_DW go select contractor_name,cid from CONTRACTOR for XML AUTO 2)I ran this statement...

Thank you for the advise. I'll probably go with the 3rd party software.

Hello, Please give me an idea how I can do a wildcard search on multiple values contained in a specific field. PROBLEM DESCRIPTION: We have a CUSTOMER table with 500 customers. Example of table records: CustID Customer_Name 1 ABC Co. 2 XYZ Co. 3...

Thank you much LB. You have always provided very good solutions to all my questions as well as to other postings that I have used. Thank you again.

Hello, Please show me how to create a bar chart showing a month to month comparison of sales data for a given period of time. The x-axis is Month of sales, y-axis is sales dollars. The chart must two bars for each month comparing two years. For example, Jan-06 vs Jan-07, Feb-06 vs. Feb-07...

SQLSister, thank you so much for the input. The update statement works. You understand exactly what I'm upgainst - troublesome dataintegrety issu. Yes, I truly need the GOOD LUCK!... God bless you :-) Thank you SQLBill for providing a different approach. This works too.

I have 2 tables: SALES table and CUSTOMER table. The SALES table contains inconsistent customer name. I need to assign a key to the customer in the SALES table based on the CUSTOMER table. I would like to update the SALES.customerID field = to the CUSTOMER.customerID field. I wrote this...

We're using BOE XI Release 2. Background Info: I have a dozen different recurring schedules against one report (Sales Rep Production Report) that takes a parameter: i.e. Sales Rep Name. Each recurring schedule is set with a parameter equal to the different sales rep name. Every month, the...

We're using BOE XI Release 2. Background Info: I have a dozen different recurring schedules against one report (Sales Rep Production Report) that takes a parameter: i.e. Sales Rep Name. Each recurring schedule is set with a parameter equal to the different sales rep name. Every month, the...

Thank you Ian. The tool works well. However, one needs to know the new database schema and map the fields accurately for it to work properly. In my case, I don't have the database schema and I'm trying to figure it out as I go along. So I guess the tool doesn't work that well. But it's a...

I have over a hundred reports that point to one database. I need to change the database name and database location for all these reports (the new database schema that the report will be pointing to is essentially the same). Is there a way to perform a mass change of the datasource of all these...

You're absolutely correct. I used the BOE Administrator account and the import worked. The BOE documentation is actually not very clear. I thought it was referring to the machine administrator account. Thank you.

Hello, I'm using BOE XI Release 2 Import Wizard. I'm running the Import Wizard from the destination server (e.g. NewBOEServer). The source server, (e.g. OldBOEServer) is version BOE XI. I'm getting this error after providing the logon information for the Source Server: "You have logged on as...

Formula @LineCounter: whileprintingrecords; numbervar intLineCount:=intLineCount+1; Formula to ResetLineCounter: whileprintingrecords; numbervar intLineCount; if not inrepeatedgroupheader then intLineCount:=0; Thank you.

Hello LB, You're absolutely correct. This is where the trouble lies. My calculation in GF1 becomes different once I drilldown. Do you have any idea on how I can take just the maximum count, make it a constant for Group Footer 1, so that it doesn't change during drilldown? Thank you. Bette

Hello Pont, Thank you for taking the time to help me. Your suggested solution partly works. What I really need to do is to display/derive ONLY ONE number in GF1 footer that represents the maximum line count of all the groupings in Group footer 2. This one/constant number should be the...