query using the record number

happy friday...
my table has 200,000 + records and I want to see the particular record which I think it is causing the problem.
How could i query 195,203rd record?
thank you, yanorooWhat problem is it causing? How did you figure out the number to begin with?|||What problem is it causing? How did you figure out the number to begin with?

oh, the record number is just an example.
actual case is -I ran dts package to import data from txt file to sql table.
The dts truncated the table and imported the records correctly (218503 record) but I can't find the data from 208775th record on the table...
I want to see the what was populated into the table from 208775th record.
And strange thing is the table has 237043 record (which is more than input)|||are you getting 237043 by doing a count(*) on the table?|||are you getting 237043 by doing a count(*) on the table?
yes, it is by count(*) on the table.|||If you are just debugging the process, then temporarily create an incrementing identity column on the table.|||If you are just debugging the process, then temporarily create an incrementing identity column on the table.

Hello,

Found out the problem was DTS prod installation error.
Thank you anyway for your suggestion.
Yanoroo|||i suggest in a situation like this to create a staging table when you transfer large amounts of data to an sql server. this way you can set the error count high and allow sql server to leave the rows causing the error in the staging table while you move the clean data to the final destination. you can then have the dts send you an email notifying you of the prob and you can clean those rows in the morning.

go to www.SQLDts.com|||I assume there is an unique field named pid in your table and you are looking for a particular record of pid(in this case 195,203rd).You can try this query--

select * from mytable where pid not in
(select top 195,202 pid from mytable)

If you have any other type of requirement that can be solved too.
Subhasish

q; Compare Two Dates

I need to compare tow dates DateField1 and DateField2 and find number of
hours between these two dates. Then I need to deduct non-business days and
hours (Business days: Monday-Friday and Business Hours: 7:00am-7:00pm) from
this and find net hours. How can I do this?
Hello,
Take a look into DATEDIFF function
Thanks
Hari
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:37184CE4-A112-4034-B464-59909C0FAB2A@.microsoft.com...
>I need to compare tow dates DateField1 and DateField2 and find number of
> hours between these two dates. Then I need to deduct non-business days and
> hours (Business days: Monday-Friday and Business Hours: 7:00am-7:00pm)
> from
> this and find net hours. How can I do this?

q; Compare Two Dates

I need to compare tow dates DateField1 and DateField2 and find number of
hours between these two dates. Then I need to deduct non-business days and
hours (Business days: Monday-Friday and Business Hours: 7:00am-7:00pm) from
this and find net hours. How can I do this?Hello,
Take a look into DATEDIFF function
Thanks
Hari
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:37184CE4-A112-4034-B464-59909C0FAB2A@.microsoft.com...
>I need to compare tow dates DateField1 and DateField2 and find number of
> hours between these two dates. Then I need to deduct non-business days and
> hours (Business days: Monday-Friday and Business Hours: 7:00am-7:00pm)
> from
> this and find net hours. How can I do this?

q; Compare Two Dates

I need to compare tow dates DateField1 and DateField2 and find number of
hours between these two dates. Then I need to deduct non-business days and
hours (Business days: Monday-Friday and Business Hours: 7:00am-7:00pm) from
this and find net hours. How can I do this?Hello,
Take a look into DATEDIFF function
Thanks
Hari
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:37184CE4-A112-4034-B464-59909C0FAB2A@.microsoft.com...
>I need to compare tow dates DateField1 and DateField2 and find number of
> hours between these two dates. Then I need to deduct non-business days and
> hours (Business days: Monday-Friday and Business Hours: 7:00am-7:00pm)
> from
> this and find net hours. How can I do this?

Q: Reset page number

Hello,
In the footer of my report I use â'Page of Pagesâ', now I need to reset this
number each time I need to go to next page through page navigation button in
the ReportViewer. Right now it shows total number of pages in the report.
Thanks,These are 2 different properties, does this not work?
=Globals.PageNumber & " of " & Globals.TotalPages
See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_7ilv.asp?frame=true.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:7B5E05A8-28D8-405A-A096-880D7811312D@.microsoft.com...
> Hello,
> In the footer of my report I use "Page of Pages", now I need to reset this
> number each time I need to go to next page through page navigation button
> in
> the ReportViewer. Right now it shows total number of pages in the report.
> Thanks,
>|||Hi Brian,
Thanks for the reply. Here is my problem related to page number in reporting
services. Let say I am printing a report that goes different companies, what
you would do is that you can run report per company and your page numbers
would be fine. However if you run your report for all companies and send
different pages to different companies, in this case your current and total
page number is actually not correct, unless you reset it each time you are on
a new company. How can I do this?
"Brian Welcker [MSFT]" wrote:
> These are 2 different properties, does this not work?
> =Globals.PageNumber & " of " & Globals.TotalPages
> See
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_7ilv.asp?frame=true.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:7B5E05A8-28D8-405A-A096-880D7811312D@.microsoft.com...
> > Hello,
> > In the footer of my report I use "Page of Pages", now I need to reset this
> > number each time I need to go to next page through page navigation button
> > in
> > the ReportViewer. Right now it shows total number of pages in the report.
> > Thanks,
> >
>
>|||On Mon, 10 Oct 2005 07:05:33 -0500,
shiming927@.gmail-dot-com.no-spam.invalid (shiming927) wrote:
>thx
Hi,
At least as it appears in my newsreader, you have started a new
thread, with no link to the assumed earlier question.
I suggest you either repost your question (assuming you haven't had a
reply) or add meaningful information here. Reposting the question with
a clear title is probably the best option.
Andrew Watt
MVP - InfoPath