Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kirank
Yak Posting Veteran
58 Posts |
 Posted - 2014-06-03 : 17:23:39
|
| I have around 2Million data, i wanted to populate some amount of that then perform some operation after that again call SP/query which will again populate next period of data.could you guys can help me, how i can work with this approch. coz i cant populate entire data into dataset/page and make application slower.please help me on below query.1. I have createdate column in my table , base on that can i find the min and max year2.using this year, can i split my result ( i mean results from 2001-2004) somehting kind of ?3. if so then how i can put this logic ??Thanks for your time & appreciate your help!---------------------------http://codingstuffsbykiran.blogspot.com | http://webdevlopementhelp.blogspot.com |
|
|
sunder.bugatha
Yak Posting Veteran
66 Posts |
Posted - 2014-06-04 : 08:08:27
|
| Create an SSIS package with data flow task having years as two parameters and keep it in a loop.Hema Sunder |
 |
|
|
kirank
Yak Posting Veteran
58 Posts |
Posted - 2014-06-04 : 10:45:12
|
| sorry, I need to implement it through coding, I can't use any package (SSIS)thanks,---------------------------http://codingstuffsbykiran.blogspot.com | http://webdevlopementhelp.blogspot.com |
|
|
|
kirank
Yak Posting Veteran
58 Posts |
|
|
kirank
Yak Posting Veteran
58 Posts |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-06-06 : 17:32:31
|
I'm not clear on the requirement. Are you trying to copy data from one table to another in blocks? By date?
Too often we enjoy the comfort of opinion without the discomfort of thought. - John F. Kennedy |
|
|
|
|
|
|
best way to populate result