Dear All,
Below is my SQL query in which I have used
UNION All In my outer query. so I want to select data
onwards particular date . Is it possible? if yes please reply.
(if you are not getting my question plz revert me)
--------------------------------------------------------------------------------------------------
--KNOW-HOWS
-------------------
SELECT KnowHowID AS Id,
FirstName + ' '+ LastName AS PostedBY,--PostedByID
Title AS Title,
ImagePath AS PhotoGraph,
PostedDateTime AS DateTime,
'knowHows' AS FeatureName,
'' AS cnt
FROM uvw_KnowHows
WHERE Active=1 AND PostedByID IN( --This query is for all friend of this user
SELECT FriendID
FROM tblFriends
WHERE UserID=422973513 AND ISApproved = 1
UNION ALL
SELECT UserID
FROM tblFriends
WHERE FriendID =422973513 AND ISApproved = 1
UNION ALL
--This query is for All members in common network with this user
SELECT FK_UserID
FROM tblNetworkMembers
WHERE FK_NetworkId IN (
SELECT FK_NetworkId
FROM tblNetworkMembers
WHERE FK_UserID=422973513
)
)
UNION All
---------------------------------------------------------------------------------------------------------------------
--NEWS-VIEWS
-------------------
SELECT NewsViewsID AS Id,
FirstName + ' '+ LastName AS PostedBy,
Title AS Title,
ImagePath AS PhotoGraph,
PostedDateTime AS DateTime,
'NewsViews' AS FeatureName,
'' AS cnt
FROM uvw_NewsViews
WHERE Active=1 AND PostedByID IN(
--This query is for all friend of this user
SELECT FriendID
FROM tblFriends
WHERE UserID=422973513 AND ISApproved = 1
UNION ALL
SELECT UserID
FROM tblFriends
WHERE FriendID =422973513 AND ISApproved = 1
UNION ALL
--This query is for All members in common network with this user
SELECT FK_UserID
FROM tblNetworkMembers
WHERE FK_NetworkId IN (
SELECT FK_NetworkId
FROM tblNetworkMembers
WHERE FK_UserID=422973513
)
)
UNION All
---------------------------------------------------------------------------------------------------------------------
--PUBLIC IMAGE
-------------------
SELECT PhotographID AS Id,
FirstName + ' '+ LastName AS PostedBy,
Title AS Title,
[Path] AS PhotoGraph,
PostedDateTime AS DateTime,
'PublicImage' AS FeatureName ,
'' AS cnt
FROM uvw_PublicAlbum
WHERE Active=1 AND UserID IN (
--This query is for all friend of this user
SELECT FriendID
FROM tblFriends
WHERE UserID=422973513 AND ISApproved = 1
UNION ALL
SELECT UserID
FROM tblFriends
WHERE FriendID =422973513 AND ISApproved = 1
UNION ALL
--This query is for All members in common network with this user
SELECT FK_UserID
FROM tblNetworkMembers
WHERE FK_NetworkId IN (
SELECT FK_NetworkId
FROM tblNetworkMembers
WHERE FK_UserID=422973513
)
)