Business Problem: Range Of Coverage Of Material Stocks / Need Help With Design
Mar 24, 2008
I'd like to display the our range of coverage of material stocks via SSRS. The underlying database provides all the actual stocks of our materials as well as the current and planned consumption. Now, my problems are the design, as I am not sure If I can realise it with SSRS, and the way of displaying the actual range of coverage as I have no future time informations.
Has anybody made experiences with reports like that?
View 6 Replies
ADVERTISEMENT
Oct 20, 2007
I am running an application with an SQL database and it works fine. My question is about a customer changing his information. We will need to be able to produce copies of old orders/invoices even after that company's info has changed (e.g. he moved or changed the company's name).
Assuming he changes his company's name, for example, do I,
1. Enter him as a "new" company? This allows me to keep the old info in the database if I query the "old" name but does not provide any portability of "old" information forward to the "new" company like payment patterns, past orders, etc. since he is "new" and has no past.
2. Or do I change the record of the"old" company to reflect the "new" name? Here I can keep the "old" past under the "new" name but I now cannot retrieve an old document that reflects the "old" name.
3. Or, the third alternative is to export to alternative storage all the files of the "old" company and go to number 2 above?
I thought about copying the "old past" into a "new" customer but then I'd have double sales, receipts, etc and I just can't see an end to that debacle.
None of these sound like fun but I'm sure I'll soon have to do one of these. I can't be the first one to ask this and I'm sure there is someone out there who is smarter than me/has a more elegant solution. Any suggestions?
I also posted this to Small Business Development forum but thought the SQL guys might have another idea.
View 7 Replies
View Related
Jul 22, 2015
Developing a Retail cube using SSAS 2012. One of the dimension is DimCustomer with SCD type II. Each Customer can be a member or a non-member over a period of time. We have StartDt and EndDt to reflect the membership status.
eg:
Joe is a member between 06-01-2014 and 31-08-2014
Joe is a non-member between 09-01-2014 and 01-31-2015
Joe is a member between 02-01-2015 and 04-30-2015
Joe is a non-member between 05-01-2015 and 12-31-9999
Without adding fact row of Joe for each day to reflect the membership status, I want to provide the ability to measure "Active Customers Count" on a given date. There are 2 million customers in the DimCustomer Table.
View 2 Replies
View Related
Jul 23, 2005
What up-to-date books on this topic can people here recommend? Thanks.- Bob
View 1 Replies
View Related
Oct 23, 2007
Does anyone have a successful prescribed sequence for installing VS2005 and Business Intelligence Reports Projects on a Vista Business workstation to be used to create reports for a server?
I've looked through everything I can find here and I don't seem to see a clear solution without a lot of trial and error.
Fact is, I've not been successful getting just the reports to install on a plain XP box. Of course, the report creation looks fine on the server but I don't want to work directly on the server.
Thank you
View 1 Replies
View Related
Jun 10, 2006
Can anyone take me through synchronization of contacts within Business Contacts Outlook into Microsoft Small Business Accounts?
I run a stand alone PC with NO network. When SBA came SQL was also installed. Apparently you can synchronise Contacts within Business Contacts with SBA but both SBA & Outlook should work through the same SQL server.
Has anyone tried this?
Can someone walk me through the process?
Thanks
Debbie
View 1 Replies
View Related
Feb 23, 2004
does any one know any good pages to get some sql commands
and explainations thanks
View 2 Replies
View Related
Jun 27, 2006
Hi
I was searching some books about SQL but all that i found was "Big books", i mean, i found books about all SQL Server and i just need to know a few things.
I'll need to make queries to a DB and make excel or acces reports based on the query result.
Well, thanks in advance
View 1 Replies
View Related
Mar 21, 2008
Hi,
I am new to SSIS.
1) I want to create a SSIS package to execute 5 stored procedures one by one. Stored procedures has parameters.
2) I want to create a SSIS package for ETL. To extract data from different tables from a database and insert into a new table in the same database on a monthly basis. How do i do these two?
Is there a good material i can go through to achieve these tasks?
Thanks in advance
View 5 Replies
View Related
Feb 13, 2008
Hi,
I would like to create views in TOAD 9.1 Application.
Could any one help me how to write Sql.
Below are the tables which i have created.
1) DIM_RANK_GRP:
CREATE TABLE DIM_RANK_GRP
(RANK_GRP_ID NUMBER NOT NULL,
RANK_GRP VARCHAR (20),
PARENT_RANK_GRP VARCHAR (20)
HIERARCHY_TYPE VARCHAR (20)
);
ALTER TABLE DIM_RANK_GRP
ADD PRIMARY KEY (RANK_GRP_ID)
2) DIM_PROFITABILITY:
CREATE TABLE DIM_PROFITABILITY
(
PROFIT_ID NUMBER NOT NULL,
PROFIT_VAL NUMBER,
PROFIT_DESC VARCHAR (30)
);
ALTER TABLE DIM_PROFITABILITY
ADD PRIMARY_KEY (PROFIT_ID)
3) Fact Table: Agg_Rx_Weekly_Sales:
CREATE TABLE AGG_RX_WKLY_SLS
(TERR_ID Number,PFZ_PROD_ID Number ,DT_SK Date,CHNL_ID Number,SPEC_ID Number,RANK_GRP_ID Number,PRFTY_ID Number,Nrx Float(64),Trx Float(64),
Nrx_unit Float(64),Trx_unit Float(64),Nrx_Dol Float(64),Trx_Dol Float(64),Mkt_Nrx_Unit Float(64),Mkt_Trx_Unit Float(64),Mkt_Nrx_Dol Float(64),Mkt_Trx_Dol Float(64),Mkt_Nrx Float(64),Mkt_Trx Float(64)
);
ALTER TABLE “AGG_RX_WKLY_SLS�
ADD CONSTRAINT FK_DIM_TERR
FOREIGN KEY (“TERR_ID�)
REFERENCES “DIM_TERR� (“TERR_ID�);
ALTER TABLE�AGG_RX_WKLY_SLS�
ADD CONSTRAINT FK_DIM_PERD
FOREIGN KEY (“DT_SK�)
REFERENCES “DIM_PERD� (“DT_SK�);
ALTER TABLE “AGG_RX_WKLY_SLS�
ADD CONSTRAINT FK_DIM_SPEC
FOREIGN KEY (“SPEC_ID�)
REFERENCES “DIM_SPEC� (“SPEC_ID�);
ALTER TABLE “AGG_RX_WKLY_SLS�
ADD CONSTRAINT FK_DIM_CHNL
FOREIGN KEY (“CHNL_ID�)
REFERENCES “DIM_CHNL� (“CHNL_ID�);
ALTER TABLE “AGG_RX_WKLY_SLS�
ADD CONSTRAINT FK_REL_PROD_MKT
FOREIGN KEY (“PFZ_PROD_ID�)
REFERENCES “REL_PROD_MKT� (PFZ_PROD_ID�);
ALTER TABLE “AGG_RX_WKLY_SLS�
ADD CONSTRAINT FK_DIM_RANK_GRP
FOREIGN KEY (“RANK_GRP_ID�)
REFERENCES “DIM_RANK_GRP�(RANK_GRP_ID�);
ALTER TABLE “AGG_RX_WKLY_SLS�
ADD CONSTRAINT FK_DIM_PRFTY
FOREIGN KEY (“PRFTY_ID�)
REFERENCES “DIM_PRFTY� (PRFTY_ID�)
Advanced Thanks.
VENKAT
View 2 Replies
View Related
Sep 9, 2006
Hello,I'm new to SQL Server, have alot of experience with DB2 and Oracle,and have beentasked with supporting SQL Server. Could anyone suggest a goodadministrator book?Thanks!!Dave Schaeffer
View 1 Replies
View Related
Nov 27, 2007
I am in the process of creating a user interface that will give the users a list of reports to choose from. I wanted to write an interface in ASP .NET with C# to pull information for different reports from the reporting services web service. I have successfully done this with C# Windows Form. The project requires it to be web-based.
Problem is, I am new to web forms and would like a recommendation for reference materials to help me program ASP .NET with C# and using the web service. I am still learning ASP .NET and C#, so I would like something fairly basic.
Any help is appreciated.
View 3 Replies
View Related
Aug 30, 1999
Has anyone used any CBT's for SQL7 or could recommend a good company for study materials. I have seen the product from CBT systems and Keystone and was not impressed.
View 2 Replies
View Related
Dec 6, 2005
Greetings,Can someone recommend me some online redbooks or anylink regarding "Migration from Sybase to Sql Server"?Any feedback will be appreciatedTIA
View 2 Replies
View Related
Apr 11, 2006
Who has SQL Server 2005 teaching material? Anyting is ok. thanks. :)
View 2 Replies
View Related
Nov 10, 2014
How to use hierarchy id data type in Bill of material database.
The msdn example [URL] ....
View 1 Replies
View Related
Jan 4, 2002
Dear Sir/Madam
I am certified Oracle DBA/Developer/Internet Developer. Now, I am interested in Microsoft Certificated DBA (MCDBA/MCSD).
By the way, I don't want to waste money to purchase the Microsoft exam software (Self Test Software) and training material. So, I want to exchange the MCDBA exam software and training material with you by using Oracle OCP 8i, Developer 2000 Rel 2.0 and MCSE 2000 Self Test Software.
I can use Oracle 8iDBA, Oracle Developer and MCSE 2000 self test software listed below to exchange 70-228,70-229,70-215,70-216,70-175 or other MCDBA 2000 and MCSE 2000 self test software and training materials.
<Oracle 8i DBA>
1Z0-001 Introduction to Oracle: SQL and PL/SQL
1Z0-023 Oracle8i: Architecture and Administration
1Z0-024 Oracle8i: Performance Tuning
1Z0-025 Oracle8i: Backup and Recovery
1Z0-026 Oracle8i: Network Administration
<Oracle Developer>
1Z0-101 Develop PL/SQL Program Units
1Z0-121 Developer/2000: Build Forms I
1Z0-122 Developer/2000: Build Forms II
1Z0-123 Developer/2000: Build Reports
<MCSE 2000>
70-210 Installing, Configuring and Administering Microsoft Windows 2000 Professional
70-215 Installing, Configuring, and Administering Microsoft Windows 2000 Server
70-216 Implementing and Administering a Microsoft Windows 2000 Network Infrastructure
70-217 Implementing and Administering a Microsoft Windows 2000 Directory Services Infrastructure
70-219 Designing a Windows 2000 Directory Services Infrastructure - (Includes 4 Case Studies)
By the way, if you have any one of 70-228,70-229,70-175,70-176,70-100, I can use whole set of Self test software to exchange yours.
Please provide email accounts with at least 5MB space for exchanging Self Test Software.
Thanks and Regards,
Jack
OCP DBA/Developer/Internet Developer
jacklam@tom.com
View 1 Replies
View Related
Nov 29, 2015
I have a query that returns material(items) that are used in an event on a certain day.
SELECT C.categoryName, count(I.itemID) AS InMission
from items as I
RIGHT JOIN Categories AS C on I.categoryID = C.categoryID
INNER JOIN LinkMissionItem as LM on I.itemID = LM.itemID
INNER JOIN Missions as M on LM.missionID = M.MissionID
where '2015/12/19' BETWEEN M.freightLeave and M.freightReturn AND isReturned = 0
GROUP BY C.categoryName, C.categoryID
ORDER BY C.categoryID
There are a total of 20 categories and I would like all the categories listed in the result even though there are no items booked in a mission. At the moment, I can only get the categories that have items in that category booked in a mission. I hoped that the RIGHT JOIN on the categories table would do the trick but it doesn't.
View 4 Replies
View Related
Jul 22, 2015
I have 2 tables each containing a material type. Table 1 contains material from their 3D application. Table 2 contains material with specific values that is not ours and we cannot rename or edit the data. I need a type of junction or mapping table that can connect the user material to the preset material. for example:
User Material = Wood-MDF
Preset Material = MDF Panel
I figured that i would make this table with 3 fields (ID, UserMaterialID, PresetMaterialID).How would i then construct a query view / Stored procedure that would return the Preset data values based on the user material id?
View 2 Replies
View Related
Aug 16, 2006
I am attempting to write a SQL query that retrieves info processed between two times (ie. 2:00 pm to 6:00 pm) during a date range (ie. 8/1/06 to 8/14/06)... I am new to SQL and am perplexed... I have referenced several texts, but have not found a solution. Even being pointed in the right direction would be greatly appreciated!!
View 6 Replies
View Related
Nov 26, 2014
I'm running a pre-defined script which used to work fine on a file which was resupplied every month. below is the script used and the error message. looking at the error I assume that there is a rouge record within the file but have looked in Textpad and cannot find it.
UPDATE [matching].[dbo].[hot_nov] SET [AOV] = (CAST([Demand] AS DECIMAL)/CAST([Orders] AS INT)) WHERE [Demand] <> '';
UPDATE [matching].[dbo].[hot_nov] SET [POST2] = left([PostCode], PATINDEX('%[0-9]%', [PostCode] + '1') - 1) ;
UPDATE [matching].[dbo].[hot_nov] SET [POST4] = left([PostCode],LEN([PostCode])-4);
UPDATE [matching].[dbo].[hot_nov] SET [POST6] = left([PostCode],LEN([PostCode])-2);
error message
(1000 row(s) affected)
Msg 245, Level 16, State 1, Line 181
Conversion failed when converting the varchar value '2014-09-03 00:00:00' to data type int.
View 5 Replies
View Related
Apr 6, 2015
I have 2 tables, one is table A which stores Resources Assign to work for a certain period. The structure is as below
Name StartDate EndDate
Tan 2015-04-01 08:30:00.000 2015-04-01 16:30:00.000
Max 2015-04-01 08:30:00.000 2015-04-01 16:30:00.000
Alan 2015-04-01 16:30:00.000 2015-04-02 00:30:00.000
The table B stores the item process time. The structure is as below
Item ProcessStartDate ProcessEndDate
V 2015-04-01 09:30:10.000 2015-04-01 09:34:45.000
Q 2015-04-01 10:39:01.000 2015-04-01 10:41:11.000
W 2015-04-01 11:44:00.000 2015-04-01 11:46:25.000
A 2015-04-01 16:40:10.000 2015-04-01 16:42:45.000
B 2015-04-01 16:43:01.000 2015-04-01 16:45:11.000
C 2015-04-01 16:47:00.000 2015-04-01 16:49:25.000
I need to select the item which process in 2015-04-01 16:40:00 and 2015-04-01 17:30:00. Beside that I need to know how many resource is assigned to process the item in that period of time. I only has the start date is 2015-04-01 16:40:00 and end date is 2015-04-01 17:30:00. How I can select the data from both tables. There is no need for JOIN, just seperate selections.
Another item process time is in 2015-04-01 10:00:00 and 2015-04-04 11:50:59.
The result expected is
Table A
Name StartDate EndDate
Alan 2015-04-01 16:30:00.000 2015-04-02 00:30:00.000
Table B
Item ProcessStartDate ProcessEndDate
A 2015-04-01 16:30:10.000 2015-04-01 16:32:45.000
B 2015-04-01 16:33:01.000 2015-04-01 16:35:11.000
C 2015-04-01 16:37:00.000 2015-04-02 16:39:25.000
Scenario 2 expected result
Table A
Name StartDate EndDate
Tan 2015-04-01 08:30:00.000 2015-04-01 16:30:00.000
Max 2015-04-01 08:30:00.000 2015-04-01 16:30:00.000
Table B
Item ProcessStartDate ProcessEndDate
Q 2015-04-01 10:39:01.000 2015-04-01 10:41:11.000
W 2015-04-01 11:44:00.000 2015-04-01 11:46:25.000
View 8 Replies
View Related
Jul 29, 2013
I have a need to select rows where values in a column are within a range AND ALSO the first row that is highest (MAX) but just UNDER the range. For example:
NAME VAL
Jim 4
John 5
Tom 6
Julie 7
Rich 8
Rob 9
RANGE TO SELECT is 6-8 (inclusive)
Rows with a value in the range are returned (6, 7, & 8) as well as the row with a highest value that is JUST BELOW the range (5)
NAME VAL
John 5
Tom 6
Julie 7
Rich 8
View 2 Replies
View Related
May 13, 2015
I have a scenario like below
Product1
Product2 Product3
Product4 Product5
Product1 1
1 0 0
1
Product2 1
1 0 0
1
Product3 0
0 1 1
0
Product4 0
0 1 1
0
Product5 1
1 0 0
1
How to design tables in SQL Server for the above.
View 2 Replies
View Related
Feb 13, 2002
Ok, I'm doing a football database for fixtures and stuff. The problem I am having is that in a fixture, there is both a home, and an away team. The tables as a result are something like this:
-------
Fixture
-------
fix_id
fix_date
fix_played
----
Team
----
tem_id
tem_name
-----------
TeamFixture
-----------
fix_id
tem_id
homeorawayteam
goals
It's not exactly like that, but you get the point. The question is, can I do a fixture query which results in one record per fixture, showing both teams details. The first in a hometeam field and the second in an away team field.
Fixture contains the details about the fixture like date and fixture id and has it been played
Team contains team info like team id, name, associated graphic
TeamFixture is the table which links the fixture to it's home and away team.
TeamFixture exists to prevent a many to many type relationship.
Make sense? Sorry if this turns out to be really easy, just can't get my head around it at the mo!
View 2 Replies
View Related
Aug 18, 2015
I would like to create a table called product. My objective is to get list of packages available for each product in data grid view column while selecting each product. Each product may have different packages type (eg:- Nos, CTN, OTR etc). Some product may have two packages and some for 3 packages etc. Quantity in each packages also may be differ ( for eg:- for some CTN may contain 12 nos or in other case 8 nos etc). Prices for each packages also will be different that also need to show. Â How to design the table..Â
Product name  : Â
Nestle milk |
Rainbow milk
packages  :
CTN,OTR, NOs |
CTN, NOs
Price:
50,20,5 |
40,6
(Remarks for your reference):CTN=10nos, OTR=4 nos Â
| CTN=8 Nos
View 3 Replies
View Related
Feb 10, 2008
I had to do a re-install of SQL 2005 Standand Edition. I
now do not have the BI, I do not know if it came with it or not.
What would I need to install ifit did? I also wanted to
ask: I know that MS Office Excel has the capabilites to sames as
an XML file, but it is not very readable to import into the SQLdatabase. Is there a way to import the XML file into the database via one of the express editions? Thank youDee
View 1 Replies
View Related
Jun 20, 2008
dear gurus,
I want to get the working days between two days..
in a single query.
i will give the start_date '06-02-2008',end_date '06-13-2008' the result should be as below.
06-02-2008Monday
06-03-2008Tuesday
06-04-2008Wednesday
06-05-2008Thursday
06-06-2008Friday
06-09-2008Monday
06-10-2008Tuesday
06-11-2008Wednesday
06-12-2008Thursday
06-13-2008Friday
Thanks in advance.
cool...,
View 5 Replies
View Related
Jul 12, 2005
I want to understand what is Business intelligence and what is functions of it
View 1 Replies
View Related
Sep 24, 2007
I Have a date range and i want to calculate the number of days - the weekends(saturdays and sundays) so that only businessdays are obtained.
A simple table's example:
Name, surname, datebeg, dateend
How can can it be done with sql?
BB
View 3 Replies
View Related
Aug 20, 2007
Hi,
I am wondering what is vb.net method of calculating the prior business day (Monday - Friday).
For example, if today is Monday, Aug. 20, the last business day would have been Friday, Aug. 17.
I have a way to do this in SQL, but not vb.net.
Thanks much
View 4 Replies
View Related
Feb 28, 2008
Ok, probibly an easy question but I haven't been able to find what I am looking for.
If I have a simple class (see below), how would I make the People List avalible to build a report off of?
Thanks
asdf46
Code Snippetpublic class Person
{
public string FirstName { get; set;}
public string LastName { get; set;}
}
// and put them into a list
List <Person> People = new List<Person>();
People.Add(new Person () { FirstName = "Joe", LastName = "User"});
People.Add(new Person () { FirstName = "Jane", LastName = "Smith"});
View 3 Replies
View Related
Apr 11, 2008
Hi all,
I've created a store dimension. Within the store dimension is a CityID column that is related to a City dimension. Currently this city dimension has the following columns:
CityID (primary key --- foreign key for the StoreDim)
CityName
CountyName
StateName
CountryName
...
My SCD's source is being loaded from a query to a Zip table that contains ZipCodes along with cityID, CountyID, StateID, and CountryID that can be joined out to their respective tables to find the information needed to populate my SCD. However, cities can have several number of zipcodes and several cities in different states can have the same names. This causes a problem with eliminating duplicates for my dimension as well as finding a suitable business key.
For example, let's take a case: Washington city, District of Columbia (county), District of Columbia (state), USA (Country)
Now, this city has SEVERAL zip codes so when I create my joins:
SELECT ...
FROM Zip Z
INNER JOIN City C
ON C.CityID = Z.CityID
INNER JOIN County Cty
ON Cty.CountyID = Z.CountyID
So this returns several CityIDs for the same city... which when I try to use for my SCD causes problems because i have several business keys based off my CityIDs so my dimension loaded would look like
CityID CityDesc CountyDesc StateDesc CountryDesc
1 Washington District of Columbia District of Columbia USA
2 Washington District of Columbia District of Columbia USA
3 Washington District of Columbia District of Columbia USA
4 Washington District of Columbia District of Columbia USA
I want to have just ONE record in my dimension for this city.... How would I do this and what would I use for a business key? Also any recommendations on which of these attributes should be historical attributes? I would appreciate any input you guys have.
View 4 Replies
View Related
