if you look at the original post its 7 int values - so we don't need to worry about . - e etc

this looks right to me

select a.Prescription_id,count(distinct b.id) from tbl_prescription_dates a

inner join tbl_prescription_dates b

on a.Prescription_id=b.Prescription_id

and a.Date_Issued >= dateadd(dd,-2,b.Date_Issued)

and a.Date_Issued <=dateadd(dd,+2,b.Date_Issued)

and a.idb.id

group by a.Prescription_id

but i needed the...

another problem here is that if you look at the 1st 4 rows of data (numbered 1 - 4)

1 was within 2 days of 2 & 3

2 was within 2...

i had a go at this and ran out of time

but you need to add an identity to your table definition so you don't match a row with itself

CREATE table...

isnumeric(right(myfield,7))

or if it's not always 7 digits

isnumeric(substring(myfield,3,7) )

we have similar issues, but not on that scale - normally we can get about 10,000 pages out in about 20 minutes. - but we always render to pdf or...

or why not convert it to SQL express??????

you say it's access - is it an ADP (access data project)? or a standard access file.

if you convert to an adp file you can use stored procs to...

sql i beleive

ok,

this is a very big topic

it really depends on who you are, what you are doing, how much risk you are prepared to take.

In any decent environment your...

i've seen a few similar issues posted, and microsoft allege that is as a result of an incomplete or failed service pack or hotfix installation

try reinstalling the last service pack/hotfix,...

have you coded an sql account and password into the data source of the report, or are you relying on the execution account.

i suggest creating a SQL account and convert...

apologies - misread the question - saw the rowcount and assumed it was a while loop - ignore me - i need more coffee:-D

the first may give you more problems - since the total duration of the loop is potentially very long, you may update records that have been modified since you started...

ok - so you are using either dynamic sql (a bad thing) or you are building your sql string in your app(a bad thing)

i can't tell which from the post

but...