Advertisement
Guest User

Untitled

a guest
Mar 16th, 2010
218
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.43 KB | None | 0 0
  1. EXEC sp_executesql N'SELECT
  2. CASE WHEN ( EXISTS (SELECT
  3.     1 AS [C1]
  4.     FROM [dbo].[User] AS [Extent1]
  5.     WHERE ( EXISTS (SELECT
  6.         1 AS [C1]
  7.         FROM [dbo].[UserFriends] AS [Extent2]
  8.         WHERE ([Extent1].[UserKey] = [Extent2].[FrienderId]) AND ([Extent2].[FrienderId] = @p__linq__0) AND ([Extent2].[isApproved] = 1)
  9.     )) OR ( EXISTS (SELECT
  10.         1 AS [C1]
  11.         FROM [dbo].[User] AS [Extent3]
  12.         WHERE  EXISTS (SELECT
  13.             1 AS [C1]
  14.             FROM [dbo].[UserFriends] AS [Extent4]
  15.             WHERE ([Extent3].[UserKey] = [Extent4].[FrienderId]) AND ([Extent4].[FriendeeId] = @p__linq__1) AND ([Extent4].[isApproved] = 1)
  16.         )
  17.     ))
  18. )) THEN cast(1 as bit) WHEN ( NOT EXISTS (SELECT
  19.     1 AS [C1]
  20.     FROM [dbo].[User] AS [Extent5]
  21.     WHERE ( EXISTS (SELECT
  22.         1 AS [C1]
  23.         FROM [dbo].[UserFriends] AS [Extent6]
  24.         WHERE ([Extent5].[UserKey] = [Extent6].[FrienderId]) AND ([Extent6].[FrienderId] = @p__linq__0) AND ([Extent6].[isApproved] = 1)
  25.     )) OR ( EXISTS (SELECT
  26.         1 AS [C1]
  27.         FROM [dbo].[User] AS [Extent7]
  28.         WHERE  EXISTS (SELECT
  29.             1 AS [C1]
  30.             FROM [dbo].[UserFriends] AS [Extent8]
  31.             WHERE ([Extent7].[UserKey] = [Extent8].[FrienderId]) AND ([Extent8].[FriendeeId] = @p__linq__1) AND ([Extent8].[isApproved] = 1)
  32.         )
  33.     ))
  34. )) THEN cast(0 as bit) END AS [C1]
  35. FROM  ( SELECT 1 AS X ) AS [SingleRowTable1]',N'@p__linq__0 uniqueidentifier,@p__linq__1 uniqueidentifier',@p__linq__0='1BB7438A-F0A4-45EE-9EC6-64CC3796FA2B',@p__linq__1='1BB7438A-F0A4-45EE-9EC6-64CC3796FA2B'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement