TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Saravanan Ponnusamy
363
4.5k
1.1m
MSSQL Query to MySQL Query
Aug 16 2019 10:28 PM
can anyone pls. convert the following MSSQL Query to MySQL Query...
SELECT tbl_use.fld_use_id AS UseID,
( SELECT CAST( endar.fld_endars_id AS VARCHAR(8000) ) + ISNULL(','+ STUFF(( SELECT ',' + CAST( fld_endars_id AS VARCHAR(8000) ) FROM tbl_endars
INNER JOIN tbl_endar_lca AS endar_LCA ON fld_endar_lca_endars_id = fld_endars_id
WHERE endar_LCA.fld_endar_lca_use_id = 1 AND endar_LCA.fld_endar_lca_privilege >= 4
FOR XML PATH( '' ) ), 1, 1, '' ),'') ) AS endarID,
tbl_use.fld_use_ail AS Useail
FROM tbl_endars as endar
LEFT JOIN tbl_use ON endar.fld_endars_owner_id = tbl_use.fld_use_id
WHERE (tbl_use.fld_use_isive='true' AND tbl_use.fld_use_event = 'true' AND tbl_use.fld_use_anch_id IN ( '15430235434543' )) ORDER BY tbl_use.fld_use_anch_id
its urgent..
thanks in advance ..
Reply
Answers (
3
)
How to Remote Access Database using static ip
How to disable strict_trans_table in cpanel?