IT Professionals

**app_engine** · 24th August 2010, 06:59 PM

Another link suggests this for SQL-Server (looks like it has the partition by function)

To remove duplicates, on SQL Server 2005 you can use this query:

WITH Dups
AS
(SELECT *, ROW_NUMBER() OVER(
PARTITION BY col1, col2, col3, col4, col5, col6, col7, col8,
col9, col10
ORDER BY col1) AS seq
FROM Table)
DELETE Dups
WHERE seq > 1;

Give it a try

**Google Adsense** · 24th August 2010 06:59 PM

**PARAMASHIVAN** · 24th August 2010, 07:03 PM

Thanks na for all these trouble you went to get the aboev info

Going for short sleep now (team meeting)

will give it a go later

thanks again

**PARAMASHIVAN** · 21st September 2010, 07:12 PM

App anneh and others

What is the point of using 'Begin try' and 'end try' in SQL ?

in advance

**PARAMASHIVAN** · 21st September 2010, 07:18 PM

And the same question about 'Begin catch' and 'end catch' ?? is it something to do with error messages in SQL ??

**app_engine** · 21st September 2010, 07:22 PM

Param,
Not an Oracle thingy - SQL Server stuff and I've not used.

This technet link seems to explain this very well:

http://technet.microsoft.com/en-us/l.../ms179296.aspx

Sounds like a debugging tool.

**PARAMASHIVAN** · 21st September 2010, 07:30 PM

app anneh

I had a feeling it would be something to do with error handling

**kirukan** · 22nd September 2010, 01:01 PM

Originally Posted by PARAMASHIVAN

app anneh

I had a feeling it would be something to do with error handling

Yes you are right its for error handling introduced from sql2005...

It will be very handy in procedures

begin try
begin tran
insert into Table values(57,'AAA','AA')
insert into Table values(58,'AAA','AA')
insert into Table values(59,'AAA','AA')
insert into Table values(57,'AAA','AA')
commit
select 'Success'
end try
begin catch
select 'Failure'
rollback
end catch

Any DML exceptions will be caught (primary key ,Arithmetic overflow,string or binary etc)
-
kirukkan

**sathya_1979** · 22nd September 2010, 07:50 PM

Regarding Status Reports:
Anybody here had sent / have an idea to reflect the status of a project (Daily Report) in terms of dollar value rather than just % of work completed?
Any easy defining and tracking mechanish, pls PM me.