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
Maneesh A N
NA
179
108.3k
full outer join?
Sep 23 2014 2:19 AM
hi,
please give answer
CREATE PROCEDURE Prcexpincview
(
@month varchar(50),
@year varchar(50)
)
as
SELECT tblexpense.expname,tblexpense.expamount,tblpayments.vpayment
FROM dnalabsoft.tblexpense FULL OUTER JOIN
dnalabsoft.tblpayments ON dnalabsoft.tblexpense.ipaymentid = dnalabsoft.tblpayments.ipaymentid
where month(dbilldate)=@month and year(dbilldate)=@year group by expname
Error Occured
Msg 209, Level 16, State 1, Procedure Prcexpincview, Line 11
Ambiguous column name 'dbilldate'.
Msg 209, Level 16, State 1, Procedure Prcexpincview, Line 11
Ambiguous column name 'dbilldate'.
Reply
Answers (
8
)
how to set design of form permanently
How to iterate throught the checkboc in accordion pane in as