Click here to Skip to main content
15,921,959 members
Home / Discussions / Database
   

Database

 
QuestionFloating Point Numbers Stored as Text with Integration Services Pin
moon_stick19-Jan-10 2:22
moon_stick19-Jan-10 2:22 
AnswerRe: Floating Point Numbers Stored as Text with Integration Services Pin
Eddy Vluggen19-Jan-10 11:15
professionalEddy Vluggen19-Jan-10 11:15 
QuestionSQL Application - stuck on the way I should update my Table Pin
ps0f0r18-Jan-10 22:24
ps0f0r18-Jan-10 22:24 
AnswerRe: SQL Application - stuck on the way I should update my Table Pin
Mycroft Holmes19-Jan-10 10:39
professionalMycroft Holmes19-Jan-10 10:39 
QuestionQuestion about simple pattern recognition (hopefully the solution is simple too...) Pin
James Shao17-Jan-10 22:24
James Shao17-Jan-10 22:24 
AnswerRe: Question about simple pattern recognition (hopefully the solution is simple too...) Pin
Mycroft Holmes18-Jan-10 11:10
professionalMycroft Holmes18-Jan-10 11:10 
GeneralRe: Question about simple pattern recognition (hopefully the solution is simple too...) Pin
Luc Pattyn18-Jan-10 11:47
sitebuilderLuc Pattyn18-Jan-10 11:47 
GeneralRe: Question about simple pattern recognition (hopefully the solution is simple too...) Pin
James Shao18-Jan-10 12:43
James Shao18-Jan-10 12:43 
Thank you Holmes for the reply.   Smile | :)

In essence I am trying to compare one column's pattern against each other, so if column A and column B have three attriutes that are the same, then that's 3 matches for that pair.

Luc is right in saying there'll be n(n+1)/2 comparisons, given n columns.   Given roughly 10000 columns, that's about roughly 50 million comparisons.   However, that is assuming that during each comparison loop you can only compare 1 versus 1 at a time.   Now I am trying to figure out whether there's an ingenious way to solve this problem efficiently (1 hour of process time is okay by me).

Ultimately, the purpose of this exercise is to write a code that can categorize various random patterns into groups.   So for example, after this is done, you can observe and say, "Group 1 has higher attribute a, lower attribute b, lower attribute c", and "Group 2 has below average attrite a, but very high attribute d"...etc.   Big Grin | :-D
AnswerRe: Question about simple pattern recognition (hopefully the solution is simple too...) Pin
i.j.russell18-Jan-10 11:48
i.j.russell18-Jan-10 11:48 
GeneralRe: Question about simple pattern recognition (hopefully the solution is simple too...) Pin
James Shao18-Jan-10 22:00
James Shao18-Jan-10 22:00 
GeneralRe: Question about simple pattern recognition (hopefully the solution is simple too...) Pin
i.j.russell18-Jan-10 23:38
i.j.russell18-Jan-10 23:38 
QuestionHow to Import many excel Files to sql server 2005? Pin
caiguosen17-Jan-10 3:31
caiguosen17-Jan-10 3:31 
AnswerRe: How to Import many excel Files to sql server 2005? Pin
Eddy Vluggen17-Jan-10 6:13
professionalEddy Vluggen17-Jan-10 6:13 
GeneralRe: How to Import many excel Files to sql server 2005? Pin
caiguosen20-Jan-10 23:49
caiguosen20-Jan-10 23:49 
GeneralRe: How to Import many excel Files to sql server 2005? Pin
Eddy Vluggen21-Jan-10 0:11
professionalEddy Vluggen21-Jan-10 0:11 
GeneralRe: How to Import many excel Files to sql server 2005? Pin
caiguosen21-Jan-10 0:58
caiguosen21-Jan-10 0:58 
GeneralRe: How to Import many excel Files to sql server 2005? Pin
Eddy Vluggen21-Jan-10 1:25
professionalEddy Vluggen21-Jan-10 1:25 
GeneralRe: How to Import many excel Files to sql server 2005? Pin
caiguosen23-Jan-10 21:50
caiguosen23-Jan-10 21:50 
GeneralRe: How to Import many excel Files to sql server 2005? Pin
Eddy Vluggen24-Jan-10 1:47
professionalEddy Vluggen24-Jan-10 1:47 
GeneralRe: How to Import many excel Files to sql server 2005? Pin
caiguosen24-Jan-10 2:05
caiguosen24-Jan-10 2:05 
GeneralRe: How to Import many excel Files to sql server 2005? Pin
Eddy Vluggen24-Jan-10 4:54
professionalEddy Vluggen24-Jan-10 4:54 
GeneralRe: How to Import many excel Files to sql server 2005? Pin
caiguosen24-Jan-10 16:23
caiguosen24-Jan-10 16:23 
Questionfixing table for looping through checkboxlist. Pin
macupryk16-Jan-10 12:18
macupryk16-Jan-10 12:18 
GeneralThe Secret $5680 in 24 Hour Strategy Pin
mFarooq7215-Jan-10 14:38
mFarooq7215-Jan-10 14:38 
GeneralRe: The Secret $5680 in 24 Hour Strategy Pin
Mycroft Holmes15-Jan-10 16:27
professionalMycroft Holmes15-Jan-10 16:27 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.