John - if you do this you'll get your IDs....

select id from myTable where transactionType in (1000, 2000)

group by id having count(*) = 2

However, to pass a dynamic filter,...

Great "thinking outside the box" Sean - I know that I personally hate parantheses as much as I hate the single/double quotes - especially in really lengthy expressions...going to try...

what error msg are you getting ?!

One thing that I can see is in your 'Set' statement - it should actually be...

SELECT @intDspSeqNbr = (max(intDspSeqNbr) + 100) from lu_Ethnicity

...Other than...

try this instead..

 select   C.Id_Client Identificateur,
          NomCli Nom_Client,
          PrenomCli...

how about something like this using govinn's table variable...?!?!

Declare @myTable TABLE
(
[Month] INT,
Users INT
)

INSERT @myTable
SELECT 1, 10 UNION
SELECT 2, 20 UNION
SELECT 3, 10 UNION
SELECT 4, 5 UNION
SELECT 5, 15 


select...

I don't understand what the purpose of this may be...but here's a possible workaround...

<pre class="code"

SET ANSI_WARNINGS OFF

SET ARITHABORT OFF

IF 2/0 IS NULL

BEGIN

SELECT 'Error'

END

SET ANSI_WARNINGS ON

SET ARITHABORT ON

right - except your alias 'JENO' would be after your select max(jeno) + 1...

select (max(JENO) + 1) as JENO from issuesreturns

I am not sure why the id is being used instead of the table name (readability!!!)...but I tried the same query using both id as well as name and got...

You could "SELECT MAX(JENO)" & add 1 to it...

If you want to check for a specific position, then you can use "substring" otherwise you could try something like this - comment out the 'Hullo' first and then '12345'...

Delete the rows from your 'SecurityEvent' table first and then from the 'Agent' table.

Yup remi - some things NEVER change...they're the only constants in this world fraught with variables...

hopefully I'm funny "ha ha" & not funny "peculiar"....

Not that this is the time or place for it, but David - your sentence should read - "YOU'RE the funny one!"

There're a lot of threads on this site for this topic...

Here're a few that a quick search unearthed - maybe one of them will help you..

tsql debugger

debugging problems

Illustration of David's response...

DECLARE @Line1 VARCHAR(25)
DECLARE @Line2 VARCHAR(25)

SET @Line1 = 'I am a clown. '
SET @Line2 = 'I make people laugh!'

PRINT @Line1 +...