You are welcome, the credits goes to Kamran Ali!

😎

hmmm take a look around some info from here:

http://www.sqlservercentral.com/articles/SQL+Puzzles/eliminatingcursors/2223/%5B/url%5D

:hehe:

Yea nice question ... also i point for the experience!

😎

Plz, don't do double posts! All reply should be here

http://www.sqlservercentral.com/Forums/FindPost661081.aspx

Plz, don't do double posts! All reply should be here

http://www.sqlservercentral.com/Forums/FindPost661081.aspx

hehehe you are here sql:

BEGIN problem

....

....

....

COMMIT solution! - sql's position

:hehe::hehe::hehe:...

Be more specific about your problem ...!? What is that you cannot find with percentage!?

seem easy or maybe I don't understand very well your question here:

there is one of the solution:

CREATE TABLE TTT

(

ID INT IDENTITY (1,1) NOT NULL,

CHARS varchar(100)

)

INSERT INTO TTT

SELECT 'a;b;cde;f;ghi;d' UNION ALL

SELECT...

Do you want to generate the ID numbers from 1 to .... in order or you have other values that you should find the MAX value then the new record...

ayi_102 (2/4/2009)

---

Hi,

i am doing my database project using SQL Server 2005

but i made a mistake since i dont use primary key

this is the problem

ID Name...

...and final decision is !?

1) form SQL 7 >>> SQL 2000 >>>> SQL 2008

2) from SQL 7 >>>> SQL 2005 >>> SQL 2008

..and the winner...

Chris Morris (1/30/2009)

---

Try this...

DROP TABLE #Temp

CREATE TABLE #Temp (Users VARCHAR(10), [DateTime] DATETIME, Sections VARCHAR(1), Title VARCHAR(1))

INSERT INTO #Temp (Users, [DateTime], Sections, Title)

SELECT 'Client1', '2009-01-30 08:00 AM', 'I', 'A' UNION...

Just to be sure that this code above is just to find you solution here, as you can see I didn't count nothing just generating the number in order by...

this is the little code and the situation like yours I didn't have yet and sure that the others can have better idea how to do that but try and...

Now is Ok! :w00t: thnx for the sp info!