Also asked and answered here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=108531

1) This is a SQL Server 2000 forum

2) Also asked here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=108533

See my first post.

It finds all NTLogins that have characters other than a-z and 0-9.

Funketekun in disguise.

You can use a derived table.SELECT....

fromA

left join(

SELECT*

FROMB

inner joinC on c.field4 = b.field3

) AS x on x.field2 on a.field1

You can use a recursive CTE.

Books Online has examples of this.

I thought PASS in Europe happened in April?

http://www.european-pass-conference.com/%5B/url%5D

Are there more PASS conferences?

Oh, I see now that you are one of those "yankees" 😀

November 18-21, 2008

Washington State Convention & Trade Center,...

Well put.

I just demonstrated that we know to little about OP environment and code to make helpful suggestions.

SELECT * FROM Users

WHERE UserName LIKE '%[^a-z0-9]%'

Here is another reason causing @@IDENTITY returning "wrong" value

declare @abc table (i int identity(100,1), j int)

insert @abc values (1)

SELECT @@IDENTITY AS [WhatID?]

declare @mytab table (id int identity(1, 1), myfield tinyint)

INSERT...

Well, nothing is as hard as posting a question instead of reading Books Online.

http://msdn.microsoft.com/en-us/library/ms187342.aspx

Do you have some transactions around the insert statement?

Have you tried using SCOPE_IDENTITY() function yet?

If you have many users running inserts against same table, @@IDENTITY can returns any users last ID (regardless of scope).

DECLARE@d INT,

@t INT

SELECT@d = 20080504,-- May 4, 2008

@t = 42412-- 4:24:12 AM

SELECTCAST(STR(@d, 8, 0) AS DATETIME),

CAST(STUFF(STUFF(STR(@t, 6, 0), 3, 0, ':'), 6, 0, ':') AS DATETIME)

You can use SET ROWCOUNT instead of using TOP.

DECLARE@Sample TABLE

(

Name VARCHAR(5),

Age TINYINT,

Sex CHAR(1)

)

INSERT@Sample

SELECT'ABC', 24, 'M' UNION ALL

SELECT'ABC', 24, 'M' UNION ALL

SELECT'DEF', 24, 'M' UNION ALL

SELECT'DEF', 24, 'F' UNION ALL

SELECT'GHI', 26,...