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 Votes
Group By query Error
SELECT Year(glpostdt) as Year, Item, Quantity, Sales, (Sales/Quantity) as ASP FROM ABC Where Seller like ...Unanswered | 2 Replies | 559 Views | Created by SQLC - Friday, December 6, 2019 5:34 PM | Last reply by Guoxiong - Friday, December 6, 2019 5:47 PM -
0 Votes
Regarding ADF triggers
Hi, I want to know that once a pipeline is done in ADF in which a csv file is copied ...Unanswered | 5 Replies | 509 Views | Created by Arati kharat - Thursday, November 28, 2019 6:34 AM | Last reply by Vaibhav-Chaudhari - Thursday, November 28, 2019 7:37 AM -
0 Votes
Liking netezza to SQL server
I am trying to link a IBM Netezza server to a Microsoft SQL server I have installed the OLE DB driver. I am getting the following error can someone ... -
0 Votes
Could not load file or assembly 'Microsoft.DataWarehouse.SQM, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The module was expected to contain an assembly manifest. (SqlMgmt)
I am all of a sudden getting the above error when I tried to backup any database on my server. I am running windows server 2008 R 2 with Microsoft Sql server 2008 R 2 developer edition. I ...Unanswered | 2 Replies | 794 Views | Created by denkyira - Friday, November 22, 2019 4:22 AM | Last reply by denkyira - Monday, November 25, 2019 7:21 PM -
0 Votes
SQL 2019 Linux on Docker Machine Learning Services (EULA) fail
Hi, I've installed the following SQL 2019 in a Docker. It's running well and I've access to the database: Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 ... -
0 Votes
how to make one store procedure/ query from following queries
i want to create one store procedure/view/query from the above queries.. i am stuck here from the last week help me out and thanks in ...Unanswered | 2 Replies | 720 Views | Created by hi_khan - Saturday, November 9, 2019 8:09 AM | Last reply by hi_khan - Wednesday, November 20, 2019 7:23 AM -
0 Votes
How to add case condition in sql sub queries
receipt.paid_amount select student.Student_id as [Ac #], case when invoice.invoice_id in (select Recipt.invoice_id from Recipt) and ... -
0 Votes
Unknown file extensions
I don't recall now where I got this package SQLServer2016Samples containing much SQL Server useful code. Most likely it was at gitHub. Most of the files there have extensions .sql and they ...Answered | 1 Replies | 775 Views | Created by MyCatAlex - Friday, November 15, 2019 10:39 PM | Last reply by Olaf Helper - Saturday, November 16, 2019 6:05 AM -
0 Votes
developer
='YYYY-MM-DD' and W_dateUnanswered | 1 Replies | 745 Views | Created by 1Bini eng_and_mus - Monday, November 11, 2019 5:25 PM | Last reply by Guoxiong - Monday, November 11, 2019 6:07 PM -
1 Votes
How to find all records in a many to many relationship
= 3), Psw varchar(64) COLLATE SQL_Latin1_General_CP1_CI_AS not null check (len(Psw) >= 8) ); create table "Projects" ( ProjectID int Primary ...Answered | 3 Replies | 735 Views | Created by avivgood - Thursday, November 7, 2019 7:33 PM | Last reply by Guoxiong - Thursday, November 7, 2019 9:23 PM -
0 Votes
developer
='YYYY-MM-DD' and W_dateUnanswered | 1 Replies | 703 Views | Created by 1Bini eng_and_mus - Thursday, November 7, 2019 5:17 PM | Last reply by Olaf Helper - Thursday, November 7, 2019 7:35 PM -
0 Votes
Parameters of Sequence Clustering
Hi, I'm using Sequence clustering from Data Mining of Analysis Services. From the Sequence clustering Microsoft manual, it says the algorithm ... -
0 Votes
Remove 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 | 925 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 | 2347 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 | 1084 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 | 1260 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 | 1826 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 | 2448 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 | 1509 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 | 1736 Views | Created by martirl3 - Monday, July 1, 2019 2:26 PM | Last reply by martirl3 - Thursday, July 4, 2019 3:03 PM - Items 1 to 20 of 3633 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!