I'am hoping someone can tell me if this is true. We are looking to setup a web server running Windows Standard Edtion with MS SQL 2005 WorkGroup (cpu license). I've been told my MS sales reps that in order to have a ASP/.Net based website that allows people to login (similiar to a hotmail, yahoo...
This has worked for years in Access
UPDATE tbl_keeplist2
LEFT JOIN tbl_keeplist2_daily ON
tbl_keeplist2.ID = tbl_keeplist2_daily.ID
SET tbl_keeplist2.status = 'D'
WHERE tbl_keeplist2_daily.status = 'P'
OR tbl_keeplist2_daily.ID Is Null
But no luck in SQL 7 I get the following...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.