Viewing 15 posts - 33,616 through 33,630 (of 59,102 total)
Sriram.RM (6/16/2011)
SET ROWCOUNT 1
DELETE YOURTABLE
FROM YOURTABLE A WHERE (SELECT COUNT(*) FROM YOURTABLE B WHERE A.COLNAME=B.COLNAME) >1
WHILE @@ROWCOUNT >0
DELETE YOURTABLE
FROM YOURTABLE A WHERE (SELECT COUNT(*) FROM YOURTABLE...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 17, 2011 at 5:03 am
vaibhavraut88 (6/16/2011)
Great Job dude ur script works. but can u explain me that code.
Ummm.... which script? The one with the WHILE Loop or the other one?
--Jeff Moden
Change is inevitable... Change for the better is not.
June 17, 2011 at 5:01 am
opc.three (6/16/2011)
:Wow: I just set myself up big time huh?
Nah... considering the number of hacker attacks designed specifically to exploit OLE DB Automation, I can see your point especially in...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 17, 2011 at 4:50 am
My recommendation, at this point, would be to write the trigger you want for one database and post it. We'll help you write code to distribute it to a...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 17, 2011 at 4:10 am
chelta (6/16/2011)
Ideally we want to be able to 'pick' what databases its installed on and automate it. There may be new user databases created that we dont want it...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 17, 2011 at 4:04 am
Leo.Miller (6/16/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 16, 2011 at 10:12 pm
andersg98 (6/16/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 16, 2011 at 10:04 pm
Crud. I knew this looked all too familiar. We have a process at work that I developed to do something very, very similar and there's a patent pending...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 16, 2011 at 9:38 pm
Ok... I've got it. It'll take me a bit to modify the code.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 16, 2011 at 8:12 pm
nguyennd (6/16/2011)
I'm remove *, from the code and result is:
A
--A1
----A1.1
------Item Code = 3
--A2
----A2.1
------Item Code = 1
----A2.2
------Item Code = 2
--A3
B
C
But i need result is:
A
--A2
----A2.1
------Item Code = 1
----A2.2
------Item Code =...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 16, 2011 at 7:57 pm
Ok... will the real "Jayanth_Kurup" please stand up? Why two separate logins or are there really two people with the same name on this thread?
--Jeff Moden
Change is inevitable... Change for the better is not.
June 16, 2011 at 7:35 pm
Shamshad Ali (6/17/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 16, 2011 at 7:32 pm
opc.three (6/16/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 16, 2011 at 7:25 pm
opc.three (6/16/2011)
Jeff Moden (6/16/2011)
You didn't read the entire post! 😉 I told you how to get that. Just remove the "*," from the code. 😉
Nice...and with 2 minutes...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 16, 2011 at 5:21 pm
opc.three (6/16/2011)
No.How's that for short, sweet and accurate? 😉
That absolutely works for me. 😀 It would be very cool if you told me what you use instead. I...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 16, 2011 at 5:19 pm
Viewing 15 posts - 33,616 through 33,630 (of 59,102 total)