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.
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.