Can we distribute MSDE2000A.exe?

The MSDE redistribution agreement is unclear (to me). It talks about
redistributing specific parts of MSDE. I just want to put the whole
MSDE2000A.exe setup program on a CD with my app's setup program. Is that
allowed?
Thanks!
J.
hi,
Process Patrol wrote:
> The MSDE redistribution agreement is unclear (to me). It talks about
> redistributing specific parts of MSDE. I just want to put the whole
> MSDE2000A.exe setup program on a CD with my app's setup program. Is
> that allowed?
yes... you only have to (freely) register for distributions rights at
http://www.microsoft.com/sql/msde/ho...stregister.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

Can somone help with this SQL query

Hi people,

I wasn't sure where to post this, it's a specific SQL syntax type problem, and didn't know where it should go. Sorry if there's a better place for it!

I want to update table 'Pupils' with some data from table 'TempAttendance'. I have an id number in the temp table that matches up with the pupil's id number in the proper 'Pupils' table.

I've tried loads, but I'm struggling!

So I want to update table Pupils.attendance with the value from TempAttendance.attendance where the ID = the ID. I can't get the syntax right. Pleas help if you can!

Thanks

update pupils set attendance = (select attendance from TempAttendance where pupils.ID = TempAttendance.ID);

May sure you get only 1 record for each pupil.ID = TempAttendance.ID.

|||

s_kushal answer is my answer.Plz check out

Thank u

Baba

Please remember to click "Mark as Answer" on this post if it helped you.

|||

thanks for the efforts guys but I worked it out before this was moderated and posted!

kushal I already tried that and it didn't work.

This is what worked:

UPDATE tbl_pupils
SET ppl_attendance =
(SELECT Attendance
FROM dataget.TempAttendance
WHERE dataget.TempAttendance.adno = tbl_pupils.ppl_adno)
WHERE EXISTS
(SELECT Attendance
FROM dataget.TempAttendance
WHERE dataget.TempAttendance.adno = tbl_pupils.ppl_adno)

Thanks for helping anyway