Viewing 15 posts - 1 through 15 (of 66 total)
Hi that worked but i have to make some more changes
can i do if testkey exist then ony update the timestamp = getdate() else insert?
create
September 12, 2007 at 5:03 pm
Hi Joe,
How are you! if you haven't selected the person to help. I am willing to help also.
my contact info is db_dba2006@hotmail.com
Thanks
June 6, 2007 at 8:02 pm
i still get same result
0.00 1920.96 19
159761.82 0.00 19
136151.20 0.00 23
0.00 2178.57 23
0.00 15.08 27 <--
116061.63 0.00 27
I want is like
159761.82 1920.96 19
136151.20 2178.57 23
116061.63 15.08 27
April 11, 2007 at 10:18 am
hi if i try doing is gruping at last quiery in union i get
is invalid in the select list because it is not contained in either an aggregate
data...
April 11, 2007 at 9:08 am
bellow is the code
ALTER TRIGGER [dbo].[updateOnErrors] ON [dbo].[bandwidth]
FOR UPDATE
AS
SET NOCOUNT ON
DECLARE @thisAdd VARCHAR(15),
@thisDIR VARCHAR(50),
@thisFN VARCHAR(50),
@thisQ VARCHAR(10),
@thisSer VARCHAR(10),
@thistest VARCHAR(50),
@thisNumber INT,
@firstIP INT,
@SecondIP INT,
@ThirdIP INT
SELECT @thisAdd = i.ipAddress, @thisNumber = i.errorNumber
FROM...
April 4, 2007 at 10:56 am
that way it does not work either. I need to get result in one line fro both view and procedure. Is it possible if i create cursor?
Thanks
March 29, 2007 at 12:50 pm
I tried creating script on SQL 200 and then run on 2005 but it gives me error for
Password validation failed. The password does not meet Windows policy requirements...
December 14, 2006 at 2:17 pm
but how can i schedule that so it can run automatically. Also Agent is dependent on that.
December 5, 2006 at 8:02 am
I have to restart it due to some billing batch and also web app too .
to schedule it from Windows scheduled task What do i have to do? I...
December 5, 2006 at 7:02 am
yes. It is valid with full rights to read and write.
thanks
November 20, 2006 at 7:54 am
Hi How can i check if "use Windows NT fibers" setting up in my SQL server 2000 Ent. Edition?
September 27, 2006 at 7:31 am
i check the permission but everything looks fine to me and on top of that the copy and restore job works perfectly fine and all the changes also goes through so...
August 21, 2006 at 8:28 am
Can i change to SQL log on now? if so then how!!!?
Thanks
August 21, 2006 at 8:13 am
use reverse engineering on visio data diagram it will give you all the schema such as FK relation ship and details too.
August 1, 2006 at 2:43 pm
I am missing that drive!! so how can i put new temp db file from another db server and also can i re direct it so can server get restarted!!
Thanks
July 26, 2006 at 3:03 pm
Viewing 15 posts - 1 through 15 (of 66 total)