Data Mining announcement
-
Link
Microsoft BI Labs went live today featuring a look into the future of SQL Server Data Mining in the Cloud. The SQL Server Data Mining team presents a set of prototype web services in the cloud that mirror some of the great predictive analytics functionality available in the Table Analysis Tools for Excel add-in from the SQL Server 2008 Data Mining Add-ins for Office package. No installation required.
This blog post provides more details.
Explore these predictive services from your browser - on your own data - and give us your feedback!
-
0 VotesRemove rows in table from 300 databases with same structure
HeloI have 300 mssql databases with the same structure and prefix xxx_ I have to delete the same data from the same table in each of ...Unanswered | 2 Replies | 60 Views | Created by slawekdw - Monday, October 7, 2019 9:02 AM | Last reply by Tom Phillips - Monday, October 7, 2019 1:13 PM
-
0 Votes
Create a SQL Table from a View
I know enough to speak some of the language, but probably not enough to be able to describe well what I'm trying to do. So, please be patient with my illiteracy... This is what I'm trying ...Answered | 4 Replies | 1602 Views | Created by martirl3 - Monday, February 4, 2019 2:00 PM | Last reply by martirl3 - Monday, August 19, 2019 2:48 PM -
1 Votes
Query to get payment differences of latest dates per each customer
Hello guys, I have the following table: My aim is to write a query that would get the amount differences for the two latest paymentDates for ...Unanswered | 1 Replies | 481 Views | Created by FaridGN - Monday, August 5, 2019 7:08 PM | Last reply by José Diz - Friday, August 9, 2019 10:05 PM -
0 Votes
What is a Data Mining Model and how to develop them?
I work on a Data Warehousing Project. We have a Analytical Layer where we have developed SSAS Cube. Now I need to Develop Data Mining Models , could someone how should I start with ...Unanswered | 1 Replies | 489 Views | Created by NEERAJ DUBE - Wednesday, July 24, 2019 6:01 AM | Last reply by Olaf Helper - Wednesday, July 24, 2019 6:51 AM -
0 Votes
Forecasting Weekly Sales
Hi Team, I am trying to forecast the sales for the future week based on the historical Sales data that I am having...But it has a lot of missing values too in couple of weeks but I ...Answered | 5 Replies | 822 Views | Created by Hellothere8028 - Thursday, June 27, 2019 12:09 PM | Last reply by Hellothere8028 - Wednesday, July 10, 2019 5:24 AM -
0 Votes
Very complex/compund SQL view... Help making this more efficient, please?
I have some complicated tables. Tables which I have no control over, nor can they be changed. Thus, I have derived views to compile the data into a single table, so then I can copy ...Answered | 23 Replies | 1614 Views | Created by martirl3 - Thursday, May 9, 2019 6:30 PM | Last reply by martirl3 - Monday, July 8, 2019 1:21 PM -
0 Votes
How to wrap a INNER JOIN around an existing VIEW, in a single statement.
This is an addendum to a previous thread, but I didnt want to continue that thread with scope creep. This is the initial thread, if interest exist on the origin of this statement. @A2605 ...Answered | 3 Replies | 683 Views | Created by martirl3 - Thursday, July 4, 2019 10:27 PM | Last reply by A2605 - Friday, July 5, 2019 1:26 AM -
0 Votes
Combining two very similar views into a single view.
I am trying to simplify a compound view. I am trying to break it up into bit-sized portions to help narrow this down. My biggest area of simplification is how to combine several views that ...Answered | 15 Replies | 929 Views | Created by martirl3 - Monday, July 1, 2019 2:26 PM | Last reply by martirl3 - Thursday, July 4, 2019 3:03 PM -
0 Votes
Rule based Algorithm to Predict Sales Drop
Hi Team, Hope you are doing well!.. I am currently working on a rule based algorithm to predict the probability of sales increase ...I am thinking of a binary logistic ... -
0 Votes
SQL - How to eliminate similar rows
How can I only show ONLY the second row, i.e. one row per result, using this query. Select Distinct I.ID, SLAInfo.IsBreached from IncidentDimvw ...Answered | 6 Replies | 836 Views | Created by Herb Winhoven - Wednesday, June 19, 2019 11:16 PM | Last reply by Mohammad Waheed - Monday, June 24, 2019 10:36 PM -
0 Votes
Microsoft SQL Database Hosting
At the market of website hosting, there are two types of system to select from. At the market today, all website hosting companies will either provide a Windows plan or a Linux plan. Foe people who ... -
0 Votes
JOIN
Hi I have multiple tables i.e. Table1_201806, Table1_201807, Table1_201808, etc.. and Table2_201806, Table2_201807, Table2_201808, ...Answered | 2 Replies | 728 Views | Created by Mogagabe - Friday, June 7, 2019 5:30 AM | Last reply by Mogagabe - Friday, June 7, 2019 6:44 AM -
1 Votes
How to calculate monthly 30-days readmission rate from historical inpatient data in SQL?
I want to calculate monthly readmission rate from inpatient data of 5 years (60) months. Some of the inpatients were readmitted more than 10 times in the time duration, while others were just ...Unanswered | 2 Replies | 1046 Views | Created by MelakuH - Saturday, May 11, 2019 3:30 PM | Last reply by MelakuH - Sunday, May 12, 2019 2:06 AM -
1 Votes
Conditional Lag/Lead
I am fairly new to SQL server syntax and am looking for help with the following scenario. I have a table like the following (with the first 3 ...Proposed | 2 Replies | 942 Views | Created by Connie K3 - Sunday, May 5, 2019 5:29 PM | Last reply by Connie K3 - Monday, May 6, 2019 1:14 PM -
4 Votes
Declaring Table
Hi I am using MS Visual Studio 2012 and experiencing the following error message when declaring a variable table : Msg 103010, Level 16, State 1, Line 40 my ...Answered | 17 Replies | 1206 Views | Created by Mogagabe - Thursday, May 2, 2019 1:25 PM | Last reply by Olaf Helper - Monday, May 6, 2019 9:40 AM -
0 Votes
object reference not set to an instance of an object
Hi I am running MS Office 365 and I have installed MS Data Mining Plugin for SQL Server. I am running SQL Server 2017 Developer edition and MS Analysis Server. As I open a ...Unanswered | 1 Replies | 930 Views | Created by Dr. Zeb - Friday, May 3, 2019 11:29 AM | Last reply by woshixiaobai - Monday, May 6, 2019 8:22 AM -
0 Votes
While Loop
I have 2000 serial numbers in one column of my 'TableA' and want to check them against each other, using a while loop. Any ideas how to structure my query?Unanswered | 1 Replies | 1356 Views | Created by Mogagabe - Friday, April 12, 2019 6:13 AM | Last reply by Olaf Helper - Friday, April 12, 2019 6:16 AM -
1 Votes
Selecting a row of data from a database by column value
I have a database where my data is thus: CarId Make Model EngineType CarId is a ...Answered | 2 Replies | 1496 Views | Created by GeneWh - Wednesday, April 10, 2019 6:59 PM | Last reply by GeneWh - Thursday, April 11, 2019 2:48 PM -
0 Votes
variables
Hi I am trying to query the same table and want to insert different access code using while loop but getting an error. If anyone cal assist it will be ...Unanswered | 4 Replies | 1530 Views | Created by Mogagabe - Wednesday, March 27, 2019 8:11 AM | Last reply by Mogagabe - Thursday, April 11, 2019 9:28 AM - Items 1 to 20 of 3621 Next ›
Data Mining announcement
-
Link
Microsoft BI Labs went live today featuring a look into the future of SQL Server Data Mining in the Cloud. The SQL Server Data Mining team presents a set of prototype web services in the cloud that mirror some of the great predictive analytics functionality available in the Table Analysis Tools for Excel add-in from the SQL Server 2008 Data Mining Add-ins for Office package. No installation required.
This blog post provides more details.
Explore these predictive services from your browser - on your own data - and give us your feedback!
