Click here to Skip to main content
15,503,808 members
Home / Discussions / Database
   

Database

 
AnswerRe: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER Pin
PIEBALDconsult17-Jul-14 14:39
professionalPIEBALDconsult17-Jul-14 14:39 
QuestionExtract Data in Single Record Pin
mrfalk15-Jul-14 14:05
mrfalk15-Jul-14 14:05 
AnswerRe: Extract Data in Single Record Pin
data modeling guy15-Jul-14 20:32
data modeling guy15-Jul-14 20:32 
AnswerRe: Extract Data in Single Record Pin
Richard Deeming16-Jul-14 3:42
mveRichard Deeming16-Jul-14 3:42 
AnswerRe: Extract Data in Single Record Pin
PIEBALDconsult17-Jul-14 14:54
professionalPIEBALDconsult17-Jul-14 14:54 
Questionlinked list using CTE Pin
Ali Al Omairi(Abu AlHassan)14-Jul-14 23:29
professionalAli Al Omairi(Abu AlHassan)14-Jul-14 23:29 
AnswerRe: linked list using CTE Pin
Ali Al Omairi(Abu AlHassan)15-Jul-14 0:14
professionalAli Al Omairi(Abu AlHassan)15-Jul-14 0:14 
QuestionOVER (PARTITION BY ORDER BY ) Pin
Ambertje14-Jul-14 5:44
Ambertje14-Jul-14 5:44 
Hello everyone,

I'm trying to understand this function.
Someone wrote this piece of code and I would like to use to do something simular.

On a daily basis we read .txt files into our SQL database through SSIS.
The data that's going through is growing fast and takes a long time to process. (for example a year of data is read every day into the db)

I want to make a dayset so that we only read one single day into the DB on top of the existing data and not the whole year.

Someone wrote this peace of code:

SQL
Select *     , ROW_NUMBER() OVER (PARTITION BY PK_Assignment ORDER BY DATE, TIME) as LineNbr
from ProductivityColliDagSet


I was wondering what the Partition By statement means.
My guess was that you have to place the fields there that makes the record unique.

Can someone help me out with this because I read so many things on the internet and still I don't understand.

Also I don't have much experience with SQL, just the basics.

Ambertje
AnswerRe: OVER (PARTITION BY ORDER BY ) Pin
PIEBALDconsult14-Jul-14 6:13
professionalPIEBALDconsult14-Jul-14 6:13 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
Ambertje14-Jul-14 6:15
Ambertje14-Jul-14 6:15 
AnswerRe: OVER (PARTITION BY ORDER BY ) Pin
Eddy Vluggen14-Jul-14 6:27
professionalEddy Vluggen14-Jul-14 6:27 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
PIEBALDconsult14-Jul-14 6:29
professionalPIEBALDconsult14-Jul-14 6:29 
QuestionRe: OVER (PARTITION BY ORDER BY ) Pin
Eddy Vluggen14-Jul-14 8:47
professionalEddy Vluggen14-Jul-14 8:47 
AnswerRe: OVER (PARTITION BY ORDER BY ) Pin
Jörgen Andersson14-Jul-14 9:33
professionalJörgen Andersson14-Jul-14 9:33 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
Mycroft Holmes14-Jul-14 13:54
professionalMycroft Holmes14-Jul-14 13:54 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
Jörgen Andersson14-Jul-14 23:20
professionalJörgen Andersson14-Jul-14 23:20 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
Ambertje14-Jul-14 23:12
Ambertje14-Jul-14 23:12 
AnswerRe: OVER (PARTITION BY ORDER BY ) Pin
jschell14-Jul-14 11:07
jschell14-Jul-14 11:07 
AnswerRe: OVER (PARTITION BY ORDER BY ) Pin
GuyThiebaut14-Jul-14 22:33
professionalGuyThiebaut14-Jul-14 22:33 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
Ambertje14-Jul-14 23:13
Ambertje14-Jul-14 23:13 
QuestionError: Can't delete row or update row in SQL Server ? Pin
taibc11-Jul-14 19:29
taibc11-Jul-14 19:29 
AnswerRe: Error: Can't delete row or update row in SQL Server ? Pin
Mycroft Holmes12-Jul-14 0:32
professionalMycroft Holmes12-Jul-14 0:32 
GeneralRe: Error: Can't delete row or update row in SQL Server ? Pin
taibc13-Jul-14 21:36
taibc13-Jul-14 21:36 
GeneralRe: Error: Can't delete row or update row in SQL Server ? Pin
Mycroft Holmes13-Jul-14 22:06
professionalMycroft Holmes13-Jul-14 22:06 
AnswerRe: Error: Can't delete row or update row in SQL Server ? Pin
ZurdoDev14-Jul-14 11:14
professionalZurdoDev14-Jul-14 11:14 

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.