Hi Shashank

I felt something missing in the article. Overall the article seems incomplete. The process may not the best but you tried something different. 🙂

Hi Jack

The article was nice. It also pointed some good areas of error.

🙂

shamshudheen (4/21/2008)

i used the given example, but i got error saying

Server: Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'WITH'.

i am using sql server 2000, I...

Good one. But to understand it I have to use.

Thanks ........:)

Please post your solution. It would be nice reference for lot of us.:)

Read this one:

Recursive Queries in SQL Server 2005

By Srinivas Sampath, 2005/03/03

http://www.sqlservercentral.com/articles/Development/recursivequeriesinsqlserver2005/1760/

Nice and wonderful article with some good examples. 🙂

select [id], max([order])

from #a

group by [id]

order by max([order]) asc

The above T-SQL statement is wrong. You required Group By clause as you are using MAX function. The statement will return only...

I am not sure what will be future of openings if the recession goes bad to worse. But I found one thing DBAs are now required by different sectors and...

CREATE PROCEDURE _4P_test

@intInput int,

@intOutput int OUTPUT

AS

set @intOutput = @intInput + 1

go

Call it like this:

declare @intResult int

exec _4P_test 3 ,@intResult OUT

select @intResult

Read this example also:

http://www.tek-tips.com/viewthread.cfm?qid=1461110&page=9

As I told...

Check this whether it works or not:

ALTER INDEX [IX_name] ON table DISABLE

GO

I don't have 2000 so I can't test it but found this solution in 2-3 sites.

Hope it works.:)

Also read...

This may not be the best solution but this can be a good solution. The article is good.

🙂

A very good series based on indexes. Good for the newbies.......:)