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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
Post New Web Links

Customer Segmentation based on purchase behavior

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
 
Hi I am trying to use MS clustering algorithm to segment our customers, just based on customer purchase behavior, we have two tables:   --customer table create table dm_msdm.scmolstp_city_mcc_accounts( olst_txn_acct_nbr character varying(19) NOT NULL ); --customer purchase table create table dm_msdm.scmolstp_city_mcc_aggregated( olst_txn_acct_nbr character varying(19) NOT NULL, olst_mcc_code numeric(4,0), olst_mcc_count integer, olst_mcc_total_amt numeric(11,2));   I learned that the MS_Sequence_clustering algorithm can deal with nest table , but in my case the sequence of stores(olst_mcc_code) is not important, how can I do this.   SQL Server 2008 GUI does not allow us to choose the MS_sequence_clustering algorithm, but only the clustering algorithm, does it mean if we use nest tables then MS_sequence_clustering algorithm is automatically chosen?


View Complete Post


More Related Resource Links

Customer Segmentation based on purchase behavior

  
Hi I am trying to use MS clustering algorithm to segment our customers, just based on customer purchase behavior, we have two tables:   --customer table create table dm_msdm.scmolstp_city_mcc_accounts( olst_txn_acct_nbr character varying(19) NOT NULL ); --customer purchase table create table dm_msdm.scmolstp_city_mcc_aggregated( olst_txn_acct_nbr character varying(19) NOT NULL, olst_mcc_code numeric(4,0), olst_mcc_count integer, olst_mcc_total_amt numeric(11,2));   I learned that the MS_Sequence_clustering algorithm can deal with nest table , but in my case the sequence of stores(olst_mcc_code) is not important, how can I do this.   SQL Server 2008 GUI does not allow us to choose the MS_sequence_clustering algorithm, but only the clustering algorithm, does it mean if we use nest tables then MS_sequence_clustering algorithm is automatically chosen?

5 GridView Themes Based on Google's Personalized Homepage (igoogle)

  
One of the silly features I have found that I like about igoogle is how the pages color palette changes depending upon the time of day. So as the day progresses from morning to afternoon to evening the colors on the page change as well. Like I said, I know this is a silly feature, but I like it. And I have asked around a little bit and seems like other people like it to. To get a better idea of how the colors change, here are the background images from a few of the HTML elements.

Custom Editing Behavior for DataGridView TextBox Columns

  
For various reasons I'm using a DataGridView instead of a ListView, and while configuring the DataGridView to look like a ListView wasn't much of a problem, there's one thing that got on my nerves, which is the behavior of textbox cells in edit mode: It is much too easy to leave the edit mode accidentally, simply by pressing the cursor keys at the wrong time. For example when the text caret is positioned behind the last character of the textbox cell content, and you press the right arrow key

dynamically adding sql server columns based on number of files in fileuploader

  

I want to create a new table to sql database at runtime.  The column names would be "Name", "Date", "Event".  I would also like to have one more column name "Image" but the problem is that since the amount of images will vary, I want the application to count the amount of files in the Multiple fileuploader and then add a image column to the table for the respected amount of files. 

For example if i am uploading 3 files in the multiple fileuploader, the names should be "Name", "Date", "Event", "Image1", "image2", Image3"

I also would like that table name to be name dynamically from the textbox Name when the user enters the information.

 

I have the following code to make a new table, but I dont know how to name the fields at runtime like previously asked please help!!!

 

Dim objConn As New SqlConnection("Server=<servername>;uid=<userid>;pwd=<password>;database=master")

objConn.Open()

Unique content within master page based on conditions met

  

 Hi all-

I would like to present users with unique content based on certain conditions being met as they land on the home page (default.aspx).  The condition logic will be in the VB code behind Page Load event. The content will go in a content placeholder as specificed from the master page. 

However, the content change wouldn't be something small (ie making a panel or label visible or not) but rather it will be different HTML,  Divs and databound gridview content.  The HTML content will be stored in the database.

Can someone point me in the right direction for best practices on how to accomplish this?

Thanks!


Problem making Role based Menu in MVC application

  

