If this is random sampling I would rather use ORDER BY NEWID() than ORDER BY [date], as you've mentioned in your first posting in this thread.

Just my $0.02

Hey, I didn't say it's efficient  The first suggestion is ANSI SQL, I think ...

But a quick look at...

As I've said, use a calendar table.

Hi Dave,

long time no see!

...or to put it Remi's way

Select

 id

 , name

from dbo.SysObjects O1

where (Select count(*) from dbo.SysObjects O2 where O2.id <= O1.id) % 4 = 0 order by id

Wasn't the question how to get every 4th row?

SELECT S1.id , S1.name

FROM dbo.sysobjects AS S1, dbo.sysobjects AS S2

WHERE S2.id <= S1.id

GROUP BY S1.id, S1.name

HAVING COUNT(*)%4=0

ORDER BY S1.id

See if this helps: http://www.aspfaq.com/show.asp?id=2519

Did I ever mention that I really hate it, when you guys use colloquial language that I can't find in my online dictionary....

That was neither an accusation nor meant offending.

I was just implying from your comment a guy falling senseless at my feet within the...

If it needs to be dynamic sql, put everything in one string and execute this. Something along these lines:

DECLARE @stmt NCHAR(1000)

SET @stmt = 'USE Frank_3 '

 + CHAR(13) +

 'DECLARE...

You're a lady?

Äh women, female...What word do I use in this context?

Probably something like this?

set dateformat dmy

create table #t

(

 customer varchar(4)

 , accountcode  int

 , dt datetime

 , debit float

 , credit float

)

insert into #t

select 'AUBM', 600000, '01/12/2004', 10, 0

union all

select 'AUBM', 700000, '01/12/2004', 0,...

http://www.microsoft.com/downloads/details.aspx?FamilyID=a6f79cb1-a420-445f-8a4b-bd77a7da194b&DisplayLang=en

Also, in your Microsoft SQL Server program group you'll find an item "Enterprise Manager". This is a GUI admin tool that easily will get you started. Do a search...

To add to Chris. I think this is just the default behaviour of the Access Upsizing wizard.

See if this helps: http://www.sommarskog.se/dyn-search.html

Have a look at sp_changeobjectowner in BOL. I would also bet, you'll find something useful in the script section here.