Viewing 6 posts - 1 through 6 (of 6 total)
-- Try this.
use pubs
Select RowNumber = Count(ut1.pub_id)
,ut1.pub_id, ut1.pub_name, ut1.[city]
From dbo.publishers ut1 With (nolock),dbo.publishers ut2 With (nolock)
Where ut1.pub_id > ut2.pub_id
Group By ut1.pub_id, ut1.pub_name, ut1.[city]
Order By 1
October 5, 2005 at 8:22 pm
-- Try this.
use pubs
Select RowNumber = Count(ut1.pub_id)
,ut1.pub_id, ut1.pub_name, ut1.[city]
From dbo.publishers ut1 With (nolock),dbo.publishers ut2 With (nolock)
Where ut1.pub_id > ut2.pub_id
Group By ut1.pub_id, ut1.pub_name, ut1.[city]
Order By 1
October 5, 2005 at 8:20 pm
/*create procedure spTestError
as
begin
select * from sysfiles
-- this will fail when called 2nd time
select * into DummyTable from sysfiles
end
/*
You do not have a return value here.
Must be...
September 16, 2005 at 4:18 pm
I have noway of knowing your name, but anyway, your solution is perpect and it work exactly what I always have wanted.
Again, With the references and scripts you all offered,...
July 21, 2004 at 7:30 am
Thank you very much Good Hunting,
I really appreciate your opinion, and I value it. And I must say that your opinion very helpful.
Thank you again.
Yes, I did have a table...
July 21, 2004 at 7:18 am
First, thank you very much for your prompt answer. I am really appreciated that.
I already have implemented a job to monitor the process using time control as what you have...
October 29, 2003 at 6:32 am
Viewing 6 posts - 1 through 6 (of 6 total)