Hi,

 I want to make Rolebase menu in MVC such that if user doesnot have permission for some action then that Action name shouldnot be shown in the Menu.

 I have used the code in the url(http://forums.asp.net/t/1566328.aspx) in my MVC application.My application is a Discussion Forum(in MVC) same functionality as in this forum forums.asp.net

 I have used Controllers for post, thread etc.In each controller there are some actions that are using [Authorize(Roles)] attribute

 but this coding does not count  those Actions in Controllers having Authorize attribute according to the url http://forums.asp.net/t/1566328.aspx 

 In the code, Authorize attribute is applied to Controller class, but my requirement is of Applying Authorize attribute to some actions in controller so that some are available for all users and  some links are available rolewise.Now what is the solution for that?

 

Regards

Run Button Behavior: Suggestion/Bug

  

Note: This could be a bug or considered as suggestion. I am not looking for solution.


1: I have ImageWatermark.cshtml open and currently in focus.

2: I have Photo1.jpg selected in left Files workspace.

3: Now if I Click "Run", instead of opening ImageWatermark.cshtml it trys to open Photo1.jpg and it fails.

So ideally I would expect the "open file (ImageWatermark.cshtml) to run rather than running the selection from Workspace.


How to get data from table based on four table

  

Hi..

I need to know how to show top 30 records from four table

with fastest speed.. in ms sql server 2005..

hope You do the needfull

  


how to bind Dropdownlist based on textbox values

  

hi

I have one drodownlist which show data based om textbox values...

Let us consider i have 

Select Name from table1 where Type IN(@typ)

here @typ is textbox values

here for example textbox will have some thing like this L1,L2,L3..

How to filter Name based and shown in drodownlist based on this L1,L2,L3(on textbox)..

Help me in this


services based architecture

  

was giving a though on using ajax enabled wcf services as part of architecture

generally wht im using

is UI-> BL-> data access

 

is it suggestable to use wcf services layer instead

of BL

nd hv UI-> services-> data access

related to asp.net

 

would like to no pro's and con's of doing this thing.

is it suggestable to do it. 


Word Automation - Multiple DCOM Errors/Behavior

  
Before I get started, I already know that Microsoft does not support and highly discourages server-based MS Office automation.  I've read a multitude of posts and smarmy "*wink*, here's a link" replies, so I'm looking for actual help here, not condescending reprimands.

That notwithstanding, here is my problem.  I have developed a simple method that will open a local Word document, modify some header information, and then save the document as a new file.  As expected, it works great as a console/windows app, but as soon as I went to ASP.NET, DCOM jacked my world up when accessing the app remotely from a different domain account (that has access to the ASP.NET app.  For reference, my method is shown below:

  

1    public static string ModifyAndSaveBuildDocument(string localFilePath, BuildDocumentType docType, string buildNumber, DateTime buildDate, string projectName)
2            {
3                try
4                {
5                    ProjectConfiguration config = (ProjectConfiguration)ConfigurationManager.GetSection("ProjectConfiguration");
6    

creating a code based on the evaluation

  

I would like to create a simple program, like a game, but so far without any graphical interface. Only a code, supported with some numbers, so that the user will know whats going on in the background.

I was thinking of creating a racing game (like formula 1 or sometihng similar), with available data (attributes) like:

Driver: age, agility, concentration, experiance, stamina,...

Car: engine, chassis, tyres

Claims-Based Apps: Claims-Based Authorization with WIF

  

Over the past few years, federated security models and claims-based access control have become increasingly popular. Platform tools in this area have also come a long way. Windows Identity Foundation (WIF) is a rich identity model framework designed for building claims-based applications and services and for supporting active and passive federated security scenarios.

Michele Leroux Bustamante

MSDN Magazine November 2009


Contract-First Web Services: Schema-based Development with Windows Communication Foundation

  

Schema- first contract-first modeling of Web Services gives you the ability to model your contracts with an XML-centric mindset. This process keeps you focused on universally acceptable types and the hierarchical data structures that can be represented in XML.

Christian Weyer, Buddhike de Silva

MSDN Magazine October 2009


Parallel Debugging: Debugging Task-Based Parallel Applications in Visual Studio 2010

  

In Visual C++ 10 and the Microsoft .NET Framework 4, Microsoft is introducing new libraries and runtimes to significantly ease the process of expressing parallelism in your code base, together with new tool support for performance analysis and debugging of parallel applications. In this article, you will learn about debugging support in Visual Studio 2010, much of which is focused on task-based programming models.

Stephen Toub, Daniel Moth

MSDN Magazine September 2009


Test-Driven Design: Using Mocks And Tests To Design Role-Based Objects

  

Use Test-Driven Development with mock objects to design object oriented code in terms of roles and responsibilities, not categorization of objects into class hierarchies.

Isaiah Perumalla

MSDN Magazine June 2009


"Oslo" Basics: Build Metadata-Based Applications With The "Oslo" Platform

  

We introduce you to "Oslo" and demonstrate how MSchema and MGraph enable you to build metadata-driven apps. We'll define types and values in "M" and deploy them to the repository.

Chris Sells

MSDN Magazine February 2009


Categories: 
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