Jeff Moden (8/17/2008)

---

Hi Trevor...

It's odd that you must use a While loop instead of a cursor because a cursor uses a While loop! They both suck performance dry. 🙂

I'd...

karthikeyan (8/11/2008)

---

If we convert it into a SP, then we can change the input values as required.

Create Procedure PrintReverse

(

@NumberToReverse int,

@NoOfTimesRepeat int

)

Select REPLICATE(@NumberToReverse,N)

from Tally,NUM

where N <= @NoOfTimesRepeat

and NumberValue = @NumberToReverse

UNION...

karthikeyan (8/11/2008)

---

Christopher,

why can't we use Tally or Number table ?

My approach :

Select REPLICATE('1',N),N

from Tally,NUM

where N <= 6

and NumberValue = 1

union all

select REP,N from (Select REPLICATE('1',N) as REP ,N

from Tally,NUM

where...

Hi Trevor...

It's odd that you must use a While loop instead of a cursor because a cursor uses a While loop! They both suck performance dry. 🙂

I'd recommend that...

Niyala (8/11/2008)

---

Hi, all,

I am getting the following deadlock message, but I could not figure out what the mentioned rate is.

DBSPI-3271.1: Deadlocks rate for object _Total (110.00/sec) too high (>=3.00/sec)

I...

... and it will require a change to your front end statement. You will need to select from the indexed view, instead.

You might be able to get a whole lot more retrieval speed if you created an Indexed View. Be warned that an indexed view can slow down inputs some.

I believe the first sheet of an Excel file can be referred to as Sheet1$ regardless of it's actual name.

Tally table won't do it, in this...

Lester Policarpio (8/13/2008)

---

"I think" it can be done using a tally table. Some experts here in the forum maybe can share something about it.

And also please read the article...

Heck... I wouldn't even use the WHILE loop... it's RBAR. Most WHILE loop solutions are because someone doesn't know T-SQL well enough to come up with the proper set...

Loner (8/13/2008)

---

It is SQL Server 2000 so I cannot use RANK, that is why I posted the question in this forum.

The one you posted for SQL Server 2000 worked liked...

You can get by without creating the extra temp table...

SELECT d.Name,t.N*10 AS DeciCount

FROM (SELECT Name,COUNT(*) AS TheCount

...

Lian Pretorius (8/12/2008)

---

Same here.

Trevor, Karthik's script above uses a temp table - Which cannot be used in view's...

It means "DataBase Owner" and is a server role. Lookup server roles in Books Online.