Delete duplicate entry

Hi guys,
How can we delete duplicate entries in a table. please send me a
query which delete duplicate entry from table.Manish Sukhija wrote:

> How can we delete duplicate entries in a table. please
> send me a query which delete duplicate entry from table.
This has been discussed a couple of times the last ws:
http://shurl.org/BrNkD
HTH,
Stijn Verrept.

Defragging SQL Tables

Guys
Firstly I know exceptionally little about SQL so apologies for the newbie
question.
We run SQL 2K at work on a w2k MP box. I'm not charged with looking after
the apps, our MIS team are. We look after the infrastructure. Their users
have complained that the box is slow and after we've carried out numerous
tests to and from the box we've established the fault lies some where at the
app layer on the server.
Our MIS guys have taken to taking the box offline on Saturdays mornings and
stopping all the SQL services and running MS defrag as they believe it will
defrag the tables. I some how don't believe this will help as I thought you
needed to compact the databases/tables inside enterprise manager to get any
redundancy removed from the tables/db's
Can some one please let me know what is the correct way to defrag a SQL db
and if possible follow it up with some MSKB links as evidence
Thanks in advance
Steve
--
If all you have is an axe, every problem looks like hours of fun.Steve,
See:
Microsoft SQL Server 2000 Index Defragmentations Best Practices
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
HTH
Jerry
"Steve Ray" <nochace@.all.com> wrote in message
news:gJR4f.2598$WI4.199@.newsfe4-gui.ntli.net...
> Guys
> Firstly I know exceptionally little about SQL so apologies for the newbie
> question.
> We run SQL 2K at work on a w2k MP box. I'm not charged with looking after
> the apps, our MIS team are. We look after the infrastructure. Their users
> have complained that the box is slow and after we've carried out numerous
> tests to and from the box we've established the fault lies some where at
> the app layer on the server.
> Our MIS guys have taken to taking the box offline on Saturdays mornings
> and stopping all the SQL services and running MS defrag as they believe it
> will defrag the tables. I some how don't believe this will help as I
> thought you needed to compact the databases/tables inside enterprise
> manager to get any redundancy removed from the tables/db's
> Can some one please let me know what is the correct way to defrag a SQL db
> and if possible follow it up with some MSKB links as evidence
> Thanks in advance
> Steve
> --
> If all you have is an axe, every problem looks like hours of fun.
>|||Lookup DBCC INDEXDEFRAG in BOL
DBCC INDEXDEFRAG (DBNAME, TABLENAME, INDEXNAME)
http://sqlservercode.blogspot.com/
"Steve Ray" wrote:
> Guys
> Firstly I know exceptionally little about SQL so apologies for the newbie
> question.
> We run SQL 2K at work on a w2k MP box. I'm not charged with looking after
> the apps, our MIS team are. We look after the infrastructure. Their users
> have complained that the box is slow and after we've carried out numerous
> tests to and from the box we've established the fault lies some where at the
> app layer on the server.
> Our MIS guys have taken to taking the box offline on Saturdays mornings and
> stopping all the SQL services and running MS defrag as they believe it will
> defrag the tables. I some how don't believe this will help as I thought you
> needed to compact the databases/tables inside enterprise manager to get any
> redundancy removed from the tables/db's
> Can some one please let me know what is the correct way to defrag a SQL db
> and if possible follow it up with some MSKB links as evidence
> Thanks in advance
> Steve
> --
> If all you have is an axe, every problem looks like hours of fun.
>
>|||... and just in case they do periodic shrink of database files:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Steve Ray" <nochace@.all.com> wrote in message news:gJR4f.2598$WI4.199@.newsfe4-gui.ntli.net...
> Guys
> Firstly I know exceptionally little about SQL so apologies for the newbie
> question.
> We run SQL 2K at work on a w2k MP box. I'm not charged with looking after
> the apps, our MIS team are. We look after the infrastructure. Their users
> have complained that the box is slow and after we've carried out numerous
> tests to and from the box we've established the fault lies some where at the
> app layer on the server.
> Our MIS guys have taken to taking the box offline on Saturdays mornings and
> stopping all the SQL services and running MS defrag as they believe it will
> defrag the tables. I some how don't believe this will help as I thought you
> needed to compact the databases/tables inside enterprise manager to get any
> redundancy removed from the tables/db's
> Can some one please let me know what is the correct way to defrag a SQL db
> and if possible follow it up with some MSKB links as evidence
> Thanks in advance
> Steve
> --
> If all you have is an axe, every problem looks like hours of fun.
>

default values are passing in the report??

hello guys i am passing the below url in the web browser

http://pc-oreddy/crreports/Final%20COOL%20report1.rpt?user0=crystal&password0=crystal&promptex-Node="www.xpedite.com"&promptex-Manager="All"&promptex-Date=["Datetime(2005,02,18,12,00,00)"-"Datetime(2005,03,10,12,00,00)"]

By default a report is opening with values( i mean the report is not based on the parameter values i am entering in the url). once i click the refresh button in the report, then it is directing me to a page where i have these

The report you requested requires further information.
When you are done, click View Report.

Crystal Parameter Field(s)
You can provide a single range of values for this parameter. Choose or enter a lower and an upper limit to describe the range of values you want to include. Date
Enter the date for which you wish to see the events

Range of values between:
DateTime (2005,02,18,12,00,00) Datetime(2005,02,18,12,00,00)

and
DateTime (2005,03,10,12,00,00) Datetime (2005,03,10,12,00,00)

node......................

manager.....................

preview

when i click preview with out changing any values in the boxes then i am able to see the report actual data i am passing in the url.

so what i need is after entering url i have to get the report based on the parametrs i am entering in the url. Instead of pressing refresh again in the report and then pressing preview. Can some one suggest me a solution for this. please i am in urgent need of it solution. help me out with this.

Thank you,
Reddy.Make sure you have unchecked "Save Data with Report" option