T-SQL 1

[abdhab]

hi
i am trying to use a t-sql command in access, i know nothing about jet sql
my command is:

declare @counter int
set @counter = 1
while @counter <= (select count(*) from dbo_employees)
begin
insert into dbo_fup(eid, fdate) values(@counter, '12/10/06')
set @counter = @counter + 1
end

but somehow it is not working.. will it work if i convert it to jet sql? if yes, can some1 convert it please?

 

[Ed2020]

You cab't do this in Jet SQL - unfortunately it's nowhere near as powerful/flexible as other implementations of the SQL standard.

Somebody here may be able to show how this can be done in Jet SQL (my SQL isn't great), but personally I'd do it in VBA.

Ed Metcalfe.

Please do not feed the trolls.....

 

[r937]

declare your dbo_fup table with eid defined as an autonumber

then run this query:

insert 
  into dbo_fup 
     ( fdate )
select #2006-12-10#
  from dbo_employees

simple, yes ;-)

r937.com | rudy.ca

 

[abdhab]

thank you for your quick reply guys.
r937, your code works fine if dbo_fup is empty, in addition i need eid set to be equal from 1 to X each time i use the insert code, so i cannot leave eid as autonumber

 

[abdhab]

ok guys, i just did a few modification in the code:

insert 
  into dbo_fup 
     ( fdate, eid )
select #2006-12-10#, eid
  from dbo_employees

it works fine now
thank you