How does SQL handle data retrieval from a specific record? I want to be able
to capture 100 records from any given point in a table by sending a single
column value as a starting point.
So if I have a table with primary_key with values 1-1000 and I want to get
1-100 I can use TOP 100. If I then want 101 - 200, 201 - 300, etc, how can I
get the set(s)?
Can this be done?
Thank you,
AnthonyUse WHERE clause.
declare @.i int, @.j int
set @.i = 201
set @.j = 300
...
where pk_col between @.i and @.j;
AMB
"Anthony W DiGrigoli" wrote:
> How does SQL handle data retrieval from a specific record? I want to be ab
le
> to capture 100 records from any given point in a table by sending a single
> column value as a starting point.
> So if I have a table with primary_key with values 1-1000 and I want to get
> 1-100 I can use TOP 100. If I then want 101 - 200, 201 - 300, etc, how can
I
> get the set(s)?
> Can this be done?
> Thank you,
> Anthony
Showing posts with label handle. Show all posts
Showing posts with label handle. Show all posts
Thursday, March 22, 2012
Thursday, March 8, 2012
Data Model Question
I posted to programming but thought maybe this is a btter group:
There may be some tools out there already developed that can handle this but
I haven't had success in finding them.
Essentially what I am trying to do is create a data model that can
accomodate the creation of a variety of forms to be filled out.
The end user should be able to create a question and select what type of
answer it will bne, multi select, checkbox, radio box, free text. Provide
the possible answers if needed. And then allow the form to be filled out
and the responses saved.
That part shouldn't be too tough. Forms may need to be able to be related
to other forms or multiple forms could make up 1 form to fill out. Like
form A and D.
If there is something like this already I don't want to reinvent the wheel.
Also if someone has experience with this type of model has it been good or
bad.
Thanks.You had one response. Was that not helpful? There are also some posts from
Janmar on a similar topic. Did you read those posts?|||A response in this group or the programming one? I didn't see any.
"Scott Morris" <bogus@.bogus.com> wrote in message
news:ucBrV62lFHA.3300@.TK2MSFTNGP15.phx.gbl...
> You had one response. Was that not helpful? There are also some posts
> from
> Janmar on a similar topic. Did you read those posts?
>
There may be some tools out there already developed that can handle this but
I haven't had success in finding them.
Essentially what I am trying to do is create a data model that can
accomodate the creation of a variety of forms to be filled out.
The end user should be able to create a question and select what type of
answer it will bne, multi select, checkbox, radio box, free text. Provide
the possible answers if needed. And then allow the form to be filled out
and the responses saved.
That part shouldn't be too tough. Forms may need to be able to be related
to other forms or multiple forms could make up 1 form to fill out. Like
form A and D.
If there is something like this already I don't want to reinvent the wheel.
Also if someone has experience with this type of model has it been good or
bad.
Thanks.You had one response. Was that not helpful? There are also some posts from
Janmar on a similar topic. Did you read those posts?|||A response in this group or the programming one? I didn't see any.
"Scott Morris" <bogus@.bogus.com> wrote in message
news:ucBrV62lFHA.3300@.TK2MSFTNGP15.phx.gbl...
> You had one response. Was that not helpful? There are also some posts
> from
> Janmar on a similar topic. Did you read those posts?
>
Data Model Question
I posted to programming but thought maybe this is a btter group:
There may be some tools out there already developed that can handle this but
I haven't had success in finding them.
Essentially what I am trying to do is create a data model that can
accomodate the creation of a variety of forms to be filled out.
The end user should be able to create a question and select what type of
answer it will bne, multi select, checkbox, radio box, free text. Provide
the possible answers if needed. And then allow the form to be filled out
and the responses saved.
That part shouldn't be too tough. Forms may need to be able to be related
to other forms or multiple forms could make up 1 form to fill out. Like
form A and D.
If there is something like this already I don't want to reinvent the wheel.
Also if someone has experience with this type of model has it been good or
bad.
Thanks.
You had one response. Was that not helpful? There are also some posts from
Janmar on a similar topic. Did you read those posts?
|||A response in this group or the programming one? I didn't see any.
"Scott Morris" <bogus@.bogus.com> wrote in message
news:ucBrV62lFHA.3300@.TK2MSFTNGP15.phx.gbl...
> You had one response. Was that not helpful? There are also some posts
> from
> Janmar on a similar topic. Did you read those posts?
>
There may be some tools out there already developed that can handle this but
I haven't had success in finding them.
Essentially what I am trying to do is create a data model that can
accomodate the creation of a variety of forms to be filled out.
The end user should be able to create a question and select what type of
answer it will bne, multi select, checkbox, radio box, free text. Provide
the possible answers if needed. And then allow the form to be filled out
and the responses saved.
That part shouldn't be too tough. Forms may need to be able to be related
to other forms or multiple forms could make up 1 form to fill out. Like
form A and D.
If there is something like this already I don't want to reinvent the wheel.
Also if someone has experience with this type of model has it been good or
bad.
Thanks.
You had one response. Was that not helpful? There are also some posts from
Janmar on a similar topic. Did you read those posts?
|||A response in this group or the programming one? I didn't see any.
"Scott Morris" <bogus@.bogus.com> wrote in message
news:ucBrV62lFHA.3300@.TK2MSFTNGP15.phx.gbl...
> You had one response. Was that not helpful? There are also some posts
> from
> Janmar on a similar topic. Did you read those posts?
>
Data Model Question
I posted to programming but thought maybe this is a btter group:
There may be some tools out there already developed that can handle this but
I haven't had success in finding them.
Essentially what I am trying to do is create a data model that can
accomodate the creation of a variety of forms to be filled out.
The end user should be able to create a question and select what type of
answer it will bne, multi select, checkbox, radio box, free text. Provide
the possible answers if needed. And then allow the form to be filled out
and the responses saved.
That part shouldn't be too tough. Forms may need to be able to be related
to other forms or multiple forms could make up 1 form to fill out. Like
form A and D.
If there is something like this already I don't want to reinvent the wheel.
Also if someone has experience with this type of model has it been good or
bad.
Thanks.You had one response. Was that not helpful? There are also some posts from
Janmar on a similar topic. Did you read those posts?|||A response in this group or the programming one? I didn't see any.
"Scott Morris" <bogus@.bogus.com> wrote in message
news:ucBrV62lFHA.3300@.TK2MSFTNGP15.phx.gbl...
> You had one response. Was that not helpful? There are also some posts
> from
> Janmar on a similar topic. Did you read those posts?
>
There may be some tools out there already developed that can handle this but
I haven't had success in finding them.
Essentially what I am trying to do is create a data model that can
accomodate the creation of a variety of forms to be filled out.
The end user should be able to create a question and select what type of
answer it will bne, multi select, checkbox, radio box, free text. Provide
the possible answers if needed. And then allow the form to be filled out
and the responses saved.
That part shouldn't be too tough. Forms may need to be able to be related
to other forms or multiple forms could make up 1 form to fill out. Like
form A and D.
If there is something like this already I don't want to reinvent the wheel.
Also if someone has experience with this type of model has it been good or
bad.
Thanks.You had one response. Was that not helpful? There are also some posts from
Janmar on a similar topic. Did you read those posts?|||A response in this group or the programming one? I didn't see any.
"Scott Morris" <bogus@.bogus.com> wrote in message
news:ucBrV62lFHA.3300@.TK2MSFTNGP15.phx.gbl...
> You had one response. Was that not helpful? There are also some posts
> from
> Janmar on a similar topic. Did you read those posts?
>
Data Model Help
There may be some tools out there already developed that can handle this but
I haven't had success in finding them.
Essentially what I am trying to do is create a data model that can
accomodate the creation of a variety of forms to be filled out.
The end user should be able to create a question and select what type of
answer it will bne, multi select, checkbox, radio box, free text. Provide
the possible answers if needed. And then allow the form to be filled out
and the responses saved.
That part shouldn't be too tough. Forms may need to be able to be related
to other forms or multiple forms could make up 1 form to fill out. Like
form A and D.
If there is something like this already I don't want to reinvent the wheel.
Also if someone has experience with this type of model has it been good or
bad.
Thanks.Hi
http://www.databaseanswers.org/data_models/ may be of help
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Brian" <brian@.nospam.com> wrote in message
news:%23Kbg6XflFHA.2180@.TK2MSFTNGP15.phx.gbl...
> There may be some tools out there already developed that can handle this
> but
> I haven't had success in finding them.
> Essentially what I am trying to do is create a data model that can
> accomodate the creation of a variety of forms to be filled out.
> The end user should be able to create a question and select what type of
> answer it will bne, multi select, checkbox, radio box, free text. Provide
> the possible answers if needed. And then allow the form to be filled out
> and the responses saved.
> That part shouldn't be too tough. Forms may need to be able to be related
> to other forms or multiple forms could make up 1 form to fill out. Like
> form A and D.
> If there is something like this already I don't want to reinvent the
> wheel.
> Also if someone has experience with this type of model has it been good or
> bad.
> Thanks.
>
I haven't had success in finding them.
Essentially what I am trying to do is create a data model that can
accomodate the creation of a variety of forms to be filled out.
The end user should be able to create a question and select what type of
answer it will bne, multi select, checkbox, radio box, free text. Provide
the possible answers if needed. And then allow the form to be filled out
and the responses saved.
That part shouldn't be too tough. Forms may need to be able to be related
to other forms or multiple forms could make up 1 form to fill out. Like
form A and D.
If there is something like this already I don't want to reinvent the wheel.
Also if someone has experience with this type of model has it been good or
bad.
Thanks.Hi
http://www.databaseanswers.org/data_models/ may be of help
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Brian" <brian@.nospam.com> wrote in message
news:%23Kbg6XflFHA.2180@.TK2MSFTNGP15.phx.gbl...
> There may be some tools out there already developed that can handle this
> but
> I haven't had success in finding them.
> Essentially what I am trying to do is create a data model that can
> accomodate the creation of a variety of forms to be filled out.
> The end user should be able to create a question and select what type of
> answer it will bne, multi select, checkbox, radio box, free text. Provide
> the possible answers if needed. And then allow the form to be filled out
> and the responses saved.
> That part shouldn't be too tough. Forms may need to be able to be related
> to other forms or multiple forms could make up 1 form to fill out. Like
> form A and D.
> If there is something like this already I don't want to reinvent the
> wheel.
> Also if someone has experience with this type of model has it been good or
> bad.
> Thanks.
>
Tuesday, February 14, 2012
Data Flow Tasks - SSIS
I am using Recordset destination for SSIS. Flat file destination will
not work and Excel destination can not handle more that 65k rows and I
don't want to send my output to the server. Therefore after doing a
Merge join I want to view the results and Recordset seemed to be a
valid choice. The problem is how do I view the output? For other
components sometimes there are preview option. However this preview is
not consistent for all steps in the data flow tasks and sometimes
missing. My question is there any way to preview the Recordset
destination? Thanks.On May 25, 11:38 am, SB <othell...@.yahoo.com> wrote:
> I am using Recordset destination for SSIS. Flat file destination will
> not work and Excel destination can not handle more that 65k rows and I
> don't want to send my output to the server. Therefore after doing a
> Merge join I want to view the results and Recordset seemed to be a
> valid choice. The problem is how do I view the output? For other
> components sometimes there are preview option. However this preview is
> not consistent for all steps in the data flow tasks and sometimes
> missing. My question is there any way to preview the Recordset
> destination? Thanks.
Okay, instead of Recordset I have used DataReaderDestination and
created a Grid viewer to view the data. The problem is, it is very
slow and hangs after processing 96k out of 396k of records. (This is
one simple update involving a 2 table join that I can do in seconds in
the server) It is taking hours to develop the package and when it did
come back it is only showing 9k out of 396k of data in the grid. How
do I see all the data? I have tried attach/detach but still can't seem
to view all the data! How do I view all the data in the grid? Thanks.
not work and Excel destination can not handle more that 65k rows and I
don't want to send my output to the server. Therefore after doing a
Merge join I want to view the results and Recordset seemed to be a
valid choice. The problem is how do I view the output? For other
components sometimes there are preview option. However this preview is
not consistent for all steps in the data flow tasks and sometimes
missing. My question is there any way to preview the Recordset
destination? Thanks.On May 25, 11:38 am, SB <othell...@.yahoo.com> wrote:
> I am using Recordset destination for SSIS. Flat file destination will
> not work and Excel destination can not handle more that 65k rows and I
> don't want to send my output to the server. Therefore after doing a
> Merge join I want to view the results and Recordset seemed to be a
> valid choice. The problem is how do I view the output? For other
> components sometimes there are preview option. However this preview is
> not consistent for all steps in the data flow tasks and sometimes
> missing. My question is there any way to preview the Recordset
> destination? Thanks.
Okay, instead of Recordset I have used DataReaderDestination and
created a Grid viewer to view the data. The problem is, it is very
slow and hangs after processing 96k out of 396k of records. (This is
one simple update involving a 2 table join that I can do in seconds in
the server) It is taking hours to develop the package and when it did
come back it is only showing 9k out of 396k of data in the grid. How
do I see all the data? I have tried attach/detach but still can't seem
to view all the data! How do I view all the data in the grid? Thanks.
Data Flow Tasks - SSIS
I am using Recordset destination for SSIS. Flat file destination will
not work and Excel destination can not handle more that 65k rows and I
don't want to send my output to the server. Therefore after doing a
Merge join I want to view the results and Recordset seemed to be a
valid choice. The problem is how do I view the output? For other
components sometimes there are preview option. However this preview is
not consistent for all steps in the data flow tasks and sometimes
missing. My question is there any way to preview the Recordset
destination? Thanks.
On May 25, 11:38 am, SB <othell...@.yahoo.com> wrote:
> I am using Recordset destination for SSIS. Flat file destination will
> not work and Excel destination can not handle more that 65k rows and I
> don't want to send my output to the server. Therefore after doing a
> Merge join I want to view the results and Recordset seemed to be a
> valid choice. The problem is how do I view the output? For other
> components sometimes there are preview option. However this preview is
> not consistent for all steps in the data flow tasks and sometimes
> missing. My question is there any way to preview the Recordset
> destination? Thanks.
Okay, instead of Recordset I have used DataReaderDestination and
created a Grid viewer to view the data. The problem is, it is very
slow and hangs after processing 96k out of 396k of records. (This is
one simple update involving a 2 table join that I can do in seconds in
the server) It is taking hours to develop the package and when it did
come back it is only showing 9k out of 396k of data in the grid. How
do I see all the data? I have tried attach/detach but still can't seem
to view all the data! How do I view all the data in the grid? Thanks.
not work and Excel destination can not handle more that 65k rows and I
don't want to send my output to the server. Therefore after doing a
Merge join I want to view the results and Recordset seemed to be a
valid choice. The problem is how do I view the output? For other
components sometimes there are preview option. However this preview is
not consistent for all steps in the data flow tasks and sometimes
missing. My question is there any way to preview the Recordset
destination? Thanks.
On May 25, 11:38 am, SB <othell...@.yahoo.com> wrote:
> I am using Recordset destination for SSIS. Flat file destination will
> not work and Excel destination can not handle more that 65k rows and I
> don't want to send my output to the server. Therefore after doing a
> Merge join I want to view the results and Recordset seemed to be a
> valid choice. The problem is how do I view the output? For other
> components sometimes there are preview option. However this preview is
> not consistent for all steps in the data flow tasks and sometimes
> missing. My question is there any way to preview the Recordset
> destination? Thanks.
Okay, instead of Recordset I have used DataReaderDestination and
created a Grid viewer to view the data. The problem is, it is very
slow and hangs after processing 96k out of 396k of records. (This is
one simple update involving a 2 table join that I can do in seconds in
the server) It is taking hours to develop the package and when it did
come back it is only showing 9k out of 396k of data in the grid. How
do I see all the data? I have tried attach/detach but still can't seem
to view all the data! How do I view all the data in the grid? Thanks.
Data Flow Tasks - SSIS
I am using Recordset destination for SSIS. Flat file destination will
not work and Excel destination can not handle more that 65k rows and I
don't want to send my output to the server. Therefore after doing a
Merge join I want to view the results and Recordset seemed to be a
valid choice. The problem is how do I view the output? For other
components sometimes there are preview option. However this preview is
not consistent for all steps in the data flow tasks and sometimes
missing. My question is there any way to preview the Recordset
destination? Thanks.On May 25, 11:38 am, SB <othell...@.yahoo.com> wrote:
> I am using Recordset destination for SSIS. Flat file destination will
> not work and Excel destination can not handle more that 65k rows and I
> don't want to send my output to the server. Therefore after doing a
> Merge join I want to view the results and Recordset seemed to be a
> valid choice. The problem is how do I view the output? For other
> components sometimes there are preview option. However this preview is
> not consistent for all steps in the data flow tasks and sometimes
> missing. My question is there any way to preview the Recordset
> destination? Thanks.
Okay, instead of Recordset I have used DataReaderDestination and
created a Grid viewer to view the data. The problem is, it is very
slow and hangs after processing 96k out of 396k of records. (This is
one simple update involving a 2 table join that I can do in seconds in
the server) It is taking hours to develop the package and when it did
come back it is only showing 9k out of 396k of data in the grid. How
do I see all the data? I have tried attach/detach but still can't seem
to view all the data! How do I view all the data in the grid? Thanks.
not work and Excel destination can not handle more that 65k rows and I
don't want to send my output to the server. Therefore after doing a
Merge join I want to view the results and Recordset seemed to be a
valid choice. The problem is how do I view the output? For other
components sometimes there are preview option. However this preview is
not consistent for all steps in the data flow tasks and sometimes
missing. My question is there any way to preview the Recordset
destination? Thanks.On May 25, 11:38 am, SB <othell...@.yahoo.com> wrote:
> I am using Recordset destination for SSIS. Flat file destination will
> not work and Excel destination can not handle more that 65k rows and I
> don't want to send my output to the server. Therefore after doing a
> Merge join I want to view the results and Recordset seemed to be a
> valid choice. The problem is how do I view the output? For other
> components sometimes there are preview option. However this preview is
> not consistent for all steps in the data flow tasks and sometimes
> missing. My question is there any way to preview the Recordset
> destination? Thanks.
Okay, instead of Recordset I have used DataReaderDestination and
created a Grid viewer to view the data. The problem is, it is very
slow and hangs after processing 96k out of 396k of records. (This is
one simple update involving a 2 table join that I can do in seconds in
the server) It is taking hours to develop the package and when it did
come back it is only showing 9k out of 396k of data in the grid. How
do I see all the data? I have tried attach/detach but still can't seem
to view all the data! How do I view all the data in the grid? Thanks.
Subscribe to:
Posts (Atom)