conver from access to sql server

• draganl2000

  SSC Rookie

  Points: 37

  More actions

  March 22, 2015 at 9:39 pm

  #296181

  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

• Kedazs

  SSC Veteran

  Points: 267

  More actions

  March 25, 2015 at 5:21 am

  #1786224

  Hello,

  Are the tables in access imported into a sql server instance? Access sql likes to put a lot of unnecessary '(' in code.