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
Aseem Bhardwaj
1.3k
114
20.3k
getting error of <
Sep 30 2016 4:43 AM
SELECT Gledger.*,
CAST('' AS DECIMAL(5,0)) as sno ,
00000000000000.00 AS BALANCE ,
SPACE(5) AS DC ,
ISNULL(master.ma_AcName,'') as ma_AcName,
master.PK_ID
FROM Gledger LEFT JOIN master ON
Gledger.Gl_AcId = master.pk_id
WHERE gledger.Gl_AcId = <<THISFORM.ACID>>
and Gledger.Gl_Date between '<<m.lsdate>>' and '<<m.ledate>>'
and LEFT(Gledger.gl_voucher,2) <<m.ltyPe>>
and <<IIF(thisform.container1.check1.Value,'gledger.gl_voucher != "O"','1=1')>>
ORDER BY gledger.gl_date
this is my query please help and give me optimal solution.
Reply
Answers (
6
)
How to Sync values from one DB to another DB?
Is SnapShot Replication in sql server only take the image