Re: MS SQL to MySQL select

2008-06-16 Thread SenTnel
Thanks Martijn! That I understood, sorry I wasn't clear enough, I was more confused about the "TOP 100 PERCENT" and this was a bad example anyways, but after posting I did some deeper research and found an excellent migration white paper describing this type of expressions and mysql counterparts.

Re: MS SQL to MySQL select

2008-06-15 Thread Martijn Tonies
Hey, > In order for me to achive the goal of migrating a MS SQL based application > to web based php / mysql I need to understand a little bit MS SQL syntax and > MySQL counterpart expression. If is not too much to ask one of you guys > could "translate" this MS SQL select to MySQL? Here's the cha