Try this. (using the temp table as proposed by arun.sas) for this test

;with numbered as(SELECT rowno=row_number() over(partition by reg_no,leave,typeid order by reg_no),

reg_no,ID,leave,typeid,allowed,remarks from #temp1)

Then use the following to verify...

From Books On Line (The SQL help file)

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/09a6e0c2-d8fd-453f-9aac-4ff24a97dc1f.htm This portion of BOL is a lot of reading, but well worth it!!

Full backup

A full backup contains all the data in a...

Getting back to unusual license plates

.

Observed a Silver Cloud Rolls Royce moving down the road with...

Is your developer of the VB6 application testing for returned errors in the existing code?

From the Help file for VB6 and ADO

Any operation involving ADO objects can generate one or...

Use Books On Line (The SQL Server help file) Read the following

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/a7b1b9b0-7c19-4acc-9de3-3a7c5e70694d.htm

For a meaningful reply / suggestions please post the information outlined in my signature block, that is a create table statement, some sample data, etc...

Congratulations on running your statement on...

cos_ta393

I have found this to be an excellent source for importing data from Excel, hopefully it will have enough information to assist yourself.

http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

Another good read is:

http://www.mssqltips.com/tip.asp?tip=1202

Both sites contain sample code....

What EXCEL revision are you using pre 2007 or 2007? Note that 2007 uses a different driver.

This forum may have what you need if you are using 2007

http://www.sqlservercentral.com/Forums/Topic477652-148-1.aspx

Mischa E.J. Hoogendoorn - You can purchase the DEVELOPER edition of SQL...

hakan.winther

In answer to your question:

BOL link

http://msdn.microsoft.com/en-us/library/ms189858(SQL.90).aspx

Which recommends:

avg_fragmentation_in_percent value Corrective statement

> 5% and 30% ...

Have you considered using the CHARINDEX function: For example:

SELECT CHARINDEX('T:','[\\Servername\PhysicalDisk(7 T:)\Disk Reads/sec]' which will return the value 30.

and

SELECT CHARINDEX('T:','[\\Servername\PhysicalDisk(7 L:)\Disk Reads/sec]') returns a value of 0.

Based on the above...

Read this forum post -- it contains the necessary VB6 code that you are requesing

http://www.sqlservercentral.com/Forums/Topic747115-1291-1.aspx#bm747122

An extract from the question as published

- emphasis added for this post.

Please note that the question specifically cited...

The question was not intended to be tricky, but to draw attention to an easily overlooked...

kopajb

Being a developer rather than a true DBA. Sort of inherited the job when my employer did not see the need to increase staffing. So I fumble...