-
24th August 2010, 06:59 PM
#81
Senior Member
Platinum Hubber
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
-
24th August 2010 06:59 PM
# ADS
Circuit advertisement
-
24th August 2010, 07:03 PM
#82
Senior Member
Diamond Hubber
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
Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye
-
21st September 2010, 07:12 PM
#83
Senior Member
Diamond Hubber
App anneh and others
What is the point of using 'Begin try' and 'end try' in SQL ?
in advance
Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye
-
21st September 2010, 07:18 PM
#84
Senior Member
Diamond Hubber
And the same question about 'Begin catch' and 'end catch' ?? is it something to do with error messages in SQL ??
Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye
-
21st September 2010, 07:22 PM
#85
Senior Member
Platinum Hubber
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.
-
21st September 2010, 07:30 PM
#86
Senior Member
Diamond Hubber
app anneh
I had a feeling it would be something to do with error handling
Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye
-
22nd September 2010, 01:01 PM
#87
Senior Member
Senior Hubber
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
-
22nd September 2010, 07:50 PM
#88
Senior Member
Veteran Hubber
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.
Damager - 30 roovaa da, 30 roovaa kuduththa 3 naaL kaNNu muzhichchu vElai senju 30 pakkam OttuvaNdaa!
-
23rd September 2010, 02:51 PM
#89
Senior Member
Diamond Hubber
kirukan for your 'detailed' explanation.
Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye
-
7th October 2010, 01:47 PM
#90
Senior Member
Veteran Hubber
How to resolve 403-forbidden error?... I am not able to access few sites and I get this 403 error.
“The real contest is always between what you've done and what you're capable of doing. You measure yourself against yourself and nobody else.” - Geoffrey Gaberino
Bookmarks