I do agree with Jeff that for perromance sake you should use the newID but if you need ramdoness quality rand() is the way to go.

You and that article said:...

Jeff,

I was just answering the question posted by Carl. He was looking into using "another" tally table.

In rergards to speed. I can tell you that it is going to be faster...

when was the last time that you ran dbcc checkdb on that DB? were there any errors?

Make it a view and then modify view output as:

select v.Category, v.Balances, v.Balances/t.Total as [% of Total]

from

    vwBalances v

    cross join

    (select sum(Balances) as Total from vwBalances) t

Cheers,

For some things, you don't need the tally table

SELECT SentenceID, 

  datalength(Left(' '+y.Sentence+' ', N)) - datalength(replace(Left(' '+y.Sentence+' ', N), ' ', ''))InSentenceNo,

        SUBSTRING('...

have a look at the scope_identity() function

Cheers,

Just for completeness you can tune the MemToLeave area with the -g startup parameter

Cheers,

Papers:

http://www.Only4Gurus.com

Searches:

Google

Fun:

http://www.sqlservercentral.com

Cheers,

The Best Blue Screen Ever

Well if you really want to try here you go:

if object_id('tempdb..#ipaddress') is not null

 drop table #ipaddress

create table #ipaddress ( address varchar(80) null )

declare @cmd varchar(300)

select @cmd = 'ping -n 1...

Just to make something clear:

if the type is always the sam SQL Server 2000 can handle 2100

And to be honest, if you need more than that there are probably bigger...

You need to repair consistency errors.

Try the NO DATA LOSS OPTIONS FIRST of the dbcc checkdb.

example:

 dbcc checkdb ('DatabaseName', REPAIR_FAST)

if still reports errors then:

dbcc checkdb ('DatabaseName', REPAIR_REBUILD)

and hopefully you will...

OR

Select  pothole_ky

      , rate

      ,  addr

      ,  roadway

      ,  intersection

      ,  location

      ,  comment

      ,  email

      ,  state

      ,  member

      ,  emailAddr

      ,  entry_time                                            

  From

       pothole

  Where

         rate ...

http://support.microsoft.com/default.aspx?scid=kb;en-us;299410

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/distributed_query.asp

http://msdn.microsoft.com/library/en-us/adsi/adsi/distributed_query.asp?frame=true

Cheers,

Joe,

If you include the "DATE" in the grouping you always going to have the separation because  a day can only belong to one and only one year