riya_dave (7/10/2013)
select distinct rl.Id,rl.AlarmId, rl.Name
From T.dbo.BHI_Alarm ra with (nolock)
Inner Join T.dbo.BHI_Library rl with (nolock)
On rl.id = ra.id
and rl.BatchId = ra.BatchId
and rl.nameid = @nameid
and rl.AId = @AId
and (ra.memberid = @memberid or ra.CustomerId = @cid)
Can you share some details? What are trying to add to your query? What do the tables look like?
And be careful with using the NOLOCK hint. Do you know what that hint brings to the table? http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/