Guest User

Untitled

a guest
Nov 16th, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. declare @ProjectID int
  2. declare @Keyword nvarchar(255)
  3. declare @SEID int
  4.  
  5. select distinct
  6. @ProjectID=Project_Id,
  7. @Keyword=keyword,
  8. @SEID=SE_Id
  9. from [RL].[SearchMetrics_ProjectKeyword] --it returns 120 rows
  10.  
  11. while @ProjectID is not null
  12. begin
  13. SELECT *
  14. FROM Table 1
  15. where ID = @ProjectID
  16. and Keyword = @Keyword
  17. and SEID = @SEID
  18. end
Add Comment
Please, Sign In to add comment