Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- declare @ProjectID int
- declare @Keyword nvarchar(255)
- declare @SEID int
- select distinct
- @ProjectID=Project_Id,
- @Keyword=keyword,
- @SEID=SE_Id
- from [RL].[SearchMetrics_ProjectKeyword] --it returns 120 rows
- while @ProjectID is not null
- begin
- SELECT *
- FROM Table 1
- where ID = @ProjectID
- and Keyword = @Keyword
- and SEID = @SEID
- end
Add Comment
Please, Sign In to add comment