Change uoyr query

SELECT [date]

FROM Table1 T

LEFT OUTER JOIN ( SELECT MIN([date]) as DT

FROM Table1

GROUP BY [date], PhoneNumber, Amount) T1

ON T.[date] = T1.[DT]

WHERE T1.[DT] IS NULL

Following is a good article which match exactly with your requirements

http://www.sqlservercentral.com/columnists/ccubley/findinganddeletingduplicatedata.asp

Thank you

But can we chnage the primary file name from ALter Datbabase ???

Thankx Jonathan,

I thought there should be a easy way of doing it from sql server 🙁

anyway thank for the answer

fix is available

http://support.microsoft.com/kb/834798

I have done this by using vb 6 and Microsoft ADO 2.5 and set it into the following project reference:

dim rst as new adodb.recordset

dim adoConn as new adodb.Connection

You...

Set rs=Server.CreateObject("ADODB.Recordset")

sql = "SELECT rr.RaceLogRsltsID, rr.FinalTime, rg.RaceDist, rg.RaceType, rg.EventName, rg.EventDate, rg.RaceLogID "

sql = sql & "FROM RaceLog rg INNER JOIN RaceLogRslts rr ON rr.RaceLogID = rg.RaceLogID "

sql = sql &...

include [

EXEC ('drop table ['+ @servername+'data]')

EXEC ('SELECT name into ['+@servername+'data] FROM ['+ @servername+ '].master.dbo.sysdatabases')

Hey, this script is working well for me. what is your server may be key words are used for databaases

When i run that script i get

(18 row(s) affected)

What is your recovery method

This might be time out issue. There is another way of upgrdaing access to SQL Server by using Access Upgrade Wizard which is an inbuilt function in access.

When I searched...

Good and Simple tool

I am really intersted on this article

but how can find those IDs in my enviroment

strOlStoreID = "18DE200A0C99D6DC800AA002FC45A06000000504B435654303100D"

strOlEntryID = "5B7D1118DE200A0C99D6DCCCBA91795B7D11145A06000000504B435654300000"

seems to be a good article

but

is this query correct

CREATE TABLE [tblCpls] (

[cplNum] [int] NULL ,

[cplName] [varchar] (4000) NULL ,

[cplDesc] [varchar] (1000) NULL,

CONSTRAINT [PK_tblList] PRIMARY KEY CLUSTERED...

thankx for the info.

this is a special purpose