I'll keep ou up-to-date.  Think we will test it this afternoon with 10 users.

I'm curious, could a procedure be written that would pull the "next" account where say 1000 users were on the system and no one user would get the same account?

The...

I'm not sure what you mean but would appreciate any suggestions.

Thanks.  In table AccountData AcctNo is unique.  By adding AcctManager to the primary key it sounds like I have not gained any indexing benefit (or do I gain some benefit,...

This test example works, but my previous example does not.  I don't see any differences.

DECLARE @dog as int

SELECT @dog = 999

UPDATE Test1 SET

Test = 1,

I looked at this last night.  Disregard my original diagnosis.

After messing with this all it took was using the UNC in the bulk insert statement and all is fine.  Thanks!

I changed the test data a bit.  We are not looking at dollar amount in this.  Account C and D had 5 records within an hour.

The result of this query...

I goofed up:

a) If there are more than 4 records in any consecutive 60 minute period.

should be

a) If there are more than 4 records in any consecutive 60 minute period...

I started this thread, do I get a headhunters fee?

Yikes, I'm getting tired.  I made a simple example but posted the wrong one.  Here is the simple example.

DECLARE @UseIt1 as varchar(100)

EXEC ('SELECT @UseIt1 = 1')

SUBSTRING(ActionId, CHARINDEX('pg',ActionId) + 2, 3)

If I grab just 3 characters after 'pg' it should always be:

one numeric and 'of'

or

two numerics and 'o'

So stripping alphas at that point is just looking...

I'm thinking strpping anything other than numerics is the way to go.

That way if someone puts an alpha in the wrong spot, I'm going to always end up with only...

Well it worked until I got more than a record or so in it.  Knew it looked ugly, lol.

error:

Server: Msg 512, Level 16, State 1, Line 1

Subquery returned more than...

This works, probably not best way to do this?  Any suggestions would be appreciated.

INSERT INTO InsertIfNoMatch

(AcctNo, Code)

SELECT

AcctNo, Code

FROM InsertIfNoMatch_DATA

WHERE AcctNo <>

(SELECT AcctNo FROM InsertIfNoMatch

 WHERE Code = 'z'

 AND AcctNo...

Figured it out.  My VB6 application had (LOCAL) as the server.  When I moved the app to another machine, I needed to have the name of the machine as the...