Viewing 15 posts - 16 through 30 (of 39 total)
Haha -
Thanks for the replies.. but the complaints wont be so funny in a banking environment. 🙂
July 29, 2008 at 2:46 pm
Thanks for the reply.
What I want to do is find out which objects are not in use so I could get rid of them in order to free...
July 29, 2008 at 11:12 am
just insert rest of values into table too.
July 16, 2008 at 6:56 am
well - try this
create table test99
(seq int, strin varchar(2))
insert into test99
values (3, 'ol')
insert into test99
values (3, 'iu')
select distinct z.seq,
(select top 1 strin
from test99 x
where...
July 16, 2008 at 6:55 am
Here is a much better solution.
CREATE FUNCTION dbo.fnGetValue
(
@id VarChar(30)
)
RETURNS VARCHAR(8000)
...
July 16, 2008 at 5:24 am
I am actually doing the same as you want to do. All I did was created the linked server, and my code is :
INSERT INTO Sysprocesses_local
SELECT * FROM ExternalServer01.master.dbo.sysprocesses
No...
July 16, 2008 at 5:12 am
Go to Enterprise manager, under the Security folder go to Linked servers. Right click, add new linked server. Choose the server that you want. Then you...
July 16, 2008 at 3:55 am
Create a linked server. That should solve your problem
July 16, 2008 at 3:50 am
PS. This was my sample data
create table test99
(id varchar(30), name varchar(40), value varchar(40), posn int)
insert into test99 values ('HOXE', 'EMAIL', 'asdf@asdf', 30)
insert into test99 values ('HOXE', 'FAX', '9999', 11)
insert...
July 16, 2008 at 3:14 am
Hi
Here is a quick and dirty way of doing it. Im sure there is more elegant ways - but this was all I had time for.
DECLARE @id Varchar(30),
...
July 16, 2008 at 3:08 am
Thanks a lot! I looked at the wrong place to set the result length. I was looking in profiler options, not in query analyzer. It does show the...
June 24, 2008 at 5:47 am
Maybe its because Im working on SQL 2000? I cannot find that setting. In the trace properties there is only Save to table, and 'set maximum rows'. ...
June 24, 2008 at 5:35 am
We have major problems on blocking processes. It is difficult to pinpoint exactly which processes/sps are causing the locks. I think it might be query optimizer that chooses...
June 12, 2008 at 8:47 am
Let me explain what I want to do. I have a table that gets updated with a bunch of system info, including spids. I need to update the...
June 11, 2008 at 1:48 am
Try the following - that the result you want?
begin tran
create table a (clientid int,
Unitbalance numeric(21,0),
Dates datetime)
insert into a values (123, 999, '1 jan 2008 12:00:01:001')
insert into a...
June 10, 2008 at 5:58 am
Viewing 15 posts - 16 through 30 (of 39 total)