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:40:53
|
| please help me I need to convert this from access to sql server please help me 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 |
|
|
|
|
|
CONVERT sql from access to sql