Please, review the code I sent as there are some errors I didn't see, mainly because I can't test the code. I hope you get the idea of what it's...

That's taking the new position_id and adding the...

Something like this?

DECLARE @TableTable(

User_ID int,

Phone_Numbervarchar(20),

AddBy_UserIDint)

INSERT @Table

SELECT 1, '0194523638', 0 UNION ALL

SELECT 2, '1122334455', 1 UNION ALL

SELECT 3, '1122334456', 1 UNION ALL

SELECT 4, '1111111111', 2 UNION ALL

SELECT 5, '222222222 ',1...

That's correct.

It should perform much better, assuming the results are correct.

Yes, that's why I wanted to know what GetUpLdNextInstance is doing.

I just noticed that I erased the first one on my code by accident. I'm putting it back on now.

For SQL Server 2000 you should use syscomments table.

You might not need it, but it's a good thing to now.

I'm sure there's a way to avoid the SPs to obtain the Next IDs, but here's a possible suggestion.

I can't assure it will work, but it can give you an...

SELECT o.name

FROM sys.sql_modules m

JOIN sys.objects o ON m.object_id = o.object_id

WHERE definition like '%Employee%'

Something like this?

SELECT CONVERT( varchar(23), GETDATE(), 121)+'000'

If its datetime2 instead of datetime, you can use varchar(26) with no concatenation.

You might be able to use something like this:

I'm not sure if it would work as I can't see the DDL, but it can give you an idea.

Update A

SET col1...

I'm sorry, I didn't see the forum's name :blush:

Try to look for First Normal Form or Database normalization.

Here's a start:

http://www.sqlservercentral.com/blogs/jamesserra/2012/01/06/normalizing-your-database/

Phil Parkin (8/29/2012)

---

Luis Cazares (8/29/2012)

---

It should be char or varchar.

Ideally you should only store the digits and format the phone in the front end. However, you'll need an extra field...

How about this? It might be expensive, but it's a solution.

WITH names( fullname) AS(

SELECT 'shah, anki S.' UNION ALL

SELECT 'dogula nanacy' UNION ALL

SELECT 'baskin brian B' UNION ALL

SELECT...

It should be char or varchar.

Ideally you should only store the digits and format the phone in the front end. However, you'll need an extra field for extension if needed.