USE tempdb

GO

Declare @TotalRows int, @minRow int

CREATE TABLE #Temp

( Id int identity(1,1),

Queue_stub uniqueidentifier

)

INSERT INTO #temp

SELECT Queue_Stub

FROM <table_name> WHERE condition

SET @TotalRows=@@Rowcount

SET @minRow=1

--Using loops

DECLARE @queue_stub uniqueidentifier

SET @queue_stub = ''

WHILE @minRow <=@TotalRows

BEGIN

...

oki,.. thankss

hardcode*

all,,

i got my solution... thanks newaz...

the query will work as

Select * from <table>

the Or condition Name = 'Bob' is supressed bt the condition 1 = 1.

exists keyword has its own flaw... you can try the IN keyword( reff in one of the posts)... but make sure to give only 1 select column name in the...

try subquery such as --->

SELECT agencyName,agencyId

FROM contactAction

WHERE EXISTS

(

SELECT agencyName,count(*)

FROM contactAction

GROUP BY agencyName

HAVING COUNT(*) <> 1

)

logic :---

SELECT @message = queue_message FROM tablename

WHERE PK= @pk

IF (@PK is not null...