.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Cannot assign multiple keys in the Time Series Algorithm

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :Sql Server

We had a small problem, which we really need to know how to solve as soon as possible, as I told you in our last session that we are running out of time, and this issue is stopping us from completing our predictions. I will try to mention our exact business case and explain it as much detailed as I can so you can help us as soon as possible.


                                Kindly check the following scenario:


                                Table name: X

                                Columns: ID [Identity column], DATE_TIME [its granularity is hour], NODE_NAME, REASON, REQUESTS


View Complete Post

More Related Resource Links

Time series algorithm parametrs

Hello everybody! I have the following questions to You: I have mining model with data by working hours(every day from 08AM-05PM). What PEREODICITY_HINT I have to use? {24} or {9} The second problem is that on the chart I see historical data wiht axis format 08AM-05PM, but in prediction part the periods is 00-24. It is not correct! I want to see the same 08AM-05PM periods too!   Help me please!   Thank You!  

Unusual results using Time Series Algorithm


I am trying to forecast Q4 2010 activity.  The dataset is constant with no gaps from 200401 - 200909.  I want to compare my model with the actual Q4 2009 to verify its accuracy.  The dataset has two columns (month - Key Time and Sales - Predict Only).  I set the PERIODICITY_HINT to {12} since our data is very seasonal.  The problem is every December has increased in sales from the previous year in the dataset, but the prediction fails to recognize this trend.  Is the problem that for 2009 I only give 9 months?  Please help.  A snapshot of the data set is below:



200401 866 200402 709 200403 748 200404 1053 200405 829 200406 957 200407 872 200408 917 200409




200907 3909 200908 3829 200909





how to write a stored proc to prevent multiple users in uploading the reports at a time? plsss help



I wanted to know how to prevent more than one user from uploading the report at a time .I am new to .net ,plss help with the code that would be great.Details are below:

This is a Windos based app written in c# . When User A  clicks Upload option on  one server  from the menu  to upload the files  and at the same time when User B clicks Upload option on different server , User B should be alerted a message saying "User A's uploading is in progress,pls wait" . How to achieve this, plsss help with the code.. I am thinking this logic should be kept in a stored proc, How do I write that proc? plss help


Thanks in advance!

what's the Best practice about exploiting the time series predections history?

Hi all, We are predicting our revenue with two frequency : The first is monthly , the second is weekly with the same parameters daily . The first aimed to have a big picture of our performance during the month , the second is more operational and it's used to drive operational action. So every day we train the second structure with all data and  MTS predicts different value each day basis on the new data used in training. Example: Day of process : 05/07/2010 data used to train : 01/01/2002 ---->05/07/2010 values predicted between : 06/07/2010------>31/07/2010 the value for 18/07/2010 : 35000 $ ------------------------------------------------------------------- Day of process : 10/07/2010 data used to train : 01/01/2002 ---->10/07/2010 values predicted between : 11/07/2010------>07/08/2010 the value for 18/07/2010 : 42000 $   Certainly The second method (predict daily with new training data)  value will be more accruate but it can't be used to drive strategy because it's change every day. Any reflex about this ? saving all data (all prediction for all series every day for the 30 coming steps)? or update coming value with the actualised prediction(the manager will be confused )  

How 2 join Multiple Keys based table???

I have a table INC with 2 Columns/Fields, i.e. YR and CL set as primary keys by selecting both the columns and selecting primary key symbol with right click. How to set up a FK with the other table INC_DTL's CL which I seek to be restricted to a combination of the INC's 2 fields? Thanx in advance.

Advice on collecting data in a time series

Hi everyone,  I just wanted to get some ideas of what you would think be the best way to collect data/numbers that are part of a time series?  Let's say I'm collecting monthly data from the users, related to some product and I'd like to be able to provide them a simple and efficient way of entering these numbers based on some month end period.  So for instance on 6/30/2009, they could enter some numbers for a set of data points that pertain to that product.  Would one of the data controls (such as GridView or DetailsView) be sufficient to do this?  I know the GridView isn't so much able to save data but I believe the DetailsView has some functionality for that. In the end, I'd really like to provide a seemless way to do show this and ability to enter and save this.  Any ideas would be appreciated.Thanks

Multiple insert at the same time

Hi all, I have 6 pc which is connected to the sqlserver. I have a table call tbl_seat with column (id, name, schedule, status) <-- the bold and underline is the primary key So when there is 2 pc choose the same seat at the same time, there cause an xLock and it will hang all my other process... so is there anyway i can stop it?? like there only 1 sql statement at a time... i hope everyone here know what i mean with my bad english.. and thanks in advance for any answer =) btw.. my insert statement is as below ( 2 pc execute the insert statement together) INSERT INTO tbl_seat(name, schedule, status) VALUES ('A01', 2231, 2) INSERT INTO tbl_seat(name, schedule, status) VALUES ('A02', 2231, 2) INSERT INTO tbl_seat(name, schedule, status) VALUES ('A03', 2231, 2) INSERT INTO tbl_seat(name, schedule, status) VALUES ('A04', 2231, 2) INSERT INTO tbl_seat(name, schedule, status) VALUES ('A05', 2231, 2)

