Search results for query: *

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.

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

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

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

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

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

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

Hello, My report has 2 groups. I have a formula in Group Footer 2 that takes the total number of lines for each Group in Group 2. The formula is "lineCount" I would like to add a formula in Group Footer 1 that will take the maximum value of "LineCount". The result I get is the last...

Problem: Need to get the weekly sales average (Group 1 Sum Summary) by dividing it by the count of number of days the store is in operation (Group 3 Summary). My report has 3 groups: Group 1: Weekly Company Wide Sales Summary Group 2: Sales by Facility for each Week Group 3: Sales by Day...

I have a report that contains hundreds of sales transaction on a daily basis. My report has 2 summaries: Weekly sum of sales and drills down to daily sum of sales, and finally drills down to the details. I would like to take the average of the summarized daily transactions...