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
Marvin Gapuz
NA
85
6.2k
Combining two select statement
Mar 4 2019 8:39 AM
USE [DBErpLST]
GO
/****** Object: StoredProcedure [dbo].[Karete_EnquiryonlyViewAll] Script Date: 3/4/2019 6:17:28 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[Karete_EnquiryonlyViewAll]
AS
BEGIN
Select * from Tbl_KarateEnquirey
Select COUNT(EnquiryID) EnquiryID
from Tbl_KarateEnquiryFollowup
group by EnquiryID
END
Please Help...
How will I combine these two statements and display it to data grid view like this
Name |Place |Contatct|Age |Date |ExpectedDate|Follow Up Nos|
sample|sample|sample |sample|sample|sample |3 |
Reply
Answers (
2
)
How to read gmails of all users in same domain using imperso
read coordinates (x,y) of 5 point from a file