Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dragan123
Starting Member
3 Posts |
 Posted - 2015-03-22 : 13:39:31
|
| PLEASE HELP TO CONVERT SQL ACCESS TO SQL SERVER PLEASE I HAVE THIS IN ACCESS BELLOW I NEED TO CONVERT TO SQL SERVER TRANSFORM First(Eval1to4.answer) AS FirstOfanswer SELECT Eval1to4.evalOid, Membershiptypemap.mappedvalue as membership, First(Eval1to4.answer) AS [Total Of answer] FROM (Members RIGHT JOIN (Eval1to4 LEFT JOIN Orders ON Eval1to4.evalOid = Orders.oid) ON Members.CID = Orders.cid) LEFT JOIN MembershipTypeMap ON (Members.MembershipStatus = MembershipTypeMap.membershipstatus) AND (Members.Membership = MembershipTypeMap.membershiptype) WHERE Orders.program = 20141128 AND Eval1to4.evalProgID=20141128 GROUP BY Eval1to4.evalOid, Membershiptypemap.mappedvalue ORDER BY Lastname, Firstname PIVOT Eval1to4.questionID |
|
|
ms115
Starting Member
5 Posts |
Posted - 2015-03-24 : 09:44:26
|
| why not migrate the whole access database to sql server |
 |
|
|
|
|
|
convert access to sql server