How to assign datatype at run time to a declared var in a stored proc?

Hi, I want to declare a local var. in sp. such that it would have the same datatype as a column in a specific table Example (forgive the syntax!) Decalre @Address  CustomerTable.Address The above would translate to the following at execution time Declare @Address VARCHAR(200) This feature was in Oracle, is it in SQL Server as well? Thanks. EK

Updating Multiple records at 1 time.


You got to love management, they can never make their minds up on what they want. 

I'm currently working on a asp.net project using a datagridview that acts for the most part like a spreadsheet.  What I have to do now is update all the values in the table from the selected date, hour, min, max and cost forward.  There are 7 days worth of data in the table, when the user alters either the min, max or cost I need all the values in that field from that point onward to have the new altered value.

Here's an example:

In hour 10 of the day the user want to increase the max from 5 to 19, the min stays the same and so does the cost.  Mind you any or all of these values could change.  The only once that will remain as-is is the Date and Hour field:


Date Hour

How to assign multiple IP's to be assigned to the different WSS sites in the single share point ins


Hi guys,


This was one of the typical queries asked by my client which has to be answered to kick start the project based on the budget.

What is the possibility of WSS accepting 2 IP’s mapped for 2 web sites in a single share point server instance.


I don't have good share point administration knowledge to answer the question.


Guys please help me its bit urgent.... !!!



Thanks keshav,Share point Developer

Optimizing Data Mining processing time for a Time Series model in SQL Server 2008 R2


Does anyone have any references around optimizing the initial processing time for a data mining model? Books, blogs, etc. I have the Wiley “Data Mining with SQL Server 2008” book, and while I’ve learned a lot from it, it doesn’t seem to cover much around trouble shooting things like processing time. I also have a few other books that have a chapter or two on data mining, but again just basic “here’s what it is and how to set it up”, nothing that quite covers trouble shooting or optimization. I’ve also checked out the various Data Mining blogs/sites.


I’ve got a Microsoft Time Series model I’m basing on a Cube. Very simple, trying to forecast sales. I have one dimension which is the list of products (about 1600), a second which is the time dimension, finally the measure is daily sales figures for each, about 3.2 million rows in total. On a brand new server, with two quad core processors and 16 gig of ram it took 40 hours to process. Seems rather high?

How to assign shortcut keys for menu item of asp.net menu control

I am using asp.net menu control. In window application we assign shortcut key through '&' sign for accessing menu item but in asp.net this is not working and there is not any property for access key for menu items. please give me any suggestion.

how to send emails to multiple persons at the same time from sharepoint workflow using visual studio


Hi Every one !!

   I am trying to send copy of a document for multiple directors at my client for their approval.

   The director can approve the document at the same time.

   Hence, I would like to know how to create a task to send emails for multiple people at the same time from a sharepoint workflow using visual studio 2008.

   I see there is a parallel activity. But it gives me only 2 paths ( means would be able to send only for 2 users )

   If creating a separate task to send emails for each user is an inefficient way, please let me know if there is another good way of sending emails to multiple users.


Thank you

How to assign shortcut keys for menu item of asp.net menu control



I am using asp.net menu control. In window application we assign shortcut key through '&' sign for accessing menu item but in asp.net this is not working and there is not any property like access key for menu items. please give me any suggestion.



Nitin Munjani

multiple foreign keys to same table and same column


I am working with two Tables. Table A contains Id, Names. Table B  keeps only the reference to table A by InventoryID1, InventoryID12, InventoryID3.

Table A

Table B

I need a select statement to pull up all items from table B, showing the InventoryID 1, 2, 3 by their corresponding Name on Table A  

At first I thought this would be a simple inner join statement, which it does work when only InventoryID1 is involved
select * from Inventory
inner join Menu On (Inventory.InventoryId1 = Menu.Inventory)

The problem arises when I try to obtain the Inventory Name from Table A for the second or third (InventoryID2 or InventoryID3) from Table B. So basically, my problem is how to request a second or third Inventory.Name in the same select statement

Transfering Multiple file at a time



I have a multiple file that i want  to get from FTP Server  to My local

Once i receive all file i want to send all to the Different  FTP Server

In DTS we can get multiple file at same time in same task.But can not do that in SSIS

Is there any way by which I can get Multiple File at Single task and also we can Transfer multiple file From Local to Ftp Server.





Multiple Charts at the same time




I have the below data. I have the Location as the category field, and Ave as the data filed on a bar chart. Is it possible to generate one report for each Speaker without using a parameter? I have around 50 speakers and I don't want to generate one chart at a time.

Thank you


Location Ave Speaker
Miami Beach, FL 96.67 John Smith
Sarasota, FL 92.38 John Smith
Augusta, GA 94.44 John Smith
Mobile, AL 87.5 John Smith
Chattanooga, TN 90.67 John Smith
Charleston, SC 100 John Smith
Individual Average 93.61 John Smith
Charlottesville, VA 80 Joe Doe
Individual Average 80 Joe Doe
Great Falls, MT 89.52 Sam Jones
Lincoln City, OR 86.67 Sam Jones
Individual Average 88.53 Sam Jones
